LinkBack URL
About LinkBacks
Hi All
Was wondering if I could please get help with this tricky one..
I need to count how unique vehicles have a specific colour, when they have multiple entries.
Manually worked out answers in the attached.
example11.jpg
Hi All
Was wondering if I could please get help with this tricky one..
I need to count how unique vehicles have a specific colour, when they have multiple entries.
Manually worked out answers in the attached.
example11.jpg
Last edited by tbomdiggity; 07-31-2024 at 09:57 PM.
I don't get your expected results. Are these registration numbers correct, or should they all be the same?
AliGW on MS365 Beta Channel (Windows 11) 64 bit
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi AliGW
The registrations are correct. WQB922 has multiple enrolment IDs (column A) in my ledger.
OK - so how do you arrive at 1 for Indigo and 12999, then? Because E5 to E8 contains four different registration codes.
Hi AliGW
Indigo has a count of 1 because its the only REGO (WQB922) where "Indigo" is found. All other REGO's may have "indigo", however they also have different colours which remove them from the count.
See post #2 - there are four: WQB922, WQB923, WQB924 and WQB925, hence my question.
Many apologies, all of lines should be WQB922 - apologies for mucking about.
Attachment 875636
This now makes sense - thanks. I'll have another look in a short while.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks