#16
|
|||
|
|||
Right quick and dirty
join the letter "a"&a2 (="A"&A2) to make A103663321786245243384, then do the countifs (=COUNTIFS($E$2:E2,E2)) Copy the countifs and pastespecial values |
#17
|
|||
|
|||
Purfleet..that number was a concatenation of a few columns, I eliminated a few columns to make the number smaller and it worked perfect. Once again, thanks for all of your help...
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Grouping Lines by Project number on a separate page | taholmes160 | Excel | 2 | 04-17-2019 03:57 AM |
How to count words in a text, arrange them in separate lines and put the grammar class ? | Marcway | Word | 6 | 12-14-2018 04:25 PM |
Trying to add space between lines of bulleted text and a new header but both lines are moving??? | Martin_d35 | Word | 2 | 02-10-2017 07:13 AM |
Getting the Count formula to count all rows | Jennifer Murphy | Word Tables | 11 | 08-23-2016 09:37 PM |
Pivot table grouping problem 2 tables need different grouping | differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |