AA_20069
04-03-2010, 10:57 AM
Hi guys,
thanks with ur help from last time, have another query i am guessing you
How can you count if a certain cell has a certain text in it e.g. cell B6 has CAR, WHEEL and B7 has WHEEL, GEAR as values.... and in row B1 it will show CAR = 1 and B2 shows that WHEEL = 3 and B4 shows that Gear = ONE....
obv that from B7 to end has different values with different text
Hope that makes sense...
Thanks
thanks with ur help from last time, have another query i am guessing you
How can you count if a certain cell has a certain text in it e.g. cell B6 has CAR, WHEEL and B7 has WHEEL, GEAR as values.... and in row B1 it will show CAR = 1 and B2 shows that WHEEL = 3 and B4 shows that Gear = ONE....
obv that from B7 to end has different values with different text
Hope that makes sense...
Thanks