1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Recent Activity

Activity stream for all registered members at Chandoo.org Excel Forums - Become Awesome in Excel.

  1. rakesh kumar sharma replied to the thread How to convert to cell address to a range.

    DEAR SIR, I HV A QUERRY HOW CAN I GET CELL ADDRESS OF A VALUE WITH FORMULA IF VALUE IS ANYWHERE IN THE WORKBOOK ...LIKE FINDING TOOL IS...

    Feb 24, 2018 at 1:36 PM
  2. NARAYANK991 replied to the thread Sumproduct.

    Hi , I get a result of 1 when I try the formula in your latest uploaded file. Narayan

    Feb 24, 2018 at 1:36 PM
  3. Marc L replied to the thread How to delete rows based on length of string without loop?.

    As in your explainations you mix opposite ways (!), from your post #6 attachment can you at least just explain clearly & simply the...

    Feb 24, 2018 at 1:31 PM
  4. Marc L replied to the thread How to delete rows based on length of string without loop?.

    As a reminder : the best code is the one you are able to understand but far above all the one you are able to maintain in case of any...

    Feb 24, 2018 at 1:18 PM
  5. Jeepcraz replied to the thread Sumproduct.

    I have tried this but it gave me a result of 2 instead of 1.

    Feb 24, 2018 at 12:49 PM
  6. Chirag R Raval replied to the thread How to delete rows based on length of string without loop?.

    Dear Sir @Marc L , Thank you for your reply, My post no 7's code also added one helper column & I can not hesitate if this method give...

    Feb 24, 2018 at 12:30 PM
  7. cyliyu attached a file to the thread Enable and Disable Password Protection.

    I have the protect and unprotect code as the attached file using Array. It will protect and unprotect "Sheet1", "Sheet3" and "Sheet5"....

    upload_2018-2-24_20-26-13.png upload_2018-2-24_20-27-30.png Feb 24, 2018 at 12:28 PM
  8. Marc L replied to the thread How to delete rows based on length of string without loop?.

    As a reminder to process data, an optimized VBA Excel code is at least 50 times slower than a beginner VBA Access code ! … A recent test...

    Feb 24, 2018 at 11:44 AM
  9. Marc L replied to the thread How to delete rows based on length of string without loop?.

    When there are a huge lot of rows to be deleted (the more non continuous) faster way may not be a filter but an additional column to mark...

    Feb 24, 2018 at 11:38 AM
  10. Marc L replied to the thread How to delete rows based on length of string without loop?.

    Using SpecialCells is very useless as Delete works only with visible cells ‼ And SpecialCells is vicious 'cause limited in size but...

    Feb 24, 2018 at 11:33 AM
  11. NARAYANK991 replied to the thread Sumproduct.

    Hi , Try this array formula , to be entered using CTRL SHIFT ENTER : =SUMPRODUCT(MMULT(--((October!$B$7:$B$69 = $A4) *...

    Feb 24, 2018 at 10:17 AM
  12. vletm attached a file to the thread Drop Down List should show Vehicles for the particular day only..

    Shabbo ... or something like this? No need to make new dropdowns to 'Vehicle's and there will be always the 1st line as 'Vehicle'.

    Feb 24, 2018 at 9:38 AM
  13. Jeepcraz attached a file to the thread Sumproduct.

    The cells highlighted in green are the one which i want to count I4 contains the formula for weekday...

    Feb 24, 2018 at 9:30 AM
  14. Shabbo liked GraH - Guido's post in the thread Drop Down List should show Vehicles for the particular day only..

    Like this perhaps? -> see in name manager to see the actual formulas.

    Feb 24, 2018 at 9:28 AM
  15. GraH - Guido attached a file to the thread Drop Down List should show Vehicles for the particular day only..

    Like this perhaps? -> see in name manager to see the actual formulas.

    Feb 24, 2018 at 9:23 AM
Loading...