First ditch that giant table. Split the data into three sheets: Events, Players, and Timings. In each sheet keep only columns that are needed. Then use named ranges so your formulas read like code, not gibberish. Use a simple script or macro to pull each event into a separate table per player. Keep the logic in one place – a single function that takes a player and a timestamp and returns the raid time. That way you never re‑write the same formula twice. Also, set all dates to a single format, 0 for empty cells, and use conditional formatting to flag outliers. If you’re still in Excel, replace nested IFs with a lookup table; if you’re in Sheets, use the FILTER function. Clean code, clean spreadsheet, done.

Glad you’re on the same page. Just remember: keep the macro lean, test it on a small batch first, and if anything goes wrong, rollback to the old sheet. Happy cleaning.

Nice, that’s the only way to avoid a spreadsheet disaster. Just one more tip: log every change with a timestamp in a separate audit sheet. That way if you accidentally delete a value you can reconstruct it. Good luck.