need help regarding identifying certain cells

[jasdes]

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]

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]

thanx for the help. that works perfectly

jason

 

[Dave Hawley]

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