Fill array formula

**tone640** · 07-25-2011, 04:11 AM

I have:

Please Login or Register  to view this content.

This makes the whole range the array, I need one cell to be the array, then filled down.

Thanks in advance.

**Colin Legg** · 07-25-2011, 04:16 AM

Hi,

I listed 4 ways to do this under section 3.2 here.

**tone640** · 07-25-2011, 04:23 AM

Sorry Colin. I pasted the formula for a single cell. I meant to paste:

Please Login or Register  to view this content.

To fill down to the same row as there is data in column A. How would I do this?

**Colin Legg** · 07-25-2011, 04:25 AM

Hi,

I understand your question. Did you read the link I posted (section 3.2)?

**tone640** · 07-25-2011, 04:27 AM

Of course, they all require me to define the range (don't they?).

**snb** · 07-25-2011, 04:55 AM

if I understand you correctly

Please Login or Register  to view this content.

**tone640** · 07-25-2011, 05:18 AM

Thanks snb.

Two small problems:

This is one column out, so I have changed the 48s to 49s.
This only works if the column already has data in it.

How do I adjust it accordingly?

**snb** · 07-25-2011, 05:38 AM

I assume column 48 contains data ?

Please Login or Register  to view this content.

**tone640** · 07-25-2011, 05:51 AM

Thanks for your help, much appreciated.

Fill array formula

LinkBack

Thread Tools

Rate This Thread

Display

Fill array formula

Re: Fill array formula

Re: Fill array formula

Re: Fill array formula

Re: Fill array formula

Re: Fill array formula

Re: Fill array formula

Re: Fill array formula

Re: Fill array formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions