LinkBack URL
About LinkBacks
When I insert more helper columns, everything on my formations page goes blank. Why is this. It's like it doesn't recognize that a column has been inserted.
When I insert more helper columns, everything on my formations page goes blank. Why is this. It's like it doesn't recognize that a column has been inserted.
Originally Posted by rolltyde12
This formula does not require helpper columns. Input formula in cell A2 in worksheet "Formations" and copied down.
=LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX(MASTER!$D$2:$D$163,SMALL(IF(ISNUMBER(SEARCH("Ac",MASTER!$D$2:$D$163)),ROW(MASTER!$D$2:$D$163)-ROW(A$2)+1),ROWS(A$2:A2)))))
The formula is an-array need to hold down:
Ctrl,Shift,Enter
Example below.
yes it will happen so because coloumn references would be changed after inserting new column to Master sheet.
what you have to do is to decide first that how much helper columns you need at maximum (i-e how much values you want to search and return in Formation sheet.)
then implement formula in helper columns and Formation sheet columns.
you can tell me that how many values you want to search in Master and how many columns you need in Formation tab. then I'll make it for you.
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks