| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering the top 5 transactions from a list of 10 reps
I asked this before but still have not received a reply. So maybe I didn't
explain it very well. I have a weekly spreadsheet with, say, 10 people on it. For each of these people I have between 20 and 300 sales transactions. So I have between 200 and 3000 rows of transactions for any given week. I only need to see the top 5 highest value transactions from each rep. Is there a way to filter out all but those 5 transactions for each rep? So in the end I have 50 transactions and I want it to look like this: Steve $240 Steve $210 Steve $140 Steve $95 Steve $20 Mary $234 Mary $230 Mary $224 Mary $134 Mary $34 John $456 John $455 John $446 John $356 John $56 .. .. etc. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering the top 5 transactions from a list of 10 reps
using the data sort function will work.
"Bishop" wrote: I asked this before but still have not received a reply. So maybe I didn't explain it very well. I have a weekly spreadsheet with, say, 10 people on it. For each of these people I have between 20 and 300 sales transactions. So I have between 200 and 3000 rows of transactions for any given week. I only need to see the top 5 highest value transactions from each rep. Is there a way to filter out all but those 5 transactions for each rep? So in the end I have 50 transactions and I want it to look like this: Steve $240 Steve $210 Steve $140 Steve $95 Steve $20 Mary $234 Mary $230 Mary $224 Mary $134 Mary $34 John $456 John $455 John $446 John $356 John $56 . . etc. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering the top 5 transactions from a list of 10 reps
That works if I only have 5 transactions for each rep to begin with (unless
I'm missing something) but I have between 20 and 300 transactions for EACH rep. How do I get rid of all but the top 5 highest transactions for each rep? "daniel" wrote: using the data sort function will work. "Bishop" wrote: I asked this before but still have not received a reply. So maybe I didn't explain it very well. I have a weekly spreadsheet with, say, 10 people on it. For each of these people I have between 20 and 300 sales transactions. So I have between 200 and 3000 rows of transactions for any given week. I only need to see the top 5 highest value transactions from each rep. Is there a way to filter out all but those 5 transactions for each rep? So in the end I have 50 transactions and I want it to look like this: Steve $240 Steve $210 Steve $140 Steve $95 Steve $20 Mary $234 Mary $230 Mary $224 Mary $134 Mary $34 John $456 John $455 John $446 John $356 John $56 . . etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering totals - Reps per Province | Excel Worksheet Functions | |||
| sales reps pricing | Excel Worksheet Functions | |||
| How do you set up the data to perform a Anova 2 Factor/w reps? | Excel Worksheet Functions | |||
| How- seperate a combined list by filtering out first list of names | Excel Worksheet Functions | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Linear Mode
