Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
I can't access the VBA code in the attachements -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=552887 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
Hi!
On the Ranking sheet, cell C2, modify this portion of the formula: SUM(IF('Math CST'!E2'Math CST'!E$2:E$36 Change to: SUM(IF(('Math CST'!E2'Math CST'!E$2:E$36)*('Math CST'!E$2:E$36<"") Make sure you re-enter as an array! Copy across F2 Biff "daddioja" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
Copy across F2
Copy across to F2 then down to row 36. Biff "Biff" wrote in message ... Hi! On the Ranking sheet, cell C2, modify this portion of the formula: SUM(IF('Math CST'!E2'Math CST'!E$2:E$36 Change to: SUM(IF(('Math CST'!E2'Math CST'!E$2:E$36)*('Math CST'!E$2:E$36<"") Make sure you re-enter as an array! Copy across F2 Biff "daddioja" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
Biff, I think I already indicated you are the man--you have proved it once again. I appreciate your help beyond words. -- daddioja ------------------------------------------------------------------------ daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024 View this thread: http://www.excelforum.com/showthread...hreadid=552887 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
You're welcome. Thanks for the feedback!
Biff "daddioja" wrote in message ... Biff, I think I already indicated you are the man--you have proved it once again. I appreciate your help beyond words. -- daddioja ------------------------------------------------------------------------ daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024 View this thread: http://www.excelforum.com/showthread...hreadid=552887 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
I am in the home stretch on this, but I have one more thing (I think). If someone--hopefully Biff--could take a look at the sheet called Math RC2. I am having the same type of problem in a different part of the workbook. I want the sheets to order the data based on the ranking sheet. It works except when there are empty fields. Any advice will be greatly appreciated. Thanks for the help. Jason +-------------------------------------------------------------------+ |Filename: RSDSS Janice v1.xls.zip | |Download: http://www.excelforum.com/attachment.php?postid=4904 | +-------------------------------------------------------------------+ -- daddioja ------------------------------------------------------------------------ daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024 View this thread: http://www.excelforum.com/showthread...hreadid=552887 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
In sheet Math RC2, cell A2, change the formula to:
=IF(ROWS($1:1)<=COUNT(Ranking!C$2:C$36),INDEX('Mat h CST'!$A$2:$A$36,MATCH(LARGE(Ranking!C$2:C$36,ROWS( $1:1)),Ranking!C$2:C$36,0)),"") Copy down. That'll correct the errors in the other columns as well. I also see that you need to do the same thing on a few other sheets. Biff "daddioja" wrote in message ... I am in the home stretch on this, but I have one more thing (I think). If someone--hopefully Biff--could take a look at the sheet called Math RC2. I am having the same type of problem in a different part of the workbook. I want the sheets to order the data based on the ranking sheet. It works except when there are empty fields. Any advice will be greatly appreciated. Thanks for the help. Jason +-------------------------------------------------------------------+ |Filename: RSDSS Janice v1.xls.zip | |Download: http://www.excelforum.com/attachment.php?postid=4904 | +-------------------------------------------------------------------+ -- daddioja ------------------------------------------------------------------------ daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024 View this thread: http://www.excelforum.com/showthread...hreadid=552887 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
Thanks Biff. Perfecto! -- daddioja ------------------------------------------------------------------------ daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024 View this thread: http://www.excelforum.com/showthread...hreadid=552887 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fixing some bugs
You're welcome!
Biff "daddioja" wrote in message ... Thanks Biff. Perfecto! -- daddioja ------------------------------------------------------------------------ daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024 View this thread: http://www.excelforum.com/showthread...hreadid=552887 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel bugs | Excel Discussion (Misc queries) | |||
Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
Fixing a vlookup macro that returns #N/A error | Excel Discussion (Misc queries) | |||
Fixing the date. | New Users to Excel | |||
Help with fixing formula | Excel Worksheet Functions |