Delete rows in excel yet retain formulas

[Dave (David Wiebelhaus)]

@VanithaRajakumar I was basing it off of the solution provided here: Left excluding Join - #17 by VanithaRajakumar

This would give you a datatable that only contains rows if ID in Table 1 is NOT in Table 2. I’ll call this dt3

Then you would use a for each row activity on dt3.
Assign dt3.item(“Num1”) = “write your formula here”
Assign dt3.item(“Num2”) = “write your formula here”
Assign dt3.item(“Total”) = “write your formula here”

After iterating through dt3, write it back into excel. For your formula, you’ll want to use the row index + 2 to (like you mentioned) so it can reference cells properly