LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddioja
 
Posts: n/a
Default Fixing some bugs


Another user helped me with some of the functions in this file, and the
problem is that I have one bug I can't fix. There are four sheets. The
first two sheets contain different types of scores.
The fourth sheet ranks each of the different types of scores on both
first sheets. The third sheet reports out on the bottom five scores in
each category. If one of the scores is missing, the whole thing gets
screwed up.

I have attached the file and removed a some of the scores to
illustrate. If anyone is willing to take a look and recommend a fix, I
would be so appreciative.


+-------------------------------------------------------------------+
|Filename: RSDSS v7.xls.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4900 |
+-------------------------------------------------------------------+

--
daddioja
------------------------------------------------------------------------
daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024
View this thread: http://www.excelforum.com/showthread...hreadid=552887

 
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
excel bugs jiggy Excel Discussion (Misc queries) 1 June 17th 06 03:53 AM
Fixing Comma Separated Values (.csv) dickives Excel Discussion (Misc queries) 1 February 14th 06 03:26 PM
Fixing a vlookup macro that returns #N/A error Grosvenor Excel Discussion (Misc queries) 1 February 8th 06 12:23 PM
Fixing the date. cs2883 New Users to Excel 7 October 7th 05 07:40 PM
Help with fixing formula Pat Excel Worksheet Functions 4 December 21st 04 11:38 AM


All times are GMT +1. The time now is 08:32 AM.

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

About Us

"It's about Microsoft Excel"