| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date reporting in cell | Excel Worksheet Functions | |||
| How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
| Problem with USEDRANGE.ROWS.COUNT reporting one row too many | Excel Programming | |||
| Reporting number of rows on a userform | Excel Programming | |||
| Selecting multiple rows from listbox for reporting | Excel Programming | |||
Threaded Mode
