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