ASAP bout pivot table

R

reza

Hi all...

simple question about pivot table
i have 2 column
names fruit
reza apple
reza orange
reza apple

what i want to do, create pivot table with results
reza
apple 1
orange 1

but when i created that, the result is:
reza
apple 2
orange 1

thanks....
 
E

Eduardo

Hi,
The information you get in the pivot table is correct in your original list
you have apple twice, before and after orange
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return last non-blank cell in column 3
using pivot table 3
how to count the number of times text occurs based on condition 3
Lookup 5
formula to count text entries and return text with most entries 12
How to choose maximum value 7
IF formulas 5
Suppressing a cell content, which is the same as the above cell 2

Top