Thank you in advance... please help:
List or highlight a cell if it's value repeats in ALL clusters of data and do this for ALL cells at once.
Trust me, this is not the usual "Conditional Formatting"... I've tried that to no avail..
For example (see attached file, which I hope does get attached):
I have 6 (six) clusters of data, each one with 70 rows and 11 columns that can have numbers (in this case) or may be blank. It is possible that at a given time, one of the clusters of data may not have any numbers at all.
I need to find which numbers repeat in ALL CLUSTERS OF DATA (or call them "different ranges of data").
Cluster 1 range is B2:L71
Cluster 2 range is B72:L141
Cluster 3 range is B142:L211
Cluster 4 range is B212:L281
Cluster 5 range is B282:L351
Cluster 6 range is B352:L421
If 8 repeats in all clusters of data, then highlight it... or put 8 in another cell (column) to show that it repeats in all sections.
If 3 repeats in all clusters of data, then highlight it... or put 3 in another cell to show that it repeats in all sections.
If 17 repeats in all clusters of data, then highlight it... or put 17 in another cell to show that it repeats in all sections.
And so on...
How to highlight ALL cells that repeat in all clusters at once, or how to list all the cells and it's values on a different range of cells.
Can this be done with a formula (or array formula) or VB in a way that is automatic without user input once is in place?
Can you show me in the attached file too?
For the sake of clarity, here is an image to give an idea... but it does not reflect the actual data, it only illustrates the outcome, what I'm looking for, AND I did't manually highlight all the cells that repeat (but I do want all of the though) because I think it is enough to illustrate the idea.
Highlightx.png
Thank you.
Bookmarks