| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using labels in formulas
Hi,
I have a small prob. I have a formula where the cell co-ordinates will have to change based on the value available in another cell. For eg., If formula is =COUNTIF(Sheet1!$W$1:$W$500,B7) I want the number 500 to be picked from another cell which contains the exact number or rows. How can I achieve this? Thanks in advance. - Joseph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I go about finding and removing labels in formulas? | Excel Discussion (Misc queries) | |||
| can you put formulas and labels in the same cell | Excel Discussion (Misc queries) | |||
| labels in formulas | Excel Discussion (Misc queries) | |||
| Won't accept labels in formulas | Excel Discussion (Misc queries) | |||
| labels in formulas | New Users to Excel | |||
Threaded Mode
