Hi,
I've got a spread sheet that gets updated with a macro to show a date and code. I need to count up all of the dates for each ID number generating the total field in col D. What complicates things for me is that there are an undetermined number of cols for each ID (row).
Many thanks for any help.
<tbody>
</tbody>
I've got a spread sheet that gets updated with a macro to show a date and code. I need to count up all of the dates for each ID number generating the total field in col D. What complicates things for me is that there are an undetermined number of cols for each ID (row).
Many thanks for any help.
ID | fname | lname | total | date 1 | code1 | date2 | code2 | date3 | code3 | date4 | code4 | date5 | code5 | date6 | code6 | date7 | code7 | date8 | code8 |
001 | sam | smith | 2 | 10/10/2015 | VM | 10/11/2015 | HP | ||||||||||||
002 | john | doe | 1 | 09/01/2015 | |||||||||||||||
003 | ben | franklin | 3 | 09/02/2015 | hist | 09/08/2015 | rre | 09/12/2015 | |||||||||||
004 | tom | jefferson | 0 | ||||||||||||||||
<tbody>
</tbody>