need help regarding identifying certain cells

jasdes · Apr 1st, 2002, 11:30 PM

hello, what formula would i need to use in order to select a certain cell. For eg, if i had to find what day i spent the most money in, how would i identify the day in which it occurred? if the days were labelled in 1 col and the amount spent each day in the next col, what would i need to do in order to identify that certain day?

thanx jason

Dave Hawley · Apr 1st, 2002, 11:37 PM

Hi Jason

If your amounts are in Column "B" and days in Column "A" use:

=INDEX($A$1:$B$1000,MATCH(MAX($B$1:$B$1000),$B$1:$B$1000,0),1)

jasdes · Apr 1st, 2002, 11:42 PM

thanx for the help. that works perfectly

jason

Dave Hawley · Apr 2nd, 2002, 12:01 AM

Jason, you may also want to check out the LARGE and SMALL function as well as MIN.

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

Apr 1st, 2002, 11:30 PM	#1
jasdes New Member Join Date: Mar 2002 Posts: 5	hello, what formula would i need to use in order to select a certain cell. For eg, if i had to find what day i spent the most money in, how would i identify the day in which it occurred? if the days were labelled in 1 col and the amount spent each day in the next col, what would i need to do in order to identify that certain day? thanx jason

Apr 1st, 2002, 11:37 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Jason If your amounts are in Column "B" and days in Column "A" use: =INDEX($A$1:$B$1000,MATCH(MAX($B$1:$B$1000),$B$1:$B$1000,0),1)

Apr 1st, 2002, 11:42 PM	#3
jasdes New Member Join Date: Mar 2002 Posts: 5	thanx for the help. that works perfectly jason

Apr 2nd, 2002, 12:01 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Jason, you may also want to check out the LARGE and SMALL function as well as MIN.