need breakdown each step of macro for me

**jmendenhall22** · 05-26-2013, 12:37 AM

Hello,
I have these two macro's and would like to know what each step does so I can modify them to work on other sheets. Is there anyone out there who can do this for me?
=IFERROR(INDEX(CHARTASSIGN!$C$3:$C$30,SMALL(IF(LEFT(CHARTASSIGN!$C$3:$C$30,3)<>"DR.",0,100)+IF(CHARTASSIGN!$C$3:$C$30>"",0,100)+ROW(CHARTASSIGN!$S$3:$S$30)-2,ROWS(CHARTASSIGN!$C$3:$C3)),0),"")

=IFERROR(INDEX(sheet2!$D$4:$D$74,SMALL(IF(LEFT(sheet2!$D$4:$D$74,3)<>"7,7mtg",0,100)+IF(sheet2!$D$4:$D$74>"",0,100)+ROW(sheet2!$S$3:$S$30)-2,ROWS(sheet2!$D$D4$D4)),0),"")

they are both entered with the CNTL SHFT ENter command to get the correct brackets. When coping the brackets do not follow.
Thank you
John

**Mallycat** · 05-26-2013, 12:41 AM

These are not macros, they are formulae. It is very difficult to tell what they do without the context of the sheet. The curly brackets you refer to are what is refered to as an Array Formula. This is when a single formula exists in more than one cell, because the output requires more than one cell to display the result. To edit this formula you need to highlight the entire range that has the curly brackets, press F2 to edit the formula, then press Ctrl-Shift-Enter to save the changes.

The best way to work out what they do is to learn what each of the functions do (Index, IF, etc) and then work you way from the inside out, looking at the sheet and seeing what the results are.

need breakdown each step of macro for me

LinkBack

Thread Tools

Rate This Thread

Display

need breakdown each step of macro for me

Re: need breakdown each step of macro for me

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions