• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter Records and find out average selling price per year

R

rkbisht2019

Member
Hi All,

I need to find out the average selling price of each seller in Year 2020 vs Year 2021? I need to use function not taking help of pivot table.

SellerYear-2020Year-2021
Deepak
Rahul
Amit
Rashmi
Vinay
Prateek
 

Attachments

  • Data-1.xlsx
    10.3 KB · Views: 1
Can you provide solution for these 3 question as well? Need to do it with functions

Who is the best seller across all these years?
Who has sold the maximum qty in all those year and how much % more he sold from 2nd rank person?
which zone has the higher revenue?
 
rkbisht2019
It could be possible, but ...
As this seems to be 1st part of many of Your Excercises ...
Should You do some of Your Excercises Yourself too?
... or how would You learn something new?
 
You must log in or register to reply here.
Back
Top