Hi All
i have a small issue can any body solve this below formula.
i need result based on Type-1 & Type-2
| Type-1 | Type-2 | Result |
| Date | NYC | NYC |
| Avl | Date | Date |
| Avl | Avl | Avl |
| Nyc | Avl | NYC |
| Date | Date | Date (date should be Greater |
Hi Saliha,
Welcome to our forum. Can you please provide some more information as I'm not following the pattern in your 'Result' column.
Mynda
Hi Minda
thanks for your reply, please see the attached details.
Regards
Saliha
Hi Saliha,
Thanks for the sample file. Try this formula in cell E12:
=IF(OR(B12="NYC",C12="NYC"), "NYC",IF(OR(ISNUMBER(B12),ISNUMBER(C12)),MAX(B12:C12),"AVL"))
Copy down.
Mynda
Hi Mynda
Great... Its working and thanks for your support.
Regards
Saliha
Hi Mynda
i have work on my data's showing error in some datas
Regards/Saliha
Your MAX formula range is incorrect. It should only include the two columns that contain the dates i.e. CG and CN
It should be MAX(GC1001,CN1001) not MAX(CG1001:CN1001)
Mynda
