| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.CounIf
Manish,
Try something like- Application.CountIf (Range(ActiveCell.Offset(-1, 0), Range("A2"))) < 0 regards, JohnI "Manish" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
