Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
Is it possible to use ADDRESS comman result as a reference somehow? More specifically - I am trying to count values from a certain offset to my current position to my position. For example: A1 B1 C1 D1 E1 F1 ... AA1 1 1 1 3 Lets say I am in position F1 and I want to count the values from B1 to D1, where B1 is determined by the value in AA1 (AA1 tells me how far backward I should check). If the value in AA1 was 4 I would check from A1 to D1. Hope I am clear enough thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |