Thread: COUNTIF to count long text/values in cells (#VALUE! Error)
View Single Post
 
Old 10-21-2020, 04:56 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
I'm not sure does this help you or not, but attached is an example how to calculate unique identifiers (column CODE) based on 2 columns of your data.

You also can drop 1st pair of comparision in formula for Col3ValNo. Then you get end part of CODE always same for same values in Column3.
Attached Files
File Type: xlsx COST CODE CONVERTER.xlsx (87.0 KB, 8 views)
Reply With Quote