Using Index(A:A,.........)

  • Thread starter Thread starter Biff
  • Start date Start date
B

Biff

Hi Folks!

Curious about using Index.......

When you index an entire column like A:A, are you really indexing an array
of 65536 values or are you just indexing the used range?

Biff
 
Whole column I believe.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
The reason I ask is that when I evaluate formulas with Index, the indexed
values are never shown.

Thank, Bob

Biff
 
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

Conditional Indexing 2
index, match in array setup question 1
INDEX return multiple columns 1
Correct #N/A Value 6
INDEX / MATCH performance for lookups 4
Using SUM + INDEX in array formula 5
Help with Index/Match function or similar 4
NETWORKDAYS ADD-IN PROBLEMS 1

Back
Top