Would like to identify the first occurrence by date
that a customer purchases product 2 in the attached
table. Would prefer that the target column be populated
with the first purchase date. Thank you for your help!
Would like to identify the first occurrence by date
that a customer purchases product 2 in the attached
table. Would prefer that the target column be populated
with the first purchase date. Thank you for your help!
Last edited by clockspring; 04-09-2014 at 04:15 PM.
Try this, copied down...
=IF(COUNTIFS($A$9:A9,A9,$B$9:B9,2)=1,C9,"")
To make it more flexible, replace the 2 with a cell ref, then enter 2 (or whatever number you want) in that ce//
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try in array formula in D9:
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.![]()
Please Login or Register to view this content.
Drag down
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks