Comparing data across dozens of worksheets
Closed
Geist
-
Mar 19, 2012 at 09:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 20, 2012 at 02:39 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 20, 2012 at 02:39 AM
Hello,
So we track sales on a weekly basis and I want to compare the text in column C to all previous weeks and if they match to turn them red to distinguish duplicates. I have tried conditional formatting as well as a few other things but no luck. Is this doable with a new worksheet each week or would something else be better?
Thanks.
So we track sales on a weekly basis and I want to compare the text in column C to all previous weeks and if they match to turn them red to distinguish duplicates. I have tried conditional formatting as well as a few other things but no luck. Is this doable with a new worksheet each week or would something else be better?
Thanks.
Related:
- Comparing data across dozens of worksheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Data transmission cable - Guide
- Digital data transmission - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 20, 2012 at 02:39 AM
Mar 20, 2012 at 02:39 AM
complete inforamtion not gven
"text in column C to all previous weeks"
should that text be available in ALL THE previous weekly sheet or it is enough if it is available in one or more sheets?
"text in column C to all previous weeks"
should that text be available in ALL THE previous weekly sheet or it is enough if it is available in one or more sheets?
