I need help with this...please!
Easiest way to explain this is...I have 40,000 lines of data that I need to look at. To make the data more readable for review, I want to seperate unique accounts with shading (i.e. records for account 1 are not shaded, records for account 2 are shaded, records for account 3 are not shaded,............etc).
Please see attached excel file. Sheet 1 is raw data. Sheet 2 is the desired result.
I am thinking I can create a macro or use some type of conditional formatting to create the desired result.
Thanks in advance for any comments.
Bookmarks