I have one more question. If I want to change the formula to the 3rd, 4th from last can I just write 3,4 etc in the same formula? Also, if I want to change all references to worksheet 5-13 to 6-13, 7-13 etc, how could I do that. Couldn't I reference a cell, maybe an indirect, with the month and then include it in all the formulas? I guess I could just do a search and replace as well but adds a step. Thanks.
=INDEX('05-13'!G8:G2885,LARGE(IF('05-13'!F8:F2885=A9,ROW($F$8:$F$2885),""),COLUMN(A1)))
You can do all of those things but we need to know what your end goal is.
We're offering suggestions to your questions but before you get those working correctly you're already wanting to expand the scope of what you're doing.
At this point I don't know what to suggest because we haven't resolved the original problem/question/request yet.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Can you post a SMALL sample file (no bigger than 50kb) that shows your data and the results you expect?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks