I run across this frequently, but haven't ever figured out how to count the number of different items (customers, in this instance) in a column/range of data. I want to count how many different customers are in the last column (thru row 254, in green). Is there a (relatively) simple way to accomplish this?
If you want a formula to count cells filled with green color, then you need VBA.
If you tell us what was the basis for those cells to be green, then we can see if the basis can be placed in a counting formula.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
I just did that to highlight the range I wanted to count customers in, otherwise it means zilch...
I'm still not sure why they are green to give you a bulletproof formula. If the criteria is the break in line, then this formula will give you a count within a column until the first blank cell. Confirm with Ctrl Shift Enter:
Formula:
Please Login or Register to view this content.
This will count the number of different, non-blank entries in the range I3:I254:
Formula:Please Login or Register to view this content.
Hope that does what you want.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks