Identifying multiple occurrences of same entry value with Hlookup

[Pro se]

I am using hlookup to tell me on what date a certain entry value (let
say "a") appears.

I have two rows of info. The top row is blank for entries ("A", "B
etc.) The bottom row has numbers in it, 1-31, corresponding to days o
the month.

I have no problem using Hlookup to determine the date of the firs
entry. However, it is the 2nd, 3rd, 4th occurrence of the same entr
that I can not get to display. If "a" occurs on day 1, how can I us
an Hlookup formula (or another formula) to determine the dates of th
other occurrences of "a" throughout the month? (the formula will b
placed in another cell).

Thanks in advance

 

[dave]

Well,

There are a couple ways to handle this. Without more
info, I'll give a couple of possible solutions.

If you had the second row with the actual date instead of
just the day, you would simply sort the data by row 1
(a,b,c). That way you would see every occurrence
of "a", "b", etc by month(you could copy paste special
transpose for verticle viewing).

If you have a large list and only want to have a formula
to show you a summary of one letter at a time, I would do
it this way:

Lets assume that your row 1 starts in a2(your letter row)
and a3 starts your day numbers.

Add this formula to a4... =COUNTIF($A$2:A2,A2); and copy
all the way to the right. Than add to a1...=A2&A4; and
copy to the right(this will give you a name to hlookup on
which is more descriptive than just the letter - the
second occurrence of "a" will give you "a2", and so forth)

Wherever you'd like to see your results for the given
letter make a vertical list of a1, a2, a3, a4(you can do
this automatically, too) and then do your hlookup on this
list over your range.

I hope this is what you needed.

Dave