Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2019, 07:57 PM
Alaska1 Alaska1 is offline counting unique id and adding a value Windows 7 64bit counting unique id and adding a value Office 2007
Advanced Beginner
counting unique id and adding a value
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default counting unique id and adding a value


In the attached spreadsheet I want to count the different status for that the unique customer id has. The card can have more than one status so I want to be able to assign a number to the different status (in spreadsheet) What formula is best to use?
Attached Files
File Type: xlsx Book1.xlsx (7.5 KB, 8 views)
Reply With Quote
  #2  
Old 10-01-2019, 10:01 AM
Alansidman's Avatar
Alansidman Alansidman is offline counting unique id and adding a value Windows 10 counting unique id and adding a value Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

How about a Pivot Table . Attached is an example
Attached Files
File Type: xlsx Book1.xlsx (12.4 KB, 8 views)
Reply With Quote
  #3  
Old 10-01-2019, 01:46 PM
p45cal's Avatar
p45cal p45cal is online now counting unique id and adding a value Windows 10 counting unique id and adding a value Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Perhaps Advanced filter to get unique IDs in column F and formula in G2 copied down?
If there are more than 2 instances of a CustomerID and more than 2 different statuses, the lower result takes precedence.

See attached.
Attached Files
File Type: xlsx msofficeforums43518Book1.xlsx (10.0 KB, 7 views)
Reply With Quote
  #4  
Old 10-01-2019, 03:03 PM
Alaska1 Alaska1 is offline counting unique id and adding a value Windows 7 64bit counting unique id and adding a value Office 2007
Advanced Beginner
counting unique id and adding a value
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you!
Reply With Quote
  #5  
Old 10-01-2019, 03:11 PM
Alaska1 Alaska1 is offline counting unique id and adding a value Windows 7 64bit counting unique id and adding a value Office 2007
Advanced Beginner
counting unique id and adding a value
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you the formula will work. Appreciate your help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Collate information using unique ID CarlosTJ Excel 2 02-11-2019 10:28 AM
Indexed/Unique IDs ID015 Word VBA 0 10-11-2016 03:15 AM
counting unique id and adding a value Counting only the unique names in 3 columns on separate worksheets. Ryga38 Excel 1 04-15-2016 07:21 AM
Counting dayjef Excel 4 02-23-2016 03:00 PM
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook JaxV Excel 9 11-14-2014 12:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 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