Hi Shimmy,
As per my understanding, a pre-defined formulation can take care of your
worries, but for that you should provide us the test file. Please reply to
this email with the attachment and our "Group" will take care of that.
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile:
hi,
here u can use counta() in ur formulae with indirect function.
for example, if u have 10 entries in colomn B in Sheet1. Then for the range
1:10 w can have formulae
Indirect("sheet1'$B$1:$B$"&Counta(sheet1'$B$1:$B$500)) """
U can use in this manner. Sorry, if the solution is not
Please provide a sample file with example...
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Sep 16, 2009 at 3:27 PM, Shimmy wrote:
>
> Hi, I have data in sheet1 showing Name, gender, Place of residence and
> period of employment as respective columns. The problem is
