Ok so the large function works incredibly well for my purpose of getting the top 5 numbers of a given range however, I can't seem to get it to work across multiple worksheets please help .
=LARGE('WS #1'!$C$3:$C$32),1) -- This works for finding info from Worksheet 1 but I'd like to be able to do it from WS #1-4 -- They are all C3:C32 but I don't quite know what to do!!!
Thanks alot for reading this far and trying to help a fellow out!
(and sorry if I can't describe properly what I need help with )
=LARGE('WS #1'!$C$3:$C$32),1) -- This works for finding info from Worksheet 1 but I'd like to be able to do it from WS #1-4 -- They are all C3:C32 but I don't quite know what to do!!!
Thanks alot for reading this far and trying to help a fellow out!
(and sorry if I can't describe properly what I need help with )