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

Search results

  1. E

    Request to Chandoo (Key Master)

    That was just some words of encouragement to include Access in the website ..didn't know I should start a new topic for that. Sorry for breaking the rules.
  2. E

    Request to Chandoo (Key Master)

    U guys R awesome :)
  3. E

    Hide rows using a command button

    Hi RobSA, I dont know much about macros but maybe this code will help. First insert a command button(activeX control) and then right click and choose "view code". you will see a Subroutine has already been added.Write the code below between "Sub" and "End Sub" ...
  4. E

    Hide data from Formula bar

    Hi Maheshkasera First you need to select the cells that you want to hide their value or formula in the formula bar, then press Ctrl+1 (or right click and select "format cells..." . On the "Protection" tab check the "Hidden" box. After that protect your sheet (Review-> Changes-&#62...
  5. E

    Chart Help

    Use clustered bar graph
  6. E

    How to Filter out the data according to the first cell

    First you can use concatenate to join the city name and codes in for example column F to I, and have it like this: F G H I Mumbai25 Mumbai98 Mumbai154 Mumbai32 Calcutta85 Calcutta94 Calcutta42 Calcutta69 and so on... Then name the...
  7. E

    Want to know the position of nth occurence of a number in a text or string

    I dont know much excel,but i konw SEARCH formula returns the number of the character at which a specific character or text string is first found. You may find the second occurance by changing the start_num in the SEARCH formula( for example using another search formula and adding 1 to it to skip...
  8. E

    Not able to run the macro in other location

    Hi, I dont know much about macros but I think the error has occured because you have referred to the file path somewhere in your code
  9. E

    Counting number of thursdays and fridays between two dates

    I have a formula for counting number of thursdays and fridays between two dates,but i can't understand how this formula works! The formula is: =SUM(INT((WEEKDAY(start date-{5,6})-start date+finish date)/7)) Can someone please explain it to me? THANKS
Back
Top