Want to show only values higher than'x' from otehr column?

  • Thread starter Thread starter MikeR-Oz
  • Start date Start date
M

MikeR-Oz

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
 
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.
 
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
 
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.
 
Sorry, I meant to mention in the reply. It's best to open a new thread if
you want ask another question. A lot of people wont look at a message if
it's already been answered so you have a better chance of getting an answer
in a new thread as more people will see it.
Regards,
Alan.
 
Bottom right corner even! Brain dead today!


Alan said:
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.
Click to expand...
 
Back
Top