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

    Concatenate excluding blanks

    Hi, I have a row of data which I need to concatenate with a ; between each value. Unfortunately I have blanks in my data. Please could you help I have tried to search for an answer to this but cannot find anything data 4 blank cell 8 25 blank cell blank cell 1 2 blank cell...
  2. C

    If Statement with VLookup

    Hi, I have trawled through all the questions on vlookup but cant seem to find an answer similar to what I'm trying to achieve. Here goes I'm looking up a cell which will either hold a value or be blank, if the cell holds a value I want to output a 4 (not the value in the cell) but if it is...
  3. C

    VLookup wild cards [SOLVED]

    Hi, Im trying to lookup the contents of a cell but I know the contents of the cell will not be an exact match, is there anyway I can use a wildcard or has someone got a better way of doing this My formula is =VLOOKUP(C4,SM_CC!B:C,2,FALSE) C4 holds the text Pinewood but the column Im looking...
  4. C

    concatenating data from fields with more than one duplicate entry

    Hi I have some data where there is more than one entry per person & I need to concatenate data from a particular field for each duplicate entry. Candidate QUALWT from lookup 1000026 6 6;10 1000026 10 1000091 13 13;6; 10 1000091 6 1000091 10 1000133 6 6;10...
Back
Top