rhouston08
New Member
- Joined
- Nov 25, 2013
- Messages
- 21
I would like to retrieve the max number in a dataset. For example, in the table below, I would like to find the max check no and return the date associated with that check no, and I would like the cells in column D to show the date for the max set.
<colgroup><col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64"> <col style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;" width="97"> <col style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" width="68"> <tbody>
</tbody>
A | B | C | D |
Client | Check no | Day deposited | Date |
0001 | 1 | 1/1/2014 | 1/16/2014 |
0001 | 2 | 1/6/2014 | 1/16/2014 |
0001 | 3 | 1/11/2014 | 1/16/2014 |
0001 | 4 | 1/16/2014 | 1/16/2014 |
0002 | 1 | 1/2/2014 | |
0002 | 2 | 1/7/2014 | |
0002 | 3 | 1/12/2014 | |
0003 | 1 | 1/3/2014 | |
0003 | 2 | 1/8/2014 | |
0003 | 3 | 1/13/2014 | |
0004 | 1 | 1/4/2014 | |
0004 | 2 | 1/9/2014 | |
0004 | 3 | 1/14/2014 | |
0004 | 4 | 1/19/2014 | |
0004 | 5 | 1/5/2014 | |
0005 | 1 | 1/10/2014 | |
0005 | 2 | 1/15/2014 | |
0005 | 3 | 1/20/2014 |
<colgroup><col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64"> <col style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;" width="97"> <col style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" width="68"> <tbody>
</tbody>