Thankyou very much.. will be able to accomplish daily tasks (dozens -
hundreds of them) much faster once finish getting set up. the formula's are
part of a hyper-link I thought up with some help, to find values quickly.

Hyperlinks to exact locations in a document (link that move as lines move):
=HYPERLINK(IF(ROW($A$650)<=ROW($A65),
"#"&CELL("address",OFFSET($A$650,-1,1)),"#"&CELL("address",OFFSET($A$650,$V$1,1)))," A")

where $V$1 is a set number of lines to offset, with equation:
=48-CELL("row",$A$17) to automate offset value

where ROW($A65), must be the row formula link is currently in.
NOTE: to make work "IN-DOCUMENT" lines, where link is in SAME TITLE LINE/
After, as destination put 2nd half of formula 1st, and reverse <=ROW to =
(SAVES large amount of time, when working on large sheets).

----- for your help, item:

The only thing that will remain is to include in column where muliple A B C
D's repeat, are to negate them as I pass thru them with a date function.

maybe something like: IF((NOW()+1)(AZ9+AZ$5)),"",formula
no problem.


=HYPERLINK(IF(ISNA(INDEX(ROW($AE$1:$AE$1303),MATCH (TRUE,EXACT($AE$1:$AE$1303,"A"),0))),"",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBS TITUTE(CELL("address",$V14),"$",""),ROW(),"")&INDE X(ROW($AE$1:$AE$1303),MATCH(TRUE,EXACT($AE$1:$AE$1 303,"A"),0))),$V$1,0))),"A")

will find the 1st capital "A" in that column. have to add exclusion you
qouted for ROWS.


-----------------------------

"Biff" wrote:

Just change the range to start at AE6:

For the RELATIVE row location:

=INDEX(ROW(AE6:AE1299)-ROW(AE6)+1),MATCH(TRUE,EXACT(AE6:AE1299,"A"),0))

For the ACTUAL row location:

=INDEX(ROW(AE6:AE1299),MATCH(TRUE,EXACT(AE6:AE1299 ,"A"),0))

Biff

"nastech" wrote in message
...
Hi, thanks.. sorry, many instances of each letter, so the 2nd example
worked;

but wondering if way to exclude top rows, in case have cells with same
letter "A" as settings? trying to insert ROW5...

"Biff" wrote:

OK.....

If there's only one instance of "A":

=SUMPRODUCT(--(EXACT(AE1:AE1299,"A")),ROW(AE1:AE1299))

If there might be more than one instance of "A":

This will find the first instance:

Entered as an array using the key combination of CTRL,SHIFT,ENTER:

=INDEX(ROW(AE1:AE1299),MATCH(TRUE,EXACT(AE1:AE1299 ,"A"),0))

Biff

"nastech" wrote in message
...
hi, yes to all.. just the letters: A, a, B, b, C, c, D, d
just relative position: yes if getting the row number, is what that
means.

problems that arise, I believe are from actually doing work but some
functions only do half the job. e.g.: would think programming would
have
allowed easy exclusion of top rows where having absolute cell
references
that
control that column have:
A, a, B.. as part of the settings; but then, the formula will not
work.
I would have allowed programming to use: EXACT, ROW<(), then ""
nothing...

- either that or it's just some trick I haven't quite worked out.
- or uniqueness of problems, haven't been thought of by others, ...
thanks


"Biff" wrote:

What kind of data do you have in your range?

Do the cells just contain the single letter "A" or do they contain
strings
like "Address" or "adult" ?

So, if you're using MATCH then you just want the relative position of
"A"
within the array AE1:AE1299 ?

Your posts always confuse me!

Biff

"nastech" wrote in message
...
060724 Match, Exact? NA error
hi, trying to make an "exact" match for the case, of a character,
e.g.:
"A"

where the following works, am trying to isolate capital "A"'s.
=MATCH("A",$AE$1:$AE$1299,0)

the following receives a NA error. Is there a correct way to
represent?
am open to inserting IF statements, EXACT, or ROW<=().. etc.
=MATCH(EXACT($AE$1:$AE$1299,"A"),$AE$1:$AE$1299,0)


example of an EXACT, that was able to get to work in combo with
other:
=SUMPRODUCT(--(EXACT(LEFT($AE$112:$AE$1300,1),"A")))