Alternative to Concatenate
Hi, I have a spreadsheet giving sales figures such as Year to Date revenue,
total number of sales, targets, pipelines etc. To provide me with the data I
want I seem to be concatenating alot of the data i.e. name, week number or
concatenate: name, week number, type of sale and so on and so on and I end
up with a huge sheet full of concatenated data from maybe 4 columns of
original data. I then write the formula in the front sheet to gather the data
from the concatenated columns to give the figures
Is there any way I can avoid this duplication of data? Can i not just ask
excel to look in these 3 cells and return the result instead of having to
concatenate another column?
|