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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

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,328
Messages
5,547,278
Members
410,783
Latest member
sonnny
Top