*Hi,
Please find the attachment for the given problem..
regards,
mathan
*
On Tue, Apr 21, 2009 at 9:26 PM, Geo wrote:
>
> I have data like this:
>
> part# location
> 1 1B-1-A-01
> 5 1B-1-A-01
> 6 1B-1-A-01
> 14 1B-1-A-02
> 12 1B-1-A-02
> 15 1B-1-A-03
> 83
Thanks Gents!
On Apr 21, 12:43 pm, Paul Schreiner wrote:
> In cells C2, use:
> =IF(B2<>B1,"start",IF(B2<>B3,"end",""))
>
> then copy the formula down.
>
> hope this helps,
>
> Paul
>
>
> From: Geo
> To: MS EXCEL AND VBA MACROS
> Sent: Tuesday, April 21, 2009 11
In cells C2, use:
=IF(B2<>B1,"start",IF(B2<>B3,"end",""))
then copy the formula down.
hope this helps,
Paul
From: Geo
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, April 21, 2009 11:56:32 AM
Subject: $$Excel-Macros$$ Show the start and end of groups of cells
Solution attached
On Tue, Apr 21, 2009 at 9:26 PM, Geo wrote:
>
> I have data like this:
>
> part# location
> 1 1B-1-A-01
> 5 1B-1-A-01
> 6 1B-1-A-01
> 14 1B-1-A-02
> 12 1B-1-A-02
> 15 1B-1-A-03
> 83 1B-1-A-03
> 16 1B-1-A-03
> 22 1B-1-A-03
>
> In
