Cross worksheet average sales of unique products

Kalemaroni

New Member
Joined
Sep 15, 2020
Messages
9
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Worksheet1

ProductTransaction IDUnique Product NameAverage Sales of Unique Product Name
ABCD
Apples1Apples=???
Apples2Carrots=???
Onions3Onions=???
Carrots4

Worksheet2

Transaction IDSales
AB
110
220
310
410

I'm looking for a formula that will display the Average Sales of the Unique Product Names listed in Column C of Worksheet1 into column D of Worksheet1. Expected value of Worksheet1!D1 is 15 and Worksheet1!D2 and D3 are 10
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Kalemaroni

New Member
Joined
Sep 15, 2020
Messages
9
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Just to clarify, there are 2 worksheets. The Transaction ID column in each can be used to link the Sales in Worksheet2 to the products that were sold in column A of worksheet1. Column C contains a formula that generates the cells from the unique cells of column A.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,068
Messages
5,545,798
Members
410,708
Latest member
SanTrapGamer
Top