Search two columns for an item count
Posted by Wynn on October 16, 2001 7:51 AM
I need to obtain a count from data that is in 2 seperate columns.
I am trying to count how many of 3 different procedures, each of 4 different doctors did.
The procedure name is in one column and needs to be a partial string search as the names of a particular group of the same procedure differs, so I need to extract just the specific word out of the string. The other column of data has the doctors name as the string. I am trying to get data to export to a report or printable spreadsheet that says Doctor 1 procedure 1, (number), procedure 2 - (number), etc.
Any help would be provided. I have looked various ways around this, including arrays, but can't quite figure out how to use them. Thanks.