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
From:abhishek@gmail.comSent:January 30, 2016 11:07 PMTo:excel-macros@googlegroups.comReply-to:excel-macros@googlegroups.comSubject:Re: $$Excel-Macros$$ Counting unique values across multiple non-adjoining columns Do you already have the list

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

$$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