| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Same Row Value
Hi All,
I have a column that has the following numbers: 1400BAL630 1400CN2400 1400CN2500 1400CN2600 1400CN2630 1400CN2650 1400COC400 1400COC630 1400COC650 1400COC740 1400COC800 1400COC999 1400G3D400 1400G3D650 1400G3D710 I need to test the first 7 characters of the row below. If they are not the same, I need to insert a row and then start at the next set of 7 characters. The end result that I am trying to achieve is: 1400BAL630 1400CN2400 1400CN2500 1400CN2600 1400CN2630 1400CN2650 1400COC400 1400COC630 1400COC650 1400COC740 1400COC800 1400COC999 1400G3D400 1400G3D650 1400G3D710 Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Row | Excel Discussion (Misc queries) | |||
| Finding last used | Excel Worksheet Functions | |||
| Finding value | Excel Discussion (Misc queries) | |||
| Finding Value | Excel Worksheet Functions | |||
| vba..finding first non-zero value in a row | Excel Programming | |||
![JN[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
