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

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    The opposite to my previous example (which turns the cell into text) is to turn the cell into a value: Value(A1) I have this problem often where I work, numbers recorded as text in excel. One of these always work for me, hope it does for you!
  2. M

    when I paste data a vlookup does not 'see' the numbers and returns #N/A

    In your vlookup, try replacing D2 with D2&""
  3. M

    GRAPH

    I used this only yesterday: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
  4. M

    Array for counting total number of items in list, less duplicates, by month

    I might add in further columns here... Column C as the following: =A2&B2 Column D as: =if(isna(Vlookup(C2,C$1:C1,1,false)),1,0) you should be able to copy this down, and the lookup range should always be all rows above. Column D will then be a count excluding duplicates. Can you get your...
  5. M

    Help Needed in Splitting the Address data in one cell to multiple cells

    Hi, I am on my phone so cannot check the data properly, but I would try SirJB7's solution first. If that doesn't work you can use left and mid formulas so long as the data is consistent. For example, you have columns E, F, G and H, you use these formulas: E2: left(D2,20) F2: mid(D2,21,16)...
  6. M

    Pivot chart - Auto change Data source

    Hi there. I would use the offset formula for named ranges. It's a one off task and you should then be able to click Refresh All to update the pivot tables. Let's say sheet 1 is named "Data". It has columns A-D, and 10 rows of data. Create a named range called "Data", and add the following...
Back
Top