I have a table with codes and dates not in consecutive columns. The codes
may repeat and each code could have a different date. I only need the max
date for each code type. The table has about 3200 rows and could change
size. It is something similar to the example below:

541 John Smith 11/01/08
541 John Smith 12/01/09
231 Allison Miller 10/01/08
340 Mary Johnson 09/09/09
000 Steve Rogers 11/10/09

If I was searching for 541, I would need 12/01/09 to be returned. Please
let me know what formula would be best to use in this case.