using row() - or how to look at 1st column of ths row

  • Thread starter Thread starter jaredh
  • Start date Start date
J

jaredh

so I can use =exact(a1, "x")

but is there a way to simply return the 1st row to this?

along the lines of =exact((row1), "x)

it would help as a1 is static, and (row1) would be dynamic....

again much thanks,

jare
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

group rows 2
How Do you send results of calc to seperate rows of answers to then later create chart 4
how to freeze pane with only one row? 2
Good at Macros? I'm Trying to find duplicate entries. 3
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
Insert row at change macro - how to change it. 1
Return cell reference rather than value 4
Identify condition using multiple criteria WITHOUT sumproduct?.. 14

Back
Top