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. Nightlytic posted a new thread.

    Kernel32 library function Sleep

    I'm using MS Office 2010, 32 bit, looking at the below: http://analystcave.com/vba-sleep-vs-wait/ Could anyone please explain to me in...

    Forum: VBA Macros

    Dec 11, 2017 at 4:45 PM
  2. Khalid NGO replied to the thread How to Compile Multiple Excel workbooks in single excel file??.

    Hi, You can also check this add in: https://www.rondebruin.nl/win/addins/rdbmerge.htm User friendly for merging multiple files into one,...

    Dec 11, 2017 at 3:59 PM
  3. Khalid NGO replied to the thread conditional formatting-Formatting selected rows.

    Hi to all, One more: =COUNTIF($A$3:$A$19,ROW(A1)) Regards,

    Dec 11, 2017 at 3:43 PM
  4. john8714 replied to the thread Question: What-if, forecasting.

    Thanks, I highly appreciate it!

    Dec 11, 2017 at 3:41 PM
  5. john8714 liked Hui's post in the thread Question: What-if, forecasting.

    Type the hours in the hours column instead of the formulas You only need to do it for 1 cell

    Dec 11, 2017 at 3:41 PM
  6. Hui replied to the thread Question: What-if, forecasting.

    Type the hours in the hours column instead of the formulas You only need to do it for 1 cell

    Dec 11, 2017 at 3:38 PM
  7. john8714 liked NARAYANK991's post in the thread Conditional formatting, color control row.

    Hi , See if this is OK. I do not know how you can change the percentage since that is a calculated figure. Narayan

    Dec 11, 2017 at 3:12 PM
  8. john8714 replied to the thread Conditional formatting, color control row.

    I will take a look at it. I highly appreciate that you took a look at it. I agree with you that it is a calculated number.

    Dec 11, 2017 at 3:12 PM
  9. Chihiro replied to the thread Custom Data Validation for Alpha-Numeric Formatting.

    Oh right, just change OR(MID(A2,9,1)={"W","H"}) portion to... OR(MID(A2,9,1)="W",MID(A2,9,1)="H") Forgot that you can't use array...

    Dec 11, 2017 at 3:04 PM
  10. bines53 liked John Jairo V's post in the thread conditional formatting-Formatting selected rows.

    Hi, to all! Just noting that CF not need error control. You can just use: =MATCH(ROWS($G$3:$G3),$A$3:$A$19,0) Blessings!

    Dec 11, 2017 at 3:03 PM
  11. john8714 replied to the thread Question: What-if, forecasting.

    "You have to change the months or put values in the Total Hours column" Can you please elaborate. What would Excel accept in this case,...

    Dec 11, 2017 at 2:58 PM
  12. rsomist replied to the thread Custom Data Validation for Alpha-Numeric Formatting.

    Is this a function to type into the custom form in data validation?

    Dec 11, 2017 at 2:57 PM
  13. Hui attached a file to the thread Question: What-if, forecasting.

    Yes [ATTACH] You have to change the months or put values in the Total Hours column

    upload_2017-12-11_22-49-14.png Dec 11, 2017 at 2:49 PM
  14. john8714 replied to the thread Question: What-if, forecasting.

    is it possible to solve it through goal seek? Through forcing Excel to make the iterations and assign a value instead of USD 0 for the LED?

    Dec 11, 2017 at 2:45 PM
  15. NARAYANK991 attached a file to the thread Conditional formatting, color control row.

    Hi , See if this is OK. I do not know how you can change the percentage since that is a calculated figure. Narayan

    Dec 11, 2017 at 2:45 PM
Loading...