NY2DR
11-29-2005, 12:01 PM
Hello everyone,
I have been searching for a formula that can possibly do this and had no luck at all.
I could do an autofilter, but I think its overkill.
To do it in VBA, well maybe, but I dont want any buttons present.(I want it all automatic)
Birthdays (Month) October
October Anne Anne
November Bob Stan
January Tom John
October Stan
December Elise
January Mike
October John
November Albert
March Monica
Here's what I want it to do.
First- In the "Birthdays (Month)" section, there are two columns, one that has the month, and the other with the persons name.
Second- On the other column, If I were to change just the month, I would like the corresponding names to appear right below it.
What would be a more improved version of "=VLOOKUP($C$1,$A$2:$B$10,2,FALSE)" to give me those results?
Thank you in advance.
:bug:
I have been searching for a formula that can possibly do this and had no luck at all.
I could do an autofilter, but I think its overkill.
To do it in VBA, well maybe, but I dont want any buttons present.(I want it all automatic)
Birthdays (Month) October
October Anne Anne
November Bob Stan
January Tom John
October Stan
December Elise
January Mike
October John
November Albert
March Monica
Here's what I want it to do.
First- In the "Birthdays (Month)" section, there are two columns, one that has the month, and the other with the persons name.
Second- On the other column, If I were to change just the month, I would like the corresponding names to appear right below it.
What would be a more improved version of "=VLOOKUP($C$1,$A$2:$B$10,2,FALSE)" to give me those results?
Thank you in advance.
:bug: