Hello all,
I am trying to set up a worksheet that pulls information from another sheet. On sheet one I have columns starting with a date column (COL A). I am trying to get information from a second column (COL AA) to return to the second worksheet. However, the data in COL AA is not consistent, in that there are only just a few entries throughout the year. I am trying to get the last entry in a calendar year from COL AA.
<tbody>
</tbody>
On the second worksheet the correct answer would be $2.98654. What should the formula look like?
Thank you for your help.
Joseph Carney, C.M.
Airport Operations Specialist
I am trying to set up a worksheet that pulls information from another sheet. On sheet one I have columns starting with a date column (COL A). I am trying to get information from a second column (COL AA) to return to the second worksheet. However, the data in COL AA is not consistent, in that there are only just a few entries throughout the year. I am trying to get the last entry in a calendar year from COL AA.
A | AA |
1/1/19 | |
1/31/19 | $3.984544 |
2/22/19 | $3.04589 |
. | |
. | |
. | |
11/28/19 | $2.98654 |
12/31/19 |
<tbody>
</tbody>
On the second worksheet the correct answer would be $2.98654. What should the formula look like?
Thank you for your help.
Joseph Carney, C.M.
Airport Operations Specialist