Geoff_canada
Board Regular
- Joined
- May 26, 2008
- Messages
- 56
Hi everyone
Back again for some excel help. I have a requirement to perform a sum of data based on a date range, then counting the number of unique values in a separate columns. The data is a follows
<tbody>
</tbody>
I need to count up the unique values in column A based on column B equalling a date range. For example, if date range is between Dec 1 to 31, 2013 then the expected result would be 3.
Any help is greatly appreciated.
Thanks
Back again for some excel help. I have a requirement to perform a sum of data based on a date range, then counting the number of unique values in a separate columns. The data is a follows
Column A | Column B |
AB1223 | 11/30/2013 |
AB3212 | 12/05/2013 |
AB1212 | 12/05/2013 |
AB1212 | 12/05/2013 |
AB1212 | 12/05/2013 |
AB0393 | 12/16/2013 |
AB0393 | 12/16/2013 |
<tbody>
</tbody>
I need to count up the unique values in column A based on column B equalling a date range. For example, if date range is between Dec 1 to 31, 2013 then the expected result would be 3.
Any help is greatly appreciated.
Thanks