If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Want to show only values higher than'x' from otehr column?
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 |
#3
|
|||
|
|||
Want to show only values higher than'x' from otehr column?
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 |
#4
|
|||
|
|||
Want to show only values higher than'x' from otehr column?
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 |
#5
|
|||
|
|||
Want to show only values higher than'x' from otehr column?
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 |
#6
|
|||
|
|||
Want to show only values higher than'x' from otehr column?
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 |
Thread Tools | |
Display Modes | |
|
|