Cross worksheet average sales of unique names

Status
Not open for further replies.

Kalemaroni

New Member
Joined
Sep 15, 2020
Messages
9
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
I have 2 worksheets. Worksheet 1 has the name of the products sold and unique products column as well as Transaction ID. Worksheet 2 has the Sales and a Transaction ID that is the same as Worksheet1's Transaction ID.

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 ((10 + 20) / 2) and Worksheet1!D2 and D3 are 10

Worksheet1

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

Worksheet2

Transaction IDSales
AB
110
220
310
410
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,653
Office Version
  1. 365
Platform
  1. Windows
Duplicate Cross worksheet average sales of unique products

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,279
Messages
5,571,286
Members
412,375
Latest member
BRJoeyMelo
Top