I know that I can set up a simple filter on the source table, but I want this
to update on a separate worksheet where I have additional calculations.

Sorry, didn't explain it properly on the original message.

"Hector" wrote:

Hello there, I have a table looking like this:

Branch Date Sales ...
Covent 28 5555 ....
Leeds 28 354 ......


Covent 29 458 ....
Leeds 29 165 ...

I need to set up a filter or formula that based on the value in Branch,
would give me the remaining values in that row, but following the daet
sequence.

To look like:

Branch Date Sales ...
Covent 28 5555 ...
Covent 29 458 ...

Any advice?

Please