Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 25 Apr 2024 09:07:04 +0000
Post From: Spread Sheet study, Find last value of previous month in AA3 column
| [2013-11-07 19:47:20] |
| jackw - Posts: 57 |
|
Enter the following formula in cell K2: =INDEX(AA3:AA1003,MATCH(DATE(YEAR(A3),MONTH(A3),0),A3:A1003,0)) This will give you the value in cell AA3 as of the last day of the prior month. Then you can just put =K2 in cell K3 and let it copy down. Date Time Of Last Edit: 2013-11-07 19:47:45
|