We have 3 columns Column A Column B Column C

12 Apple Good

23 Apple Bad

45 Apple worstwe had made a shhet which is consolidated. We have applied validation in every column so that we can selet different fruits.

Now in consolidated sheet we whould get

No of apples No of good apples No of apples No . of good apples

Apples

Mangoes

Are you just telling us what you have or are you asking us a question?

I am having this and I am asking a slotion for this

Hi, Is this a course project.

Regards

You said that you want this: No of apples No of good apples No of apples No . of good apples Apples Mangoes"You appear to be asking for 2 sets of the same pairs of data:

No of apples

No of good apples

No of apples

No . of good applesIs that really what you want?

Can I assume that this is actually what you want:

A B C D 1 Fruit Good Bad Worst 2 Apples 12 23 45 3 Mangos x y zPlease confirm.

In addition, please tell us what version of Excel you are using.

We are using Excel 2003

And i also want to know how to use COUNT on a column with Text in it rather than numbers.. We have tried COUNTA also but it was also not working

Ask Your Question

Weekly Poll

Do you think ride and car sharing are the future of transportation?

Discuss in The Lounge

Poll History