I am trying to apply if() condition to the data but its not working.
Wants the TOP 5 products daywise. I have the count but instead of count i want product name to be entered below the mentioned date.
i am using following formula
=IF(B5>B6,IF(B5>B7,IF(B5>B8,IF(B5>B9,"Air Cancellation",IF(B6<B5,IF(B6>B7,IF(B6>B8,IF(B6>B9,"Air Flight Enquiry",IF(B7<B5,IF(B7<B6,IF(B7>B8,IF(B7>B9,"Air Booking Status",IF(B8<B5,IF(B8<B6,IF(B8<B7,IF(B8>B9,"Air Refund","Air E-ticket or Invoice"))))))))))))))))
Please if someone can help me on this.
I have attached the sample file.
Bookmarks