F
Force Flow
I'm attaching the exel file I'm having problems with.
I'm trying to write a forumula that will list the top 5 "TotalCharges"
in the "reservations" worksheet, and the corrisponding "CustNo". Yo
can see what I attempted on the "totalcharges" worksheet.
I can return the actual "TotalCharges" values, but not th
corresponding "CustNo" that goes along with it. Is there a way to d
this so it works?
Or, can this not be done with formulas? Should it somehow be done in
pivot table? I'm stumped.
Thanks in advanc
+-------------------------------------------------------------------
|Filename: reservation data.zip
|Download: http://www.excelforum.com/attachment.php?postid=4063
+-------------------------------------------------------------------
I'm trying to write a forumula that will list the top 5 "TotalCharges"
in the "reservations" worksheet, and the corrisponding "CustNo". Yo
can see what I attempted on the "totalcharges" worksheet.
I can return the actual "TotalCharges" values, but not th
corresponding "CustNo" that goes along with it. Is there a way to d
this so it works?
Or, can this not be done with formulas? Should it somehow be done in
pivot table? I'm stumped.
Thanks in advanc
+-------------------------------------------------------------------
|Filename: reservation data.zip
|Download: http://www.excelforum.com/attachment.php?postid=4063
+-------------------------------------------------------------------