Filter Question?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
 
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
-------------------------------------------

Alvin R. Williams said:
I have three columns with several numerical entries that requires
Click to expand...
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.
 
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
 
Back
Top