| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
end of column refence in several calculations
I have several caculations (countif) that are based on the last-row of a
single column. So if column-A ends at row 120 how can I reference that location automaticlly in my caculations without having to manually update the row refence in all my caculations (example: =COUNTIF($BH$3:$BH$xxx,BP2) where xxx is 120)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
