Column A = Date
Column B = Numbers
Column C = results
As you can see Column C, I manually did what I want the formula to do, which is get last number from the previous week. (weekdays only, but can be either 1,2,3,4 or 5 days due to holidays)
Column A = Date
Column B = Numbers
Column C = results
As you can see Column C, I manually did what I want the formula to do, which is get last number from the previous week. (weekdays only, but can be either 1,2,3,4 or 5 days due to holidays)
Last edited by borabora12; 04-20-2009 at 05:49 PM.
How's that attached look to ya?
Could mash that into one formula I suppose, but it's easier to follow the logic when left as is. Helper column contains =WEEKDAY(A1) then the answer column references that with an offset and reference to the weekday as per how many rows to shift.
IE
and thenPlease Login or Register to view this content.
The formulas can both be dragged down as far as needed, let me know if that helps.Please Login or Register to view this content.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
looks great! just wondering how I could mash that together?
Put that in C3 and drag down.Please Login or Register to view this content.
mew!
Without helper columns you could use this formula in C3
=VLOOKUP(MAX(IF(A3:A$30<=A3-1-WEEKDAY(A3),A3:A$30)),A3:B$30,2,0)
needs to be confirmed with CTRL+SHIFT+ENTER and then copied down....
thanks guys!!!!
Thank you for marking your thread as solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks