|
|
#3
10-21-2020, 04:56 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help on Countif Error | vikaskhengre | Excel | 1 | 04-09-2019 04:51 AM |
 count the number of text in a cell based off a different cells text
|
Kubi | Excel | 4 | 08-24-2017 05:53 PM |
| Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
| Header must toggle text & color + show count of conditionally formatted cells below | Franktoon | Excel | 3 | 02-18-2014 02:10 PM |
|
How to count the total cells that contains text data?
|
Learner7 | Excel | 1 | 06-30-2011 04:13 PM |
Windows 8 
Office 2016
Threaded Mode