Search results

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...

@ bosco_yip Thanks..

Hi Chihiro, Noted. Thanks !!

Dear Chihiro, Wow !!. This works like a charm. Thanks a lot. Regards, Ismail Khan

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...

Dear Xiq, Works like charm. Thanks.. It takes a while for me to understand this formula ;) Regards, Ismail Khan

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 Narayan & p45cal, Both works like charm. You Guyz rocks... Thanks a ton!! Regards, I 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 Narayan Ji, It works like charm.. Thanks for your help Regards, I Khan

Dear Excel Experts, Please help me in setting up a formula to get desired results. Attached sample Excel file and query.

Dear Bhushan & Somendra, Thanks for your help.. You are awesome

Dear Bhushan, Thanks for your reply. I'm very sorry as I asked question wrongly in excel sheet. I need A2 +1 in B2, if A2+1 matches with dates in holidays list then next working day has to come. for example if A2=17-07-2015, B2 has to come 20-07-2015 (as 18 and 19 are in the list).

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...

Hi, Thanks Somendra and iferror. You guyz rocks. Rgds, Ismail Khan

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

Hi, Your file is password protected please check!!

Hi Jamir, As per my understanding you can use simple vlookup to get your desired result. Regards, I Khan

Hi Sparky, I face same problem earlier and taken help from this following link. http://www.get-digital-help.com/2010/09/30/team-generator-in-excel/ Hope this will solve your purpose. Regards, I Khan

Hi Kpvaishnav, Adding to this.. you can use following formula also to remove space in at start of text in a cell. TRIM(CLEAN(SUBSTITUTE(A3,CHAR(160)," "))) Regards, I Khan

Hi WMF, Put your data as Format as table option and then create chart. Formulas and chart automatically updates when you entered new data. Hope I answered your query. Attached a file for your reference. Regards, I Khan