Rank order of errors
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
|