RTorres899
New Member
- Joined
- Jan 14, 2011
- Messages
- 4
Need some assistance. I have a large spreadsheet with numerous names, dates and values for the period of 2013-2017. I need to find the count of unique dates in three different columns for each employees. I have been using the remove duplicate tab but that takes so long. I also used the formula to identify the unique (=SUM(IF(FREQUENCY(#REF !,#REF !),1))) but that if i go through one employee at a time. That takes so long when I have over 200 names.
Is there a way that I can do this such as pivot table. I am using excel 2010.
Is there a way that I can do this such as pivot table. I am using excel 2010.
