Forum Discussion

Iron Contributor

Sep 29, 2023

Solved

EXPAND() function

Hi, and thanks in advance for any assistance. Can anyone provide information about the EXPAND() function? I'm looking to understand its use cases and how it can be applied in the dynamic array sp...

excel

Formulas and Functions

Riny_van_Eekelen
Sep 29, 2023
SanthoshKunder
That's odd. I see the screenshot. See below what I see.
Edit: attached the file now.

EXPAND example.xlsx10 KB

Riny_van_Eekelen

Platinum Contributor

Sep 29, 2023

SanthoshKunder One useful scenario I can think of would be what's shown in the picture below. I'm sure there are more.

SanthoshKunder

Iron Contributor

Sep 29, 2023

Thanks, Riny. Is there a screenshot that you forgot to include?

Riny_van_Eekelen
Platinum Contributor
Sep 29, 2023
SanthoshKunder
That's odd. I see the screenshot. See below what I see.
Edit: attached the file now.

EXPAND example.xlsx10 KB
- SanthoshKunder
  Iron Contributor
  Sep 29, 2023
  It's back. Thanks for the answer