Hi
Column A i have a list of dates
Column B i have a list of names
Range C1 i have a cell to enter a name
Enter a name in C1
and C2 brings back a value that counts unique dates in Column A, where column B equals C1
where column A is between the first day of the current year and todays date
Thanks in advance
=SUM((FREQUENCY(INDEX((b1:b100=C1)*a1:a100,0),a1:a100)>0)+0)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank you, and possible to incorporate the date range?
Cheers
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
have done, cheers
see the attached file
thank you kind sir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks