Hi,
I'm creating unique IDs for each row in a data sheet by combining CONCATENATE with COUNTIF.
So far, I have this formula: =CONCATENATE(LEFT(B2,4),LEFT(F2,2),LEFT(E2,3),"-",COUNTIF($E$2:E2,E2))
This works fine EXCEPT, in column E, it only creates a different identifier if the entire cell has identical content.
I would like to count only the first 3 characters of the text in column E.
I have tried nesting the LEFT function within the COUNTIF, but it's not working.
Can anyone help?
Thanks
Sara
Bookmarks