lookup

dneas · May 17th, 2002, 10:53 AM

Does Excel have a function that will look either right or left for a value or text in the "first" emply cell?

Steve Hartman · May 17th, 2002, 10:56 AM

Quote:

On 2002-05-17 09:53, dneas wrote:
Does Excel have a function that will look either right or left for a value or text in the "first" emply cell?

No, since by definition an empty cell has no value or text in it.

Steve Hartman · May 17th, 2002, 10:59 AM

[ This Message was edited by: Steve Hartman on 2002-05-17 10:03 ]

Asala42 · May 17th, 2002, 11:40 AM

Hey,

I'm not realy sure what you're asking. You might want to give us some detail on what you've got in front of you and what exactly you're shooting for.

Adam

dneas · May 17th, 2002, 01:28 PM

Explain: A worksheet with 12 months and in filling in the months I would like to have a function that would put the most current month in a formula.
A B C D E F G H I J K L
X J F M A M J J A S O N D Change
5 1 2 3 4 5 +(F1-a1)

Next month I have to change the formula to show G1-A1. Get my drift. I need a function to recgonize the first column that
has data in it. As one fills the year, the formula will always automaticly change.

Chris Davison · May 17th, 2002, 01:47 PM

Quote:

On 2002-05-17 12:28, dneas wrote:
Get my drift.

No, not one bit.

What is "x" ?

What is 5 ?

what is +(F1-a1) ? F1 houses "M" and A1 houses "X" by my understanding of your example.

dneas · May 17th, 2002, 02:02 PM

X is the standard. 5 is just a number. Column A is the standard and the months are in columns B through M. The formula is in column P. The formula substracts the latest month from the standard. Therefore since the last month with data is April (column I), Column I - column A is the difference in the standard and the latest month. Next month you have to change the formula since the most current month will be May (Column J).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 10:53 AM	#1
dneas New Member Join Date: Mar 2002 Posts: 34	Does Excel have a function that will look either right or left for a value or text in the "first" emply cell?

May 17th, 2002, 10:59 AM	#3
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	[ This Message was edited by: Steve Hartman on 2002-05-17 10:03 ]

May 17th, 2002, 11:40 AM	#4
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hey, I'm not realy sure what you're asking. You might want to give us some detail on what you've got in front of you and what exactly you're shooting for. Adam

May 17th, 2002, 01:28 PM	#5
dneas New Member Join Date: Mar 2002 Posts: 34	Explain: A worksheet with 12 months and in filling in the months I would like to have a function that would put the most current month in a formula. A B C D E F G H I J K L X J F M A M J J A S O N D Change 5 1 2 3 4 5 +(F1-a1) Next month I have to change the formula to show G1-A1. Get my drift. I need a function to recgonize the first column that has data in it. As one fills the year, the formula will always automaticly change.

May 17th, 2002, 02:02 PM	#7
dneas New Member Join Date: Mar 2002 Posts: 34	X is the standard. 5 is just a number. Column A is the standard and the months are in columns B through M. The formula is in column P. The formula substracts the latest month from the standard. Therefore since the last month with data is April (column I), Column I - column A is the difference in the standard and the latest month. Next month you have to change the formula since the most current month will be May (Column J).