Microsoft Office Forums counting unique id and adding a value

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: 83
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, 4 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
Advanced Beginner
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 36
Alansidman is on a distinguished road
Default

How about a Pivot Table . Attached is an example
Attached Files
File Type: xlsx Book1.xlsx (12.4 KB, 3 views)
Reply With Quote
  #3  
Old 10-01-2019, 01:46 PM
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: 291
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
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, 2 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: 83
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: 83
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


All times are GMT -7. The time now is 09:23 AM.


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