Hi SME,
I'm trying to compare dates within grouping with the earliest date designated as "1" and the latest as "2." My grouping is by Page Number, each number has two records. Attached is a sample dataset. Column D is what I would like to get based on the date comparison with the page grouping.
Appreciate your help.
Thanks,
kwl
