Hi
Hi Navik,
Thanks for your reply and suggestions. Can this be achieved with a VBA. Because option 2 works for me but giving name to each cell is very tiresome work to do as Im having 1000+ line items.
Regards,
Ismail Khan
Dear Experts,
I am looking for data validation with searchable drop down. Attached excel having Database sheet with sellers list. In April sheet in Column E looking to have a data validation with searchable drop down. Please help.
Is there any way to have without VBA if not VBA also works for...
Dear Techies,
In a job I need to calculate Airport to Airport distance in Kms. I used to take help of https://www.travelmath.com/flying-distance to find this. As list is huge searching for each entry is taking so much time.
Airport codes are as per IATA
Is there any shortcut to do this...
Dear Sidman,
I was unable to express my requirement in past post.
My requirement is In Raw data sheet there are employee name/ emp. code and dates of a month. In expected result sheet I am looking to get emp. code/ employee name and date. As employee list is almost 500 and it changes each...
Dear Techies,
Please help me in preparing attendance sheet for monthly basis for each employee.
Attached excel contains Raw Data and expected results sheets.
Raw data contains:
1. Employee details (employee list goes on up to 500)
2. Dates
Expected results are:
1. Each employee details with...
Hi Excel Experts,
Pls help me to figure a formula to lookup and match specific text.
Attached Excel sheet for better understanding.
Thanks in advance!!
Regards,
Ismail Khan
Dear Excel Experts,
Please help in getting this resolved. I need to enter most repeating value from B:B considering A:A. Attached example and desired result