Results 1 to 9 of 9

Using Index for a dynamic range

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

11-03-2014, 06:58 PM #5
nigelbloomy

View Profile

View Forum Posts

Visit Homepage
Valued Forum Contributor

Join Date

11-06-2013

Location

USA

MS-Off Ver

Excel 2010

Posts

1,011
Re: Using Index for a dynamic range

I don't want to "select" the whole sheet. I just want the formula to look at the whole sheet to determine where the last row and column are.
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

[SOLVED] Using INDIRECT with a dynamic range name as the array in an INDEX formulae = #REF

By Gandalf21 in forum Excel Formulas & Functions

Replies: 3
Last Post: 09-12-2013, 09:27 AM
Vba index and match for dynamic range

By _google in forum Excel Programming / VBA / Macros

Replies: 7
Last Post: 02-20-2013, 10:25 AM
Dynamic Range issues with index/match(i think)

By Furby in forum Excel Formulas & Functions

Replies: 4
Last Post: 02-11-2013, 08:18 AM
dynamic range by column index

By the666bbq in forum Excel General

Replies: 2
Last Post: 03-14-2011, 12:03 PM
dynamic range for index/match formula

By excellicious in forum Excel Formulas & Functions

Replies: 6
Last Post: 03-29-2008, 07:41 PM

Tags for this Thread

index,
offset

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 05:54 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1