With the data in say column F, in G1,

=IF(F1=50,F1,"") and drag to the end.

Sort the whole range by column G,

Regards,
Alan.
"MikeR-Oz" wrote in message
...
HI

I have several columns - the last is a series of values that goes on and
on.
I want to create a column next to it that will identify only thhose values
that are say higherthan 50 that appear to the left. Then I would like to
have
the report condences to just show only these entries and not the thousnads
of
entries with values below 50.

Can you assist with the formulae?

Cheers
Mike