Hi
PFA, result can be achieved using pivot table & dynamic reference.
Thanks
On Thu, Apr 17, 2014 at 2:25 PM, SG wrote:
> Hi vabz,
>
> Thanks for the reply but this is not solving my purpose.The data is not
> sorted on location & highest marks & i don't want to paste the visible data
> anywhe
Hi vabz,
Thanks for the reply but this is not solving my purpose.The data is not
sorted on location & highest marks & i don't want to paste the visible data
anywhere else. The sorting done only at that location i.e from colun A to D.
On Thursday, April 17, 2014 2:02:46 PM UTC+5:30, Vabz wrote:
PFA
Thx
On Thu, Apr 17, 2014 at 1:28 PM, SG wrote:
>
>
> Hi Experts,
>
> I need a solution to sort the data on basis of location & highest marks.
> For this, i have created a dynamic named range to call it by macro & then
> sort. My problem comes when the range also selects the blank formulas
Hi Experts,
I need a solution to sort the data on basis of location & highest marks.
For this, i have created a dynamic named range to call it by macro & then
sort. My problem comes when the range also selects the blank formulas in
sheet which shouldn't be selected. Only visible data should s