#1
|
|||
|
|||
Count if statement
I need to get the minimum date for the customer id in the attached file a and tag it as the a number on in the file in the file. Can I use a count if statement? |
#2
|
||||
|
||||
In C2 type =INDEX($A$2:$A$7,MATCH(B2,$B$2:$B$7,0),MATCH(MIN($ A$2:$A$7),$A$2:$A$7,0)) and copy down.
|
#3
|
|||
|
|||
Thank you for your response. Not sure what happen to my question below. I need to put the number one in the minimum date for that customer id.
example 4/3/2019 23456 1 6/1/2019 23456 0 9/1/2019 23456 0 4/20/2018 34567 1 10/1/2018 34567 0 5/3/2019 34567 0 |
#4
|
||||
|
||||
C2:
=IF(MINIFS($A$2:$A$7,$B$2:$B$7,B2)=A2,1,0) copied down. |
#5
|
|||
|
|||
Thank you for you help.
|
#6
|
|||
|
|||
Another way (you can hide column CustRow on sheet Data).
In case there may be several entries for same customer at same date, the formula will not work! |
#7
|
|||
|
|||
Thank you for all your help.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
IF statement | mrry475 | Excel | 1 | 09-06-2016 09:30 AM |
Getting the Count formula to count all rows | Jennifer Murphy | Word Tables | 11 | 08-23-2016 09:37 PM |
Count if statement | Alaska1 | Excel | 7 | 05-30-2014 08:57 AM |
if statement | piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |