Hi Bernie,

Very neat :-) I've never used pivot tables before and not as scary as I
thought

I will probably use Shane's formula for this one but will definitely be
using pivot tables again.

Cheers
Diddy
--
Deirdre


"Bernie Deitrick" wrote:

Diddy,

Select your data table, then use Data / Pivot Table.... and click Finish.

Then drag the heading from column A to the Row area, column M to the Column Area, and Result to the
data area.

HTH,
Bernie
MS Excel MVP


"Diddy" wrote in message
...
Hi,

I'm tying myself up in knots trying to get this to work.

I have employee test data in a single sheet.

K is a helper column with a unique number identifying the employee. M is the
Test and p is the result (1-5)

I would like to be able to set up a formula so that data stored in P can be
matched with employee in rows.

eg
Col A Col M Col P
Robert test 1 result 5
Robert test 2 result 4
Robert test 3 result 5

Emp test1 test 2 test 3
Change to Robert 5 4 5

Sorry I know not very clear
--
Deirdre