RE: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns

2016-01-31 Thread Theresa Welton
Of Abhishek Jain Sent: Sunday, January 31, 2016 12:57 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns Something like this: ? https://exceljet.net/formula/count-unique-values-in-a-range-with-countif On Sun, Jan 31, 2016

Re: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns

2016-01-30 Thread Abhishek Jain
> *Subject:*Re: $$Excel-Macros$$ Counting unique values across multiple > non-adjoining columns > > Do you already have the list of unique ids or you want to create it? > > As for the counting part, there are more than one ways to achieve this - > based on type of data and ho

Re: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns

2016-01-30 Thread Theresa Welton
Unfortunately, that is not what I am looking for.  I have employees participating in activities, these activities are recorded one in each row of the sheet.  I want to be able to determine how many employees are participating as each employee can participate in more that one activity.  Their emplo

Re: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns

2016-01-30 Thread Abhishek Jain
Do you already have the list of unique ids or you want to create it? As for the counting part, there are more than one ways to achieve this - based on type of data and how it is stored. For better understanding, a sample workbook with what you have and what you want will help. However, anywhere