I have have a formula in Col J below from row 2 onwards
Where Col J from row 2 onwards contains Text, I need code to find the first text that is not blank and to delete this text as well as every 4th after finding the first text
In the example above rows 8 & 11 to be deleted
It would be appreciated if someone could assist me
Code:
=IF(I2="","",A2)
Where Col J from row 2 onwards contains Text, I need code to find the first text that is not blank and to delete this text as well as every 4th after finding the first text
Macro or Formula to Delete Duplicated Ref Numbers whee Branch is the Same. Ver 1.1xlsm.xlsm | |||
---|---|---|---|
J | |||
1 | Division | ||
2 | |||
3 | |||
4 | |||
5 | |||
6 | |||
7 | |||
8 | South End | ||
9 | South End | ||
10 | Mayberry | ||
11 | South End | ||
12 | South End | ||
13 | Port Edward | ||
14 | |||
15 | |||
16 | |||
17 | |||
Duplicates |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J2:J17 | J2 | =IF(I2="","",A2) |
In the example above rows 8 & 11 to be deleted
It would be appreciated if someone could assist me