Sorry, I'll change the title if anyone has a suggestion.
I have a row of columns starting from B1- 2009, 2008, 2007, 2006 and so on.
Every year I need to insert a new column so B1 would now be 2010, C1 2009, etc.
I need to somehow reference the last year that "has something" in it in any given row to column A. I have 100's of rows so I'm looking to avoid manually going in and finding the last date (cell with content).
I can't wrap my mind around this one. Any ideas?
Thanks!
Last edited by sable; 08-11-2009 at 11:28 AM.
How about?:
"Find Latest Date/Year Within a Column/Range of Dates"
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are a few approaches, one might be:
but this is not good performance wise... keep ranges (ie B2:Z1000 to a minimum) ... perhaps consider using a Dynamic Named Range ? (see link in sig.)
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Okay, I'll check that out and let you know how it works out. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks