Hi p45cal
Thank you for doing that, is it possible to have the coding do the following instead?
- colour code position titles that appear under more than 1 category only? (if they appear under the 1 category but under multiple levels this is ok)
Retrieve list of values from array which has duplicates
- Thread starter TTTT
- Start date
Hi p45cal
Thank you for doing that, is it possible to have the coding do the following instead?
- colour code position titles that appear under more than 1 category only? (if they appear under the 1 category but under multiple levels this is ok)
- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 365
Test changing:
to:
to highlight Job Titles which exist on multiple Categories.
Code:
If SourceData(ro, LevelColm) <> SourceData(rw, LevelColm) Thento:
Code:
If(SourceData(ro, CatColm) <> SourceData(rw, CatColm) ThenHi p45cal - thank you I tried to change the coding but gives me a compile syntax error?
Hi p45cal - thank you, I think its doing the same thing the original coding did, any way to show only same position title matches across category only? so if they appear more than once within the same category but in multiple levels that is ok to not colour? let me know if I'm not making much sense
- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 365
I think it is doing what you want it to, highlighting only job titles which co-exist in multiple categories. Which levels they occur in is being ignored.
The way to see if there is a difference is to use the original coding:
and produce the grid. Then copy that grid to a new sheet.
Change the code to:
run it, let it update the original Grid sheet, then compare the two sheets.
The way to see if there is a difference is to use the original coding:
Code:
If SourceData(ro, LevelColm) <> SourceData(rw, LevelColm) ThenChange the code to:
Code:
If SourceData(ro, CatColm) <> SourceData(rw, CatColm) Then