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

2016-01-30 Thread Abhishek Jain
Something like this: ? https://exceljet.net/formula/count-unique-values-in-a-range-with-countif On Sun, Jan 31, 2016 at 9:45 AM, Theresa Welton wrote: > Unfortunately, that is not what I am looking for. I have employees > participating in activities, these activities are recorded one in each r

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

Re: $$Excel-Macros$$ Create Multiple sheet

2016-01-30 Thread SUDHIR VERMA
👏👏👏 great Abhishek ji. On 25 January 2016 at 11:58, Shrinivas Shevde wrote: > Really a great job > Very very thanks > Regards > Shrinivas > > On Mon, Jan 25, 2016 at 11:49 AM, Abhishek Jain > wrote: > >> Please see attached. >> >> HTH >> >> On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde < >

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

2016-01-30 Thread Theresa Welton
Good morning all, I am trying to figure out a way to count unique values across multiple non adjoining columns. I need to be able to count unique employee IDs that are tracked in 8 separate columns in an excel worksheet (AF, AN, AV, BD, BL, BT, CB, CJ). Does anyone have any thoughts or sugges