Thanks for the encouragement :)
Best Regards,
DILIPandey
On 7/24/10, Rahul Gandhi. wrote:
> Great Job Done Dilip...
>
> Regards,
>
> Rahul Gandhi
>
> On Jul 23, 6:42 pm, Dilip Pandey wrote:
>> You are always welcome..!!
>>
>> And formula logic is explained below:-
>> =OFFSET($D$1,SMALL(IF($B$2:
Great Job Done Dilip...
Regards,
Rahul Gandhi
On Jul 23, 6:42 pm, Dilip Pandey wrote:
> You are always welcome..!!
>
> And formula logic is explained below:-
> =OFFSET($D$1,SMALL(IF($B$2:$B$51=$G$7,ROW($B$2:$B$51),""),ROW(1:1))-1,0)
>
> So, I am offsetting the heading D1 in the array which cont
You are always welcome..!!
And formula logic is explained below:-
=OFFSET($D$1,SMALL(IF($B$2:$B$51=$G$7,ROW($B$2:$B$51),""),ROW(1:1))-1,0)
So, I am offsetting the heading D1 in the array which contains the data rows
related with Emp ID "10779" and here I am considering the min(smallest) row
so th
