Hi,
I've attached a quick sample, I have two customer ID's, AB1 and AB2, I want to be able to put a formula into column C that will return the latest date for each customer. So AB1 will show 01/04/2013 and AB2 will show 01/05/2013. I know I can use a MAX formula but I don't know how to connect it to the specific customer ID.
Any help is appreciated as always!
Thanks
Dave
Max Date Query.xlsx
=MAX(IF($A$2:$A$11=A2,$B$2:$B$11)) array entered copy paste in C2 then hold control and shift together and then hit enter now release all three keys and drag down
Use This if you don't want duplication
=IF(COUNTIF($A$2:A2,A2)>1,"",MAX(IF($A$2:$A$11=A2,$B$2:$B$11))) Array Entered!
Last edited by hemesh; 02-18-2014 at 08:18 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Great, thanks!
I really need to learn some more array formula!
Thanks for the Feedback !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks