Compare mismatch between production batch with production date

[subrato]

Hello !!!

I'm trying to find a way out to identify the mismatches of production batch code with production date.
Here is the sample attached-

In the attached file,
the batch number 170141 should come after 170132. but as some mismatch is happened, it has now become like that. Now I need to find a way/ formula to identify this type of mismatch from huge number of data.

Please help me to sort this out.

Thanks a lot
Shuvro

 

[vletm]

subrato
1) Could You sort that huge number of data with 'batch code'?
... then those would be in 'correct' order.
2) If need 'X' to the row, You could use formula like =IF(B10>B11,"X",""),
but if really huge number of data ... then many formulas to copy!

 

[subrato]

subrato
1) Could You sort that huge number of data with 'batch code'?
... then those would be in 'correct' order.
2) If need 'X' to the row, You could use formula like =IF(B10>B11,"X",""),
but if really huge number of data ... then many formulas to copy!

Thank a lot for your reply.
Actually sorting of those batches in order will not serve my purpose. I just want to identify (with color or any other way) those cells of batches or those dates so that later I can put reason for those mismatches.

 

[vletm]

so, use 2)

 

[NARAYANK991]

Hi ,

See the attached file , where conditional formatting has been used.

Narayan