Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
Cells A3:A100 each contain a formula which will result in either a name or "
". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
Sherri,
I'm a little confused. Can you clarify a little more? When you say you're looking for "that name," are you looking for a specific name out of many or are you looking for the first nonblank "" name in that column? Can you perhaps provide an example? Thanks! "Sherri" wrote: Cells A3:A100 each contain a formula which will result in either a name or " ". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
I am looking for the first nonblank in the column. The name will be
different and in a different row every time. Some columns will have more than one name which I will need to access, but I am pretty sure I could do that after I figure out how to get the first one. Does that help? Sherri "GSnyder" wrote: Sherri, I'm a little confused. Can you clarify a little more? When you say you're looking for "that name," are you looking for a specific name out of many or are you looking for the first nonblank "" name in that column? Can you perhaps provide an example? Thanks! "Sherri" wrote: Cells A3:A100 each contain a formula which will result in either a name or " ". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
Assuming the blank cells contain formula blnaks (""):
=INDEX(A2:A15,MATCH(TRUE,INDEX(A2:A15<"",,1),0)) -- Biff Microsoft Excel MVP "Sherri" wrote in message ... I am looking for the first nonblank in the column. The name will be different and in a different row every time. Some columns will have more than one name which I will need to access, but I am pretty sure I could do that after I figure out how to get the first one. Does that help? Sherri "GSnyder" wrote: Sherri, I'm a little confused. Can you clarify a little more? When you say you're looking for "that name," are you looking for a specific name out of many or are you looking for the first nonblank "" name in that column? Can you perhaps provide an example? Thanks! "Sherri" wrote: Cells A3:A100 each contain a formula which will result in either a name or " ". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
G
I am looking for the non blank answer because it could be any name. Let's say I have 20 people, working in 6 possible locations, in 2 possible positions and with varied availability. I am trying to get a schedule established, so I have a column in another sheet for location1-position1 and depending on availability someone's name will show up in that column. So it goes for location1-position2, etc. Sometimes 2 or 3 people will rotate to fill the position, so that column will have 2 or 3 names. I have the name(s) show up in the column, but I can't transfer them into a schedule on another sheet. "GSnyder" wrote: Sherri, I'm a little confused. Can you clarify a little more? When you say you're looking for "that name," are you looking for a specific name out of many or are you looking for the first nonblank "" name in that column? Can you perhaps provide an example? Thanks! "Sherri" wrote: Cells A3:A100 each contain a formula which will result in either a name or " ". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
T. Valko,
That worked great! I am unfamiliar with the index function, so I have another question. If there are 2 names in the column, can I get both to show up somewhere? Thanks a lot! Sherri "Sherri" wrote: G I am looking for the non blank answer because it could be any name. Let's say I have 20 people, working in 6 possible locations, in 2 possible positions and with varied availability. I am trying to get a schedule established, so I have a column in another sheet for location1-position1 and depending on availability someone's name will show up in that column. So it goes for location1-position2, etc. Sometimes 2 or 3 people will rotate to fill the position, so that column will have 2 or 3 names. I have the name(s) show up in the column, but I can't transfer them into a schedule on another sheet. "GSnyder" wrote: Sherri, I'm a little confused. Can you clarify a little more? When you say you're looking for "that name," are you looking for a specific name out of many or are you looking for the first nonblank "" name in that column? Can you perhaps provide an example? Thanks! "Sherri" wrote: Cells A3:A100 each contain a formula which will result in either a name or " ". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
Are you saying that there will only be 1 or 2 names in the column?
If there are 2 or more names this will return the *last* name: =LOOKUP(2,1/(A2:A15<""),A2:A15) Note that if there is only 1 name in the column that 1 name will be *both* the first name and the last name at the same time! -- Biff Microsoft Excel MVP "Sherri" wrote in message ... T. Valko, That worked great! I am unfamiliar with the index function, so I have another question. If there are 2 names in the column, can I get both to show up somewhere? Thanks a lot! Sherri "Sherri" wrote: G I am looking for the non blank answer because it could be any name. Let's say I have 20 people, working in 6 possible locations, in 2 possible positions and with varied availability. I am trying to get a schedule established, so I have a column in another sheet for location1-position1 and depending on availability someone's name will show up in that column. So it goes for location1-position2, etc. Sometimes 2 or 3 people will rotate to fill the position, so that column will have 2 or 3 names. I have the name(s) show up in the column, but I can't transfer them into a schedule on another sheet. "GSnyder" wrote: Sherri, I'm a little confused. Can you clarify a little more? When you say you're looking for "that name," are you looking for a specific name out of many or are you looking for the first nonblank "" name in that column? Can you perhaps provide an example? Thanks! "Sherri" wrote: Cells A3:A100 each contain a formula which will result in either a name or " ". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find resulting text in column of functions
Biff,
There could be 1-3 names (Mary T.,Tony W., Bill F.) in a column. The lookup which you just gave me returned " " (the first cell in the row?). Could this be because it considers the formula in the cell as not blank? Thanks again, Sherri "T. Valko" wrote: Are you saying that there will only be 1 or 2 names in the column? If there are 2 or more names this will return the *last* name: =LOOKUP(2,1/(A2:A15<""),A2:A15) Note that if there is only 1 name in the column that 1 name will be *both* the first name and the last name at the same time! -- Biff Microsoft Excel MVP "Sherri" wrote in message ... T. Valko, That worked great! I am unfamiliar with the index function, so I have another question. If there are 2 names in the column, can I get both to show up somewhere? Thanks a lot! Sherri "Sherri" wrote: G I am looking for the non blank answer because it could be any name. Let's say I have 20 people, working in 6 possible locations, in 2 possible positions and with varied availability. I am trying to get a schedule established, so I have a column in another sheet for location1-position1 and depending on availability someone's name will show up in that column. So it goes for location1-position2, etc. Sometimes 2 or 3 people will rotate to fill the position, so that column will have 2 or 3 names. I have the name(s) show up in the column, but I can't transfer them into a schedule on another sheet. "GSnyder" wrote: Sherri, I'm a little confused. Can you clarify a little more? When you say you're looking for "that name," are you looking for a specific name out of many or are you looking for the first nonblank "" name in that column? Can you perhaps provide an example? Thanks! "Sherri" wrote: Cells A3:A100 each contain a formula which will result in either a name or " ". How can I retreive that name when I don't know which row it will be in. I have many columns of similar formulas and each name will appear in a different row. I have tried the lookup, but because each cell contains a formula, I believe it considers every cell not blank. I hope this is clear. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table: Resulting Column Widths on Drill Down | Excel Discussion (Misc queries) | |||
How can I fix HYPERLINK(B2,E2) to the resulting text and link? | Excel Discussion (Misc queries) | |||
Zeros in text resulting in #div/0! even when using IF function | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Find the Cell Reference Resulting from MAX function | Excel Worksheet Functions |