Thread: [Solved] Trying to count the lines in a grouping
View Single Post
 
Old 06-13-2020, 07:39 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
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
Attached Files
File Type: xlsx Sample(quickanddirty)_purfleet.xlsx (343.6 KB, 4 views)
Reply With Quote