Open CLosing.xlsx (14.4 KB)
Dear DNA Team,
The attached excel file is just a sample of the data that I already transformed.
I will appreciate your help as I am kind of stuck.
I grouped the data by open & closing balance but now I would like to return:
for the Open Balance Min index number and return the amount
for closing Balance I would like to return Max index number and return the amount
I would like to return the data below;
Could you please help.