tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,212
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I'm looking for a formula solution to the following problem,
My sheet is called "Raw Data"
I need to give me the top 20 orders and show the Title and number
but it needs to be for a client, a country and a date
So Date is in "contriol" D3, Country D5, Client D7
so what i need is formula or formulas to
Give me a top 20 list for that client only
In Need the Order Value from Column L
The Title form Column G
The Number Column J
please help if you can, cant go out a celebrate new year until ive sent this report.
P.S. Please don't suggest a pivot Table, for reasons i can not explain it must be formula based,
Thanks
Tony
I'm looking for a formula solution to the following problem,
My sheet is called "Raw Data"
I need to give me the top 20 orders and show the Title and number
but it needs to be for a client, a country and a date
So Date is in "contriol" D3, Country D5, Client D7
so what i need is formula or formulas to
Give me a top 20 list for that client only
In Need the Order Value from Column L
The Title form Column G
The Number Column J
please help if you can, cant go out a celebrate new year until ive sent this report.
P.S. Please don't suggest a pivot Table, for reasons i can not explain it must be formula based,
Thanks
Tony