Array to include extra column

**Kmartin83** · 04-13-2015, 06:28 AM

Hiya,

A few weeks ago, Special-K helped me with the following Formula:
=IFERROR(INDEX('Raw Data'!$A$2:$F$5464,SMALL((IF('Raw Data'!$A$2:$A$5464=$A$2,ROW(INDIRECT("1:"&ROWS($A$2:$A$5464))))),ROW(A1)),COLUMN()-9),"")

This looks at my raw data and implants the information onto my Compliance spreadsheet.

I have a problem now. I have added an additional column to the Raw Data (Column G), but when I place this formula in the Compliance Sheet and copy/draw it across as I have done previously, it wont pick up column G from the Raw Data sheet; though it still perfectly picks up Columns A-F.

Any ideas?

Thanks,
Kelly

**zbor** · 04-13-2015, 06:29 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**Kmartin83** · 04-13-2015, 06:47 AM

Changed Title.

**Kmartin83** · 04-14-2015, 04:00 AM

Sorry to bump my thread, but can any one help me to understand why I can't add an additional column into this formula? Driving me nuts!!

Thanks,
K

Array to include extra column

LinkBack

Thread Tools

Rate This Thread

Display

Array to include extra column

Re: Help with Array!

Re: Array to include extra column

Re: Array to include extra column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Populate one array from another array and print new array as a range

Loop new messages containing a table, populate a dynamic array, paste array to Excel

[SOLVED] Quick Array question - Copy array to another array then resize?

[SOLVED] Populate Listbox with all rows of a dynamic array where elements of a single array match.

Bookmarks

Bookmarks

Posting Permissions