Hi Guys,
I need to explain my situation better
I'll use the solution that was provided in the earlier replies to this thread.
lrg is a range of cells defined as name:
=LARGE(Lrg,1)+LARGE(Lrg,2)+LARGE(Lrg,3) - this is fine but but i need to replace the range values (lrg) with individual cell references:
=LARGE({B1,C1,D1,X1,Y1,Z1},1)+LARGE({B1,C1,D1,X1,Y1,Z1},2)+LARGE({B1,C1,D1,X1,Y1,Z1},3) - this version does not work as the syntax is incorrect. Is there a way of specifying individual cell references within the LARGE function instead of a Range?
Regards,
Shuja
Bookmarks