Hello! A quick run-down...I have claim numbers in column A, procedure codes in column B and units in column C. I've pulled out the unique procedure codes and put them in column E and now need to know the count of unique claim numbers in column A where column B equals the (variable) procedure codes in G. I have to be missing something, b/c I can't imagine this is as difficult as I'm making it.


untitled.JPG

Any help is GREATLY appreciated!