Excel help please - filter and fetch values

the task can be handled as group by case

As an alternate we can rewrite mybe to a filter / Lookup case. A building block is to Split the Remit_ID Value into Currency and Account. For this step Regex can help us

1 Like