List Automation help!

[PaulyH]

Hello

Can someone please help me with automating my lists. I have one set of data from a survey. See below:

Then I have sheet 2 in the same work book that I wish to autopoulate based on the data on sheet 1.

Please see second sheet below:

Now I would like sheet 2 to display the following when autopoluated:

This essentially means I need 2 formulas:

The first formula for Column 'A' on sheet 2 to return a single value based on the data in sheet 1 Coliumn 'F' but to only return 1 value despite the number of times it occurs (i.e no duplicates).

The Second formula in Sheet 2 column 'S' to multiply the Lamp descriptions Sheet 1 column 'F' with the equivalent total in Sheet 1 column 'R'.

I hope someone can help.

Regards

Paul

 

[PaulyH]

I have tried variations on a countif formula but I cannot get the corresponding 'total' field to add up on sheet 2.

 

[PaulyH]

Can no-one help with this?

 

[Dryver14]

in sheet2

in cell A11 =Sheet1!F11 and drag formula down then in sheet2 S11
=Sheet1!R11 and drag down again.

is this what you are looking for?

 

[PaulyH]

Thanks, but no not really. That would just duplicate the data. I'm trying to produce a new set of data based on the original set of data.