Unique values in Pivot tables

Hello;

I have a data from which I have a report as a pivot table.
The data looks something like this:

Col1 Col2 Col3
A 10 12
A 20 12
A 30 12
B 10 14
B 15 14
B 17 14
C 20 15
C 30 15

There are more columns, this is just as a sample.
I'd like to report in the pivot something like the following:
A 12
B 14
C 15

Is there any way to do it?
I cannot sort the original data by unqiue values before. Pivot table gets dynamically updated and I need to keep the data this way.

Many-many thanks!

I have tried. Th relationship is 1:1, but the problem now that since I don't necessarily have numbers in Col 3, and I can have some text, so when I use average I get #DIV/0!

Originally Posted by DonkeyOte

What were you hoping to return in these cases ?
The Data Field of a Pivot can (but for a few formatting exceptions) only display numbers.

It might be worth posting a sample file with some source data and "desired" results.

Sorry, I am not an expert and learnign things. Thanks for telling me that it can only displays numbers.

I attached the sample. In my example eve if I add the count for each person, if I take the average, then I get one person on the 1 floor and 1 person on the second floor, which is not correct for me.

Unfortunately I do.

I am not using them in this specific pivot table, btu I have other ones. Also I'm nto sure what two rows fields you are talkign about.

Originally Posted by romperstomper

As in the attached.

Thank you, but this I can do as well. As in my sample I am trying to make a report which would contain a floor number with a count of persons per floor, using their unique names.

Please, see my sample above.

Originally Posted by romperstomper

That workbook is your sample above, with a pivot added to it. I can't see what exactly you want returned - I assumed it was what you had on the Vlookup sheet, but obviously not.

I didn't have any vlook sheet.

Originally Posted by romperstomper

That workbook is your sample above, with a pivot added to it. I can't see what exactly you want returned - I assumed it was what you had on the Vlookup sheet, but obviously not.

Please see the first sample I have attached.
I also said: "In my example even if I add the count for each person, if I take the average, then I get one person on the 1 floor and 1 person on the second floor, which is not correct for me."

As you see I would like to return a number of people per floor number. I am not sure which sample you were referring to, but I did not have any vlookup in my sample and I also already had a pivot table in it.

Originally Posted by romperstomper

Are you sure? The link above is to a file that has no pivot in it and it does have a vlookup sheet. Either that or my browser and copy of Excel have gone nuts.

err... I'll just reattached my sample. Sorry, I am not sure what happened. Probably my mistake.