Forum Discussion

Copper Contributor

Nov 02, 2024

Return Matching Data from Most Recent Date based on condition

I am looking to return the result as Open or Close against the most recent date for each customer code. I have tried several formulas and combination of formulas. Below is the data I'm working wi...

excel

Formulas and Functions

office 365

Lorenzo

Silver Contributor

Nov 02, 2024

jomymathew

=HSTACK( Table, IF( Table[Date] < MAX( Table[Date] ), "Close", "Open" ) )

sample_jomymathew.xlsx12 KB

jomymathew
Copper Contributor
Nov 02, 2024
I'm unable to use HSTACK in my version. Is there any alternate option you can help with. Thanks in advance.
- Lorenzo
  Silver Contributor
  Nov 02, 2024
  What version of Excel do you run?
  - jomymathew
    Copper Contributor
    Nov 02, 2024
    Office 365 ProPlus