chrismdusa
Board Regular
- Joined
- Mar 20, 2003
- Messages
- 60
Lets say I have a sheet with cells A1 & down having dates starting with 1/1/2001 and continuing down with A2 having 1/2/2001, A3 having 1/3/2001 and so on up until today's date.
Then in B1 & down I have any random number between 1 and 60 all the way down until coming to today's date in column A...the catch is that in column B, each number 1 through 60 can appear in multiple cells...completely random in no particular order.
I suppose I would use LOOKUP, but I just can't get it right, but...In C1 I want a formula that will tell me the latest date in column A that a given number appears in column B. Remember, any of the numbers 1 - 60 may appear in multiple column B cells.
Can a formula like this be done? Thanks in advance for the help!
Chris
Then in B1 & down I have any random number between 1 and 60 all the way down until coming to today's date in column A...the catch is that in column B, each number 1 through 60 can appear in multiple cells...completely random in no particular order.
I suppose I would use LOOKUP, but I just can't get it right, but...In C1 I want a formula that will tell me the latest date in column A that a given number appears in column B. Remember, any of the numbers 1 - 60 may appear in multiple column B cells.
Can a formula like this be done? Thanks in advance for the help!
Chris