I have excel sheet where I want to group by Location at bottom of page
ProductID, Product, Location, price
1 Product1, NY , 10
2 Product2, NY , 20
3 Product3, NJ , 10
3 Product3, NJ , 20
3 Product3, NJ , 30
Out put should be
ProductID, Product, Location, price
1 Product1, NY , 10
2 Product2, NY , 20
3 Product3, NJ , 10
4 Product3, NJ , 20
5 Product3, NJ , 30
Average NY 15
Average NJ 20
Grand Average 18
pls try
Open in new window
Regards