Date and Data???

coccio · Apr 25th, 2002, 08:24 AM

I’m having a problem

From A1 to IV1 dates are entered each day
From A2 to IV2 numeric values are entered each day

Each day a new date and a new numeric value is entered in those cells

What I want to do is as a new more current date and data is entered I want a formula to recognize that and plug in the new data in a fixed cell such as A10.

IML · Apr 25th, 2002, 08:36 AM

you could use

=INDEX(1:2,2,MATCH(MAX(1:1),1:1,0))

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

Apr 25th, 2002, 08:24 AM	#1
coccio Board Regular Join Date: Mar 2002 Posts: 137	I’m having a problem From A1 to IV1 dates are entered each day From A2 to IV2 numeric values are entered each day Each day a new date and a new numeric value is entered in those cells What I want to do is as a new more current date and data is entered I want a formula to recognize that and plug in the new data in a fixed cell such as A10.

Apr 25th, 2002, 08:36 AM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	you could use =INDEX(1:2,2,MATCH(MAX(1:1),1:1,0))