LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 51
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Order/Rank Rod Excel Worksheet Functions 14 July 28th 07 11:00 PM
Rank excluding Errors Werner Rohrmoser Excel Worksheet Functions 3 April 2nd 07 03:46 PM
How do you rank in order numbers from highest to the lowest? Anika Excel Worksheet Functions 4 September 13th 06 03:35 AM
How do I rank chart data so it appears in a specific order? kim Charts and Charting in Excel 2 September 21st 05 11:56 PM
Tie breaking in a rank order HondaMike Excel Worksheet Functions 1 December 29th 04 11:30 PM


All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"