• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by ismailzkhan

  1. ismailzkhan

    Data Validation with searchable drop down

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

    Data Validation with searchable drop down

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

    Airport to Airport Distance

    @ bosco_yip Thanks..
  4. ismailzkhan

    Airport to Airport Distance

    Hi Chihiro, Noted. Thanks !!
  5. ismailzkhan

    Airport to Airport Distance

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

    Airport to Airport Distance

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

    Attendance Sheet-monthly (reference missing)

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

    Attendance Sheet-monthly (reference missing)

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

    Index and Match Problem

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

    Index and Match Problem

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

    Most repeating values considering Other column

    Dear Narayan & p45cal, Both works like charm. You Guyz rocks... Thanks a ton!! Regards, I Khan
  12. ismailzkhan

    Most repeating values considering Other column

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

    If, And and ISblank Conditions combined

    Dear Narayan Ji, It works like charm.. Thanks for your help Regards, I Khan
  14. ismailzkhan

    If, And and ISblank Conditions combined

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

    Date +1 considering list of holidays provided

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