Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell.value comply with cell.value before and cell.value after
Hi Expert,
In column C which is sorted based on column D, groups of words emerge. Occasionally a deviant word occurs within such a group of uniform words, eg.: row column C 1 Word 2 Word 3 Word 4 ord 5 Word 6 Word 7 From 8 From etc. etc. Is there some way I can make 'ord' like 'Word' and loop through the whole of Column C to fix similar situations. The condition is that ord lies between two similar words, 'Word'. When row 7 starts with a new group of Words, eg From, this From word will be left untouched. Would be happy if you could share some knowledge ppeer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Programming | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |