I am trying to count unique values between column H & I but my countifs is not working. I think I am not using the right formula.
I like to count the same combination from Column H & I and list the result in Column J. For example, "OSI" from Column H and "33-CE-1-10" from Column I combination should be counted only once no mater how many times the same combination appears in the data. Is there a way to do this? I don't think Countifs is the right formula to use in this case.
Any help is greatly appreciated
I like to count the same combination from Column H & I and list the result in Column J. For example, "OSI" from Column H and "33-CE-1-10" from Column I combination should be counted only once no mater how many times the same combination appears in the data. Is there a way to do this? I don't think Countifs is the right formula to use in this case.
Any help is greatly appreciated