Link to home
Start Free TrialLog in
Avatar of TEJAS NIMBALKAR
TEJAS NIMBALKAR

asked on

Formula by comparing columns

Hi I need following comment "Deletion flag" Column. Let me know the formula.

Material                                Colum 1                Colum 2       Deletion Flag       Comment
ACCACRI1061200       5402870301                                           Active            Since b3 & c3 filled
ACCACRI1061200       5560783462                5560783462     Active      
BCVPVCU040G031       5404237468                                         Delete           Since c4 and c5 is blank
BCVPVCU040G031       5404237469                                         Delete      
BCVPVCU040G034                                                               Delete              Since b6 and c6 is blank
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
Can you attach an example file and also indicate what you expect from the formula
Avatar of TEJAS NIMBALKAR
TEJAS NIMBALKAR

ASKER

I have attached the example file
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TEJAS NIMBALKAR
TEJAS NIMBALKAR

ASKER

thanks it working