| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.CounIf
Hi all,
How can I use a formula in VB to something like: Application.CountIf(Range(ActiveCell.offset(- 1,0):"A2"),ActiveCell)<0 To see whether th same text is there in the range i row above active cell thru A2 with activecell text.. any help? Thanks Manish |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counif Between Date Ranges | Excel Discussion (Misc queries) | |||
| counif greater or less than | Excel Worksheet Functions | |||
| Counif with different cells, not a range | Excel Discussion (Misc queries) | |||
| Counif | Excel Discussion (Misc queries) | |||
| counif but not all the cells | Excel Worksheet Functions | |||
Threaded Mode
