[Icke_F]

bomb #21, did you see the new Test Data.xlsx I previously attached, and why it wasn't working with the summarizer macro you gave me? I've tried it a few times, but it keeps giving me a column full of formula values as data (instead of the actual years as the data).

Please let me know either way, as I'm trying to get this sorted out asap. Thanks.

[Garf13LD]

[Icke_F]

Garf13LD, WOW! You hit the jackpot. That works like a charm!!!

Thank you sooo much. I really appreciate your help.

Thanks for your time and effort.

[bomb #21]

Originally Posted by Icke_F

bomb #21, did you see the new Test Data.xlsx I previously attached, and why it wasn't working with the summarizer macro you gave me? I've tried it a few times, but it keeps giving me a column full of formula values as data (instead of the actual years as the data).

Please let me know either way, as I'm trying to get this sorted out asap. Thanks.

Not until now. The answer is the original column B is text format -- not something that could be discerned from screenshots in the first instance.