Return numbers high to low using formula (includes negatives)

[63falcondude]

Hi all, I am attempting to build a formula to return a column of numbers highest to lowest.

The formula needs to find which column to look at based on the header.

The problem that I am coming across is that the formula is pulling more 0's than there are in that column (and therefore not showing negative numbers).

Please see attached workbook for representative sample.

[Fluff13]

With your formula the numbers in cols A & C become 0 as they are false.
Try it like

Please Login or Register  to view this content.

[63falcondude]

You nailed it. Thanks Fluff!

[Bo_Ry]

Please try

=AGGREGATE(14,6,(A$2:C$7)/(A$1:C$1=G$2),ROWS(I$2:I2))

or without error value

=LARGE(INDEX(A$2:C$7,,MATCH(G$2,A$1:C$1,)),ROWS(I$2:I2))

[Fluff13]

Glad to help & thanks for the feedback.

[wk9128]

Cell I2 formula , Drag down