Forum Discussion
Help with formula - Finding adding unique values, with a dollar range, within a date
Using Excel for Mac, version 16.88, License: Microsoft 365, 2024 I have a large spreadsheet (approx 30,000 rows). 1) I need search by Date (A) to find transactions in April. 2) Then I need to ...
If you have access to GROUPBY, you could use this formula:
=LET(
less_than_or_equal_500, Demo[Amount] <= 500,
greater_than_500, Demo[Amount] > 500,
fn, HSTACK(COUNT, SUM),
a, GROUPBY(Demo[Date], Demo[Amount], fn, , 0, , less_than_or_equal_500),
b, GROUPBY(Demo[Date], Demo[Amount], fn, , 0, , greater_than_500),
VSTACK(a, b)
)