View Single Post
  #2   Report Post  
Old September 4th 19, 04:29 PM posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,713
Default Reporting the maximum date within rows with the same keydata

Hi Johan,

Am Wed, 4 Sep 2019 07:34:55 -0700 (PDT) schrieb JS SL:

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


try:
=IF(MAX(IF($H$2:$H$1000=H2,$EY$2:$EY$1000))=0,"",M AX(IF($H$2:$H$1000=H2,$EY$2:$EY$1000)))
Insert this formula with CTRL+Shift+Enter (Array formula)


Regards
Claus B.
--
Windows10
Office 2016