Help

C

collingrey

Hi again

I am using a 4 x 4 table ( A1:D4), concatenating 8 inputs ( A1 to H1)
so say I concatenate A1 with B1, all the way to H1, anyway the result
in the tables will be similar to llb, lbb, llbb, b etc.

Now my problem is that each of these results must be converted to
usable name eg...llb = Purple, lbb = Pink, llbb = Silver etc.

I need to display these colour results in say A10:A26, if there are
cells in the results table showing llbb then it must display:

12.5% Silver
25.0% Purple
etc

Thanks in advance
Colli
 
B

BrianB

Cannot understand your setup.
a1:d4 is a 16 cell table (what is this used for ?)
a1:h1 overlaps this range.
You do not say how many possible colours.
etc. etc.

It looks like the answer will come from a lookup table to get th
colour name [=VLOOKUP()] and using [=COUNTIF()] to count the number o
occurrences of a colour.


I suggest you try your formula and copy it here saying what problem
you have
 
Top