With the 'Brentwood NH' in E1 and the figures in F1,

=IF(AND(RIGHT(E1,2)="NH",F1=50),F1,"")

To copy a formula down, click the cell and you'll see a little square in the
bottom left corner. Hover the cursor over that and a '+' will appear. Left
click that and hold it down, drag the formula down to the end of the list.

Regards,
Alan.

"MikeR-Oz" wrote in message
...
Thaks Alan, That worked a treat.

Another one . If part of a word in column D has NH as in Brentwood NH can
I
have only those names that have NH at the end of their names pulled out in
a
seperate column? And only those that were at least 50 as per previous?

How do you copy a formulae down when it runsa very long list - manually
will take quite a while.
Cheers
Mike

"Alan" wrote:

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