Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all
I am confusing myself here i know it, i have a spreadsheet showing all the errors that could occur on a particular piece of equipment down one side (a3:a30) I have January to December at the top (b1:m1) I have another worksheet excatly the same format but filled with number data ( the number of times the error occured in that month) How do i generate a top 5 error list based on this data in the new worksheet? Or alternatively i would also be happy with January to December at the top and underneath each month a list of the five errors in text format i.e. January Febraury Gear Gear Motor Motor Harness Spring Spring Sensor Sensor Harness Thanks for any help you can give Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Order/Rank | Excel Worksheet Functions | |||
Rank excluding Errors | Excel Worksheet Functions | |||
How do you rank in order numbers from highest to the lowest? | Excel Worksheet Functions | |||
How do I rank chart data so it appears in a specific order? | Charts and Charting in Excel | |||
Tie breaking in a rank order | Excel Worksheet Functions |