Could we see an example workbook? It would make it far easier to understand your need.

Desensitize any sensitive data and show expected results where possible.

BSB