please find the attachment
On Sun, Jul 24, 2011 at 9:16 PM, vickey wrote:
> Thank you so much sir, but I have one query, the maximum salary must
> reflect against relative salary, becuase there is further formula for other
> members to increase rest of the members their salary by 20% of maximum.
Hello Vickey,
Use DMAX formula. See the attached.
HTH
Haseeb
>
>
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedI
=IF(B1 wrote:
> Thank you so much sir, but I have one query, the maximum salary must reflect
> against relative salary, becuase there is further formula for other members
> to increase rest of the members their salary by 20% of maximum.
> could you please help me out further please find attched sam
Thank you so much sir, but I have one query, the maximum salary must reflect
against relative salary, becuase there is further formula for other members
to increase rest of the members their salary by 20% of maximum.
could you please help me out further please find attched sample excel.
Thanks
In case you need a sample workbook
On Sun, Jul 24, 2011 at 5:25 PM, vickey wrote:
> How can I get maximum value from a set of goup i.e there are two to three
> families out of this from each family maximum age of family member is
> require in next colum corresponding to maximum age member.
>
> f
check the attachment
On Sun, Jul 24, 2011 at 5:25 PM, vickey wrote:
> How can I get maximum value from a set of goup i.e there are two to three
> families out of this from each family maximum age of family member is
> require in next colum corresponding to maximum age member.
>
> for example
>
>
