Using ADDRESS result

[Guest]

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

 

[John Vinson]

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

Are you talking about an Access database table with fields named A1,
and so on? If so, it's an extremely badly designed table.

Or are you talking about an Excel spreadsheet? If so, please repost
the question in an Excel newsgroup; this one is for a different
program, Microsoft Access.


John W. Vinson[MVP]

 

[Guest]

sorry,
Wrong discussion group

Are you talking about an Access database table with fields named A1,
and so on? If so, it's an extremely badly designed table.

Or are you talking about an Excel spreadsheet? If so, please repost
the question in an Excel newsgroup; this one is for a different
program, Microsoft Access.


John W. Vinson[MVP]