Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 06-13-2020, 07:39 PM
Purfleet Purfleet is offline Trying to count the lines in a grouping Windows 10 Trying to count the lines in a grouping 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
  #17  
Old 06-13-2020, 09:57 PM
wheddingsjr wheddingsjr is offline Trying to count the lines in a grouping Windows 7 64bit Trying to count the lines in a grouping Office 2016
Advanced Beginner
Trying to count the lines in a grouping
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

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...
Reply With Quote
Reply

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
Trying to count the lines in a grouping 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
Trying to count the lines in a grouping Getting the Count formula to count all rows Jennifer Murphy Word Tables 11 08-23-2016 09:37 PM
Trying to count the lines in a grouping Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft