need formula for duplicate data

[yallamanda.b]

Hi Team,

Could you please find the attachment and sea the output column if the add id is having different status of combinations but i need some what i mentioned .




Thanks

 

[Luke M]

For a starting point, try this formula:

=IF(COUNTIF($A$1:$A$1000,A2)>COUNTIFS($A$1:$A$1000,A2,$F$1:$F$1000,F2),F2,"")

 

[yallamanda.b]

For a starting point, try this formula:

=IF(COUNTIF($A$1:$A$1000,A2)>COUNTIFS($A$1:$A$1000,A2,$F$1:$F$1000,F2),F2,"")

i need only if cancelled and delivered is there for same addid i only delivered.


if delivered and cancelled is there it will come delivered only in output column,


and cancelled ,pending is there i need only pending in output column.


Thanks

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks