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

2016-01-31 Thread Theresa Welton
at 9:45 AM, Theresa Welton mailto:theresawel...@gmail.com> > wrote: 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 particip

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

2016-01-30 Thread Theresa Welton
=COUNTIF(AF1:CJ5,"Employee1") would return the count of Employee1written in those columns and rows regardless of blank coulmns between them.HTHOn Saturday, January 30, 2016, Theresa Welton <theresawel...@gmail.com> wrote:Good morning all,I am trying to figure out a way to count uniq

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