Hi @binuacs Kindly find the attached sample data, the Input and output data are in the same file with 2 different sheets, you can refer the input sheet for input and can check the output sheet to check the output.
Suppose there are few conditions for the file:
1) if Age = 20 ,Address = NYC, Year = contains 2020 then Comment = 'Fresher' else ' '
2) if Age = 20 ,Address = NYC, Year = contains 2022 then Comment = 'Fresher' else ' '
3) if Age = 21,Adress = Miami, Year = contains 2022 then 'New Comer' else ' '
4) if Age = 21,Adress = Miami, Year = contains 2021 or 2023 then 'New Comer' else ' '
Kindly don't match the formula in one, because I have just sent a sample for you to understand, it should be 1st condition and then 2nd condition. In my case if I am running the 1st condition and then 2nd condition it is giving blanks, kindly share me the approach how we can avoid this ? like if the first condition is met it should lock the data which has already passed the 1st condition, now the formula should run on the remaining data and the final part is if the condition does not meet then the Comment which was already there that should exist, that should not be removed or left blank.
