I have an excel sheet that is about 100,000 rows. I'm trying to pull out any Code that has a PAU Coverage and either a HO3 coverage or HO6 coverage. I coded the coverages as keys to try and help. 1 is for PAU and 2 is for HO3 and HO6.
I tried creating a pivot table for it but could not figure out how, I think that may be to complex to complete with Pivots.
Bookmarks