Home > Forum Home > Analyzing Corporate Financial Data > count > Concatenate and COUNTIF Share

Concatenate and COUNTIF

Excel Help for Concatenate And Countif in Analyzing Corporate Financial Data


Forum TopicLogin

Concatenate And Countif

Rate this:
(3/5 from 1 vote)
ShockedYou should concatenate the two columns with doctor name and operation first in column C.  To split out the number from the doctor name, you might want to use a string function like =RIGHT(cell, LEN(cell)-2).  If the numbers go over 1 character in length you will need to replace the LEN part with a FIND function for the space character after the number.

After that you can used the COUNTIF function on the range of concatenations to return the number of unique doctor/operation pairs.

 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Concatenate and COUNTIF in the