deepheat101
Board Regular
- Joined
- Jul 26, 2006
- Messages
- 138
Peeps...
I have the following data...
Considering that the list will be added to each day, how do I go about finding date of the last occurrence of any given number in column B. For example the last 0 would return "10-Jan"; the last 1 would return "09-Jan"; the last 2 would "06-Jan". I had been working with VLookUp before quickly realizing that I need a VLookDown...
Cheers
I have the following data...
Code:
A B
100 01-Jan 0
101 02-Jan 0
102 03-Jan 1
103 04-Jan 0
104 05-Jan 0
105 06-Jan 2
106 07-Jan 0
107 08-Jan 0
108 09-Jan 1
109 10-Jan 0
Considering that the list will be added to each day, how do I go about finding date of the last occurrence of any given number in column B. For example the last 0 would return "10-Jan"; the last 1 would return "09-Jan"; the last 2 would "06-Jan". I had been working with VLookUp before quickly realizing that I need a VLookDown...
Cheers