If anyone can help me on this.
On Fri, Mar 8, 2013 at 12:41 PM, Amit Gandhi wrote:
> Thanks Ashish. Good work.
>
> But this UDF doesn't satisfy Criteria 3 i.e.
> Criteria 3 --> Sorting order will be from B --> J.
>
> (a) if you see in your solution file Row 6 & 7 (Name G & A) has count 4,
>
Thanks Ashish. Good work.
But this UDF doesn't satisfy Criteria 3 i.e.
Criteria 3 --> Sorting order will be from B --> J.
(a) if you see in your solution file Row 6 & 7 (Name G & A) has count 4,
but Row 7 (Name A) should come first then row 6 (Name G), as Row 7 has
first highlight in Column C
hi try this attached file
I have created a simple UDF to count cells in a range which are having fill
color red and once you have count. You can simply sort it
Regards
Ashish
On Thu, Mar 7, 2013 at 3:55 PM, Amit Gandhi wrote:
> Hi Experts
>
> I have an excel data and I want to sort data based
Hi Experts
I have an excel data and I want to sort data based on below criteria using
Macro. pls help me here.
*Column B to J has data which is to be sorted as per Highlighted CELLS *
Criteria 1 --> Highlighted cells should come first.
Criteria 2 --> Row which has more highlighted cells from B t
