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

    'Sumifs' to get Sum of Square Feet in a Table

    Ninjas, I'm trying to use 'SUMIFS' to get the total square feet of the 'x' most recent leases. I've attached a workbook. Can anyone...

    Forum: Ask an Excel Question

    Aug 17, 2017 at 12:31 AM
  2. andrefraga27 liked p45cal's post in the thread Conditional Formation in a Range.

    Select cells B5:P35, ensuring that B5 is the active cell. Then in conditional formatting, use a formula to determine which cells to format...

    Aug 16, 2017 at 11:25 PM
  3. andrefraga27 replied to the thread Conditional Formation in a Range.

    Thank you, that worked fine! Another doubt, I also need to find the 1st, 2nd, 3rd...and 15th more occorring number in the range. Could...

    Aug 16, 2017 at 11:25 PM
  4. p45cal replied to the thread Conditional Formation in a Range.

    Select cells B5:P35, ensuring that B5 is the active cell. Then in conditional formatting, use a formula to determine which cells to format...

    Aug 16, 2017 at 10:26 PM
  5. andrefraga27 posted a new thread.

    Conditional Formation in a Range

    I have numbers in a range from B5 to P35 which I need to color them everytime they match to the ones in B2 to P2. Each number in the range...

    Forum: Ask an Excel Question

    Aug 16, 2017 at 10:17 PM
  6. jb replied to the thread countif changes the range.

    I have used $ in formula madam.

    Aug 16, 2017 at 9:54 PM
  7. AliGW replied to the thread countif changes the range.

    Use $ to anchor the array: $A$2:$G$2

    Aug 16, 2017 at 9:50 PM
  8. jb posted a new thread.

    countif changes the range

    Hi experts, I have attached an excel sheet "testing.xls" . I have data in a table from a2 to g7. Some codes are written in c2 to g7. I have...

    Forum: Ask an Excel Question

    Aug 16, 2017 at 9:33 PM
  9. SirJB7 replied to the thread Additions and Deletions.

    Hi, Cody! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your...

    Aug 16, 2017 at 8:44 PM
  10. Cody posted a new thread.

    Additions and Deletions

    Hi, I'd like to start off by saying that your guides are awesome. I have been able to add great perks to a dashboard thanks to you guys....

    Forum: Ask an Excel Question

    Aug 16, 2017 at 8:17 PM
  11. Marc L liked shahin's post in the thread Can't parse name from a webpage using POST request.

    Finally solved it using winhttprequest by enabling redirect: Sub httpPost() Dim http As New WinHttp.WinHttpRequest, html As New...

    Aug 16, 2017 at 7:42 PM
  12. Marc L replied to the thread How to build a web crawler.

    Hi ! As a starter … Sub Demo1() With CreateObject("WinHttp.WinHttpRequest.5.1") .Open "GET",...

    Aug 16, 2017 at 7:33 PM
  13. Eloise T replied to the thread Age calculation formula.

    So you did...I saw the Spanish at the beginning and my eyes passed right over the English.

    Aug 16, 2017 at 7:31 PM
  14. SirJB7 replied to the thread Listbox Multiselect Drag & Drop in Excel.

    Hi, Krishna Khemraj! Does this help? https://stackoverflow.com/questions/38145421/vba-listbox-drag-drop Regards!

    Aug 16, 2017 at 7:01 PM
  15. SirJB7 replied to the thread Age calculation formula.

    Hi, Eloise T! I think your glasses are needing an urgent upgrade. You read this: and missed this, which was just following: BTW, nice...

    Aug 16, 2017 at 6:49 PM
Loading...