| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with COUNTIF ...
In a column, I use conditional formatting, the formula is:
=COUNTIF(R2C4:R22C4;R2C4)1. When dragging this formula over some 10.000 rows, I'd like the 'criteria' pa- rameter to update itself for each row number (so that each formula points to its respective cell).. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem with COUNTIF ...
Hi Mac
Try =COUNTIF($D$2:$D$22,D2)1 -- Regards Roger Govier "Mac" wrote in message ... In a column, I use conditional formatting, the formula is: =COUNTIF(R2C4:R22C4;R2C4)1. When dragging this formula over some 10.000 rows, I'd like the 'criteria' pa- rameter to update itself for each row number (so that each formula points to its respective cell).. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif problem | Excel Discussion (Misc queries) | |||
| Countif Problem | Excel Worksheet Functions | |||
| Countif Problem | Excel Discussion (Misc queries) | |||
| countif problem | Excel Worksheet Functions | |||
| CountIF problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
