Find a string in a column
Column E has strings identifying items. The number of blank cells between
entries varies. (See below.) I need to insert a new item, say D01-006, or D01-004b. So I need to find the row number immediately above the next ID in order to insert the rows the new item will occupy. In order to insert D01-006 how can I find the row number immediately above D02-001, or the row above D01-005 to insert D01-004b? Francis Hookham --------------------------------------------------------------------------- D01-001 D01-002 D01-003 D01-004 D01-004a D01-005 D02-001 D02-002 D02-003 |
All times are GMT +1. The time now is 11:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com