Home

How to mass highlight data

%3CLINGO-SUB%20id%3D%22lingo-sub-793668%22%20slang%3D%22en-US%22%3EHow%20to%20mass%20highlight%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793668%22%20slang%3D%22en-US%22%3EHello!%20I%20have%20basic%20ability%20when%20it%20comes%20to%20Excel.%20I%20need%20to%20examine%20data%20that%20was%20transferred%20to%20a%20Pivot%20Table.%20In%20one%20column%2C%20there%20are%20many%20different%20categories%20under%20four%20character%20codes.%20In%20another%20column%20are%20basically%2011%20sub-categories.%20I%20need%20to%20find%20a%20way%20to%20easily%20highlight%20the%20data%20that%20does%20not%20belong%20together.%20As%20an%20example%2C%20in%20the%20first%20column%2C%20there%20could%20be%20items%20like%2003AB%2C%207715%2C%205616%2C%2018AE.%20In%20the%20second%20column%2C%20some%20examples%20would%20be%20Missing%20Activity%2C%20Login%20Issues%2C%20Tech%20Support.%20Some%20of%20the%20items%20in%20the%20second%20column%20should%20ONLY%20be%20matched%20to%20certain%20items%20in%20the%20first%20column%2C%20and%20I%20need%20to%20point%20out%20the%20errors.%20It%20is%20too%20much%20data%20and%20too%20tedious%20to%20go%20through%20it%20line%20by%20line%20as%20I%20did%20last%20month%20(took%20over%2014%20hours....)%20Any%20help%20would%20be%20greatly%20appreciated!%20Thanks!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-793668%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Formulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793796%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20mass%20highlight%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793796%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388742%22%20target%3D%22_blank%22%3E%40Haywood33%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20share%20a%20sample%20file%20so%20that%20I%20can%20review%20this%20further%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3CBR%20%2F%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E
Haywood33
Occasional Visitor
Hello! I have basic ability when it comes to Excel. I need to examine data that was transferred to a Pivot Table. In one column, there are many different categories under four character codes. In another column are basically 11 sub-categories. I need to find a way to easily highlight the data that does not belong together. As an example, in the first column, there could be items like 03AB, 7715, 5616, 18AE. In the second column, some examples would be Missing Activity, Login Issues, Tech Support. Some of the items in the second column should ONLY be matched to certain items in the first column, and I need to point out the errors. It is too much data and too tedious to go through it line by line as I did last month (took over 14 hours....) Any help would be greatly appreciated! Thanks!
1 Reply

Hello @Haywood33,

 

Could you share a sample file so that I can review this further?

 

Thank you!
PReagan

Related Conversations