I'm very new to this group and this is my first posting. I'm using an Excel spreadsheet that has dozens of columns of billing data. In particular, I need to find customers that have billing codes in both Column A and Column B within certain code ranges to pull for review. For example:
Column A has 98 different codes that are all 5 digits long. I need to identify all of the codes that are 11003, 11004, 11005, 11006, 99201, 99202 and 99232 AND I also have Column B that has 46 different codes that are all 5 digits long. I need to identify all of the codes that are 55003, 56009, 99223, 99234, 99345 and 99889. How do I identify those customers?
In addition, can I revise the formula to look in several worksheets at once?
Thank you for your help.
Bookmarks