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

  1. E

    Why does Excel reset my dynamic name range?

    For anyone who comes across this post I have found the answer out. It simply requires the most up to date version of the service pack for office. I installed Microsoft Office service pack 3 and this problem was solved. I would like to thank hui for looking into this for me and anyone else who...
  2. E

    Why does Excel reset my dynamic name range?

    thought i would bump this again, could really do with some help on this
  3. E

    How to count how many of the same number there is in multiple cells

    Ok I see the problem now. What you need to understand about COUNTIF is that it uses an exact search function. You cant search in a cell containing 1234--- asking for 1 because its looking for an exact match. 1 is not equal to 12345-- therefore the value is false and it returns a 0. You can...
  4. E

    Highlight Duplicate Values

    You could always use conditional formatting too which will colour a cell based on duplicate values
  5. E

    How to count how many of the same number there is in multiple cells

    That will work but then so should the countif, there must be a problem with your data set. Do your cells contain anything other than a number?
  6. E

    Why does Excel reset my dynamic name range?

    Why thank you sir. Firstly I am opening the document, this version is stripped down and only contains the front page and data. I am going to the bottom left hand chart, right clicking it and going to 'Select Data' Once there I chose the first series which is electricity spend and go to edit...
  7. E

    How to generate SQL commands from excel where the commands are ready to execute

    As far as I know you cannot use SQL language in excel, maybe you could use a text string though to write SQL syntax? For Example: =IF(A1 = "Yes", "SELECT * FROM Table_Name WHERE Criteria >= 100", "") Then the Cell will only display /SELECT * FROM Table_Name WHERE Criteria >= 100/...
  8. E

    How to count how many of the same number there is in multiple cells

    That formula is fine and should work, have you got formulas on to self calculate? Check the bottom left hand corner does it say calculate? if so you need to enable self calculation in your settings. The syntax for count if is as you put it =COUNTIF(Range,Criteria) The only other thing I can...
  9. E

    Why does Excel reset my dynamic name range?

    just re bumping this, could really do with some help here, I've no idea why its doing this
  10. E

    Date format in Excel

    Changing the format wont change a date from 21-08-13 to 7/8/2013 because they are two different dates. However sometimes when data is imported in certain ways formatting appears to be none responsive, however if you select your column then go to data/text to columns then just hit finish that...
  11. E

    Query on COUNTIFS Formula

    Erm, maybe im not reading this right but that is not the syntax of a countifs formula NARAYANK991. A count ifs formula looks like this: =COUNTIFS(Criteria_Range1, Criteria1, Criteria_Range2, Critera2) etc. However getting back to the problem at hand, your formula is very simple if im reading...
  12. E

    Help copying a formula to a whole column... how to paste only to rows w/ data

    You can 'order by' on column A and that will bring all of your values to the top and all of your blanks to the bottom. Then you can un-filter to return everything to its previous state. If you don't know how to do that, insert a new a new column in place of A and give it a sequential numbering...
  13. E

    Borders Missing After Updating to Office2010

    hmm, first I would try inserting a new cell or maybe removing a cell. Then maybe try convert it to an actual Table (Ctrl T anywhere in your table) If its already a table try bring back to a normal range then re convert it again. Otherwise copy the contents of the table out, paste them as values...
  14. E

    Why does Excel reset my dynamic name range?

    I dont think that the first link worked so I signed upto drop box: https://www.dropbox.com/s/p3uxfusode4gaun/test.xlsm
  15. E

    Why does Excel reset my dynamic name range?

    Ok here it is: -Removed Link The workbook has a few Worksheets but I've cut them out to make it easier. ill explain what to do. On the worksheet called 'Front sheet' there are two charts at the bottom. Edit either one going to 'Select Data' You will notice there are 2 or 3 series depending...
Back
Top