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

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.
"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

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

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

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.
"Alan" wrote in message
...
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

Bottom right corner even! Brain dead today!


"Alan" wrote in message
...
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