Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the numeric contents of a cell to define row number
Can anyone tell me whether I can put a number in a cell and then use that
cell to define a range e.g. A B 1 3 CABG 2 PCI 3 CABG 4 PCI =countif(B1:B(A1), "PCI") The answer should equal 1 Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subject: How to Reverse Contents in an Excel cell (NUMERIC VALUE) | Excel Worksheet Functions | |||
Subject: How to Reverse Contents in an Excel cell (NUMERIC VALUE) | Excel Worksheet Functions | |||
Subject: How to Reverse Contents in an Excel cell (NUMERIC VALUE) | Excel Worksheet Functions | |||
convert a numeric number in text format in another cell? | Excel Worksheet Functions | |||
How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) |