Hello bees_knees. Welcome to the forum.

It is almost always helpful and expedient to upload a sample workbook directly to this forum - this should be a cut-down version of your real data, but with the same layout and containing enough data to demonstrate the difficulties that you are facing.

If you are not familiar with how to do this ...
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

click “Go Advanced” (next to Post Quick Reply – bottom right),
scroll down until you see “Manage Attachments”, click that,
click “Browse”.
select your file(s)
click “Upload”
click “Close window”
click “Submit Reply”

The file name will appear at the bottom of your reply.

(Of note: The 'paperclip' icon has not worked for some time. So please save yourself some grief.)