I have been able to muddle my way this far, but am not sure how to fix my formulas at this point
In the attached file, I have 3 sets of columns. The 1st is my data, the 2nd is the consolidation of that data, and the last is ranking the consolidated data from highest to lowest. This last part is where I am not able to make it work.
Thank you for any help you can give.
Last edited by Befuddled; 07-31-2011 at 01:05 AM.
You can add a Pivot table (no need for second and third tables).
Never use Merged Cells in Excel
If you prefere your way I've removed your array formulas and make your ranks with one helper column (you can hide it if you want).
Edit: If you prefere blanks you can add IF statement in each column.
For example in J5
=IF(I5="", "", SUMIF($D$5:$D$124, $I5, E$5:E$124))
(and similliar for others)
Last edited by zbor; 07-30-2011 at 04:36 AM.
If you want also include Hrs like:
1st Largest Ers
2nd Largest Hrs
You can use this for example (L column):
=J5+K5/100+COUNTIF($J$5:J5, J5)/10000
Thanks, I had the pivot table version done, but didnt realize I could sort by ERs. I'm going to use the 2nd one, now that you showed me how. Thanks for the help.
I have run into an issue.
Whenever the formula runs into a #N/A in my list, it stops compiling the numbers below that point.
I get the #N/A error if there arent at least 10 problem dies(My data point) in the particular month.
I figured it out, I used an "iserror" formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks