Hi Dude
just apply below formula in A2 and jus keep on copy paste the same till the end
of your data.
=IF(B2<>"",ROW(B2)-1,"")
From: Rahul Gandhi
To: MS EXCEL AND VBA MACROS
Sent: Fri, 7 January, 2011 11:36:26 AM
Subject: $
Find the attached file...
Rgds, Maries
On Fri, Jan 7, 2011 at 12:46 PM, siti Vi wrote:
> please check this formula (written in A2)
>
> =IF(A1=COUNTA($B$2:B2),"",COUNTA($B$2:B2))
>
> best regards,
>
>
>
> On Fri, Jan 7, 2011 at 1:06 PM, Rahul Gandhi wrote:
>
>> Can you please let us know what e
please check this formula (written in A2)
=IF(A1=COUNTA($B$2:B2),"",COUNTA($B$2:B2))
best regards,
On Fri, Jan 7, 2011 at 1:06 PM, Rahul Gandhi wrote:
> Can you please let us know what exactly you require in output
>
> On Jan 7, 4:01 am, scoobysnack88 wrote:
> > Does anyone have a formula or
Can you please let us know what exactly you require in output
On Jan 7, 4:01 am, scoobysnack88 wrote:
> Does anyone have a formula or vbs to accomplish the sequential
> numbering as listed here? The rows with no information would get a
> nill and the next cell would not break the number sequence
