I have two columns of data, column A has names that could be duplicated in the list, column B has Yes or No. I need to count the number of Yes responces, but only for the unique values in column A. Sample data is attached. Thanks for any help.
I have two columns of data, column A has names that could be duplicated in the list, column B has Yes or No. I need to count the number of Yes responces, but only for the unique values in column A. Sample data is attached. Thanks for any help.
Last edited by mashley; 12-08-2010 at 02:00 PM.
XL2007+
Prior to XL2007 (or alternative to above):Please Login or Register to view this content.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Excellent. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks