$$Excel-Macros$$ Re: Show the start and end of groups of cells

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 > > >

$$Excel-Macros$$ Show the start and end of groups of cells

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 column C, I would like to see this: part# locationStart/End 1 1B-1-A-01