Reporting the maximum date within rows with the same keydata
Hello,
Perhaps to solve with a formula instead of a macro.
In column H (=8) is text data reported and there are always more rows below with the same data in this column.
In column EY (=157) is in some records a date reported. It is possible that some records has no reported date and in some are different dates.
In column FK (=167) I need to report the maximum date that exist within the rows where in column H the same data is reported.
H EY FK
aaa 01-01-2020 01-01-2022
aaa 01-01-2022
aaa 01-01-2022 01-01-2022
aaa 01-01-2022 01-01-2022
bbb
bbb
bbb
ccc 01-01-2025 01-01-2025
ccc 01-01-2025
ccc 01-01-2025
Is somebody knows how to solve. Should be great :)
regards, Johan
|