LinkBack URL
About LinkBacks
Lets say your value of 11 is in C21 and I named your column A month and column B year if you do not want the slash take out this part &"/" :=INDEX(Month&"/"&Year,MAX(IF(table=C21,ROW(Month)-ROW(A2)+1))) This is confirmed with ctrl+shift+enter
Lets say your value of 11 is in C21 and I named your column A month and column B year if you do not want the slash take out this part &"/" :=INDEX(Month&"/"&Year,MAX(IF(table=C21,ROW(Month)-ROW(A2)+1))) This is confirmed with ctrl+shift+enter
Last edited by khamilton; 11-24-2009 at 10:29 AM. Reason: forgot the ctrl+shift+enter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks