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 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
Dear Techies,
Please help me in getting date + 1 considering list of holidays. If date+1 is holiday then it should reflect next working day. Attached excel for reference.
Please provide a formula, no VBA's pls as VBA's will not work due to limitation in my excel.
Dear Techies,
I tried to find similar type of question in earlier posts but didn't find one.
Need to insert Emp code which from Sheet 2 Column B in Sheet 1 Column B matching Column A in both sheets. Problem is there is no exact matching of column A.
Attached XL file for reference.
Regards...
Dear Techies,
Please check attached file. I'm looking to get results with multiple conditions like Resource Names, status, start and end date.
Thanks in Advance
Regards,
Ismail Khan
Dear Techies,
Please help me in calculating Exact Time taken considering Sunday and working hours. Our working hours are 09:30 to 18:00. Check example below:
A1 is 11-22-13 2:12 PM and in B1 11-24-13 5:54 PM, I need difference of these two days and times considering a sunday and my working...
Hi Techies,
Please check file uploaded. In sheet: SOURCE I need vlookup function in B:B (=VLOOKUP(A6,Jenn!A:B,2,FALSE) but error coming as #N/A.
Please help and please explain why this error is coming.
Waiting for your reply.
Regards,
I Khan
Hi All,
Plz help its urgent.
I am looking for a stacked line chart individual for water, power and paper consumption for comparing 2012 and 2013. Please help.
For data please follow below link
http://sdrv.ms/14oCHmS
Regards,
Khan
Hi Techies,
Plz help its urgent.
I am looking for a stacked line chart individual for water, power and paper consumption for comparing 2012 and 2013. Please help.
For data please follow below link
https://skydrive.live.com/redir?resid=10138DF1DFA6A9A!356
Hi Techies,
I am looking for a stacked line chart individual for water, power and paper consumption for comparing 2012 and 2013. Please help.
For data please follow below link
https://skydrive.live.com/redir?resid=10138DF1DFA6A9A!356
Hi Techies,
This is Khan... I need a help in preparing lecture plan. I am having timetable for 6 days working and having four courses. Each course I have to plan lecture plan on different topic for each day. Please help me...
Regards,
Khan