| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro analyses cells in 2 columns . If same text found , keeps
Yep , thanks .
"Mike H" wrote: Hi, It's in this line If InStr(1, c.Value, c.Offset(, 2).Value, vbTextCompare) < 1 Then Column D is offset 2 columns from B so for Q change the offset to 15 If InStr(1, c.Value, c.Offset(, 15).Value, vbTextCompare) < 1 Then Mike "andrei" wrote: one more thing : If i need to compare B column with Q column instead of D column , what changes in the macro should be done ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to do LSD test in data analyses | Excel Discussion (Misc queries) | |||
| Macro analyses Cell . If text found , delets entire row | Excel Programming | |||
| Macro that analyses data from 3 columns and puts result in 4th | Excel Programming | |||
| Macro - reads cells in a column .If keyword found moves cell conte | Excel Programming | |||
| Compute multiple data analyses at once | Excel Discussion (Misc queries) | |||
Threaded Mode
