MAX(COLLECT multiple values

zksheets

The sheet I am working on keeps track of the most recent dates that an item is requested. One of these items have 2 different item codes, but they are an equivalent item. Let's say Item1 and Item2 are different names, but if either is requested, it counts for the same thing. The current formula to return one value is

=MAX(MAX(COLLECT({YTD Archived Request Range 1}, {YTD Archived Request Range 3}, Analyst102, {YTD Archived Request Range 2}, [Method/SOP #]@row)))

Where YTD Archived Request is the source sheet where we pull the dates from, Analyst is the specific person who requested the item on a particular date, and Method/SOP # is the column in the resulting sheet I need it to reference to know what item to look for in the source sheet. I want the box to return the latest date that either one of those items were requested, since the items are equivalent.

How do I make it so that the box will return the earliest date from either of the items?

IEPE

Hola, si quieres buscar por item creo te vendría bien usar:

y si quieres buscar por códigos,:

espero te ayude.

saludos.

zksheets

The date requested is in a different sheet than the one I am working on. I reference that sheet to find the dates according to the item, which is listed in both sheets.

IEPE

…solamente sustituye los rangos de la formula por las referencias a los rangos de las otras hojas, mi intención era mostrarte los argumentos correctos para las formulas,…..espero haberte ayudado.

un saludo

...just replace the ranges of the formula by the references to the ranges of the other sheets, my intention was to show you the correct arguments for the formulas,..... I hope to have helped you.

Best regards

Paul Newcome

@zksheets Are you able to provide some screenshots for context?

zksheets

@Paul Newcome Hi Paul, I was able to figure it out! I nested two COLLECT formulas within a MAX and it worked. Just needed to change the boxes it was referencing, and add a comma