Kudos SirJB7! You have saved me hours of cutting & pasting blank cells to make things match up. Not sure I understand how the formula works, but it does, works like a charm. Thank you!
I have a task every quarter to produce a real estate agent production list. Each sale has two halves, a listing half, and a selling half. ie a $10,000 commission has a $5,000 list side & a $5,000 sell side. One agent can 'get' both sides or it can be two different agents.
At the moment I use a...