Good morning all, I am trying to pull the latest of duplicate results using the following formula. Can anyone tell me where my syntax is incorrect?
Please Login or Register to view this content.
Good morning all, I am trying to pull the latest of duplicate results using the following formula. Can anyone tell me where my syntax is incorrect?
Please Login or Register to view this content.
That looks like Google Sheet formula rather than Excel formula (ArrayFormula() isn't Excel function as far as I know).
Also, looks like MATCH syntax is off. You are supplying it 4 arguments MAX(), 1, ()*() & 0. But there should be only 3 arguments for MATCH function...
MATCH(LookupValue,LookupRange,MatchType) where match type can be 0, 1, -1.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
It is google sheets. But most things seem similar enough. So where I messed that up is trying to add MAX. I'm trying to get it to pull the latest date from identical responses that only have 1 different value, but I'm not sure where to put the max function.
Wrong forum to ask question then. Should be asked in.
https://www.excelforum.com/for-other...mobile-os-etc/
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks