Filter Question?

[Alvin R. Williams]

I have three columns with several numerical entries that requires filtering to show the largest number and the smallest number in two other cells on the same sheet. I have used the auto filter and advance filter without success, (The filtered columns collapses). Can you help

Al (Novice Excel User)

 

[Debra Dalgleish]

Can you type an example of your data? What's in the three columns, where
are the other cells that you mentioned, and what results are you trying
to see?

 

[Earl Kiosterud]

Alvin,

In the cell that should yield the largest number, use something like:
=MAX(A:A)
=MAX(A2:A65536)

If you want to see the entire row(s) of the largest value in a column, try a
formula like:
=IF(B2=MAX($B$2:$B$65536),"Largest","")
=IF(B4=MAX(B:B),"Largest","")

Then autofilter for "Largest." If there are duplicate largest, you'll get
them all.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I have three columns with several numerical entries that requires

filtering to show the largest number and the smallest number in two other
cells on the same sheet. I have used the auto filter and advance filter
without success, (The filtered columns collapses). Can you help.

 

[Alvin R. Williams]

Debra and Earl: Thanks Earl both MAX function worked like a char

Debra: the function was this: =MAX(number1:number2) o
=IF(number1=MAX($number$1:$number$2),"Largest","")) or=IF(number1)=MAX(number:number),"Largest","")

Again thanks a bunc

Al ( one happy novice Excel user