Hello,
I am trying to figure out the formula to highlight building numbers (column B) that are duplicates only if they can be found in more than one region (column A).
The asterisk indicates the cells that should be highlighted:
Region Building Number
Fire TX2291*
Fire FX45
Fire FX45
Fire fg*
Truck fg*
Truck TX2291*
Truck TX2291*
Basketball hi
Basketball hi
Kite fg*
Kite TX2291*
Kite ih
Kite ih
Thank you very much.
Dustin
You can fairly easy use PowerPivot (a free Microsoft add on) and UniqueCount in a pivot table to do this. You would essentially create a pivot off the table of data then bring in building number as the rows and unique count on region. If unique count for region is >1 then you have found your issues.
You could also build a pivot table and make it tabular then do a count on the times building number comes up...
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thank you, Mike.
I will give it a shot.
Dustin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks