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

  1. C

    Using access to store data for excel dashboard

    Hi Kamarlon, Yes I do and I beleieve that this is an excellent approach to take. An Access database is the best place to store and enrich large sets of data. An Excel spreadsheet is one of the most flexible and efficient tools for presenting data. Combining the two gives you the best of both...
  2. C

    Track the Changes

    Hi, Another option would be to use Excel's built in Track Changes function. http://office.microsoft.com/en-us/excel-help/track-changes-in-a-shared-workbook-HP010197381.aspx (NB Tracking changes makes the workbook shared. This does have some implications for some functionality so may not be...
  3. C

    Track the Changes

    Hi, Another option would be to use Excel's built in Trach Changes function, see link below: http://office.microsoft.com/en-us/excel-help/track-changes-in-a-shared-workbook-HP010197381.aspx (NB Tracking changes makes the workbook shared. This does have someimplications for some functionality...
  4. C

    Track the Changes

    Hi, Another option would be to use Excel's built in Trach Changes function, see link below: http://office.microsoft.com/en-us/excel-help/track-changes-in-a-shared-workbook-HP010197381.aspx (NB Tracking changes makes the workbook shared. This does have someimplications for some functionality...
  5. C

    Track the Changes

    Hi, Another option would be to use Excel's built in Trach Changes function, see link below: http://office.microsoft.com/en-us/excel-help/track-changes-in-a-shared-workbook-HP010197381.aspx (NB Tracking changes makes the workbook shared. This does have someimplications for some functionality...
  6. C

    Track the Changes

    Hi, Another option is to turn on track changes, see link below: http://office.microsoft.com/en-us/excel-help/track-changes-in-a-shared-workbook-HP010197381.aspx (nb sharing a workbook does restrict some functionality so it may not be suitable for all situations). There are also software...
  7. C

    Chandoo are you launching your singing career?

    Chandoo, I didn't know you were such a good singer... http://www.youtube.com/watch?v=B0PoLpxrvr0
  8. C

    Sumif with critera between a range

    You can use SUMPRODUCT() to avoid the helper column: =SUMPRODUCT((A24:A27>=500)*(A24:A27<600),B24:B27)
  9. C

    Sumif with critera between a range

    I would suggest adding in a helper column containing: =if(and(A1>=500,A1<600),"Y","N") Then your SUMIF() would be (assuming helper column is D): =sumif(D24:D27,"Y",A24:A27)
  10. C

    Highlight the Rows with Check Box

    I think any other solution would have to involve VBA (date stamping a helper cell via a cell change event would probably be the best VBA solution)
  11. C

    Highlight the Rows with Check Box

    Hi, One possible solution would be to use Excel's built in track changes function. In Excel 2007 this is on the review tab on the Ribbon. HTH
  12. C

    How far is a number in a range/series

    Another option may be MATCH() =Match(Lookup Value, Lookup array, match type) Eg: =Match(8,range,0)
  13. C

    Text box referencing cell won't update

    Hi, It might be worth seeing if the camera tool gives you what you want. Here is a post by chandoo: http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/
  14. C

    how to count cell that meet conditional formating

    To elabourate slightly, if you use a helper column countaining the ISERROR() formula (which returns TRUE if the cell contains an error) you can then use the COUNTIF() formula to count the cells containing TRUE.
  15. C

    how to count cell that meet conditional formating

    Hi, To count based on a single condition in Excel use the COUNTIF()formula. To count based on multiple conditions use COUNTIFS() (Excel 2007 onwards). NB The formula will not count based on the fact that the cells have conditional formatting applied but based on the values within the cells...
See more
Back
Top