Compare two rows and adjust for $0.01 rounding

[ELPC]

Hi all, 

I'm trying to compare two rows where the "Name" and "Traveled To" columns are the same.  (Net Pay = Earnings column less all the other columns)  I need to compare the Net Pay lines in the 2 rows.  If there is a difference of 1 cent, I want to adjust the Lived State Tax column for the 1 cent.  Then I would just put in another formula tool to recalculate the Net Pay column so they now match.  I've tried the Multi row formula but couldn't come up with a formula that would work.  Any help would be greatly appreciated!  Thanks.  

Net Pay = Earnings less all the other columns

[fmvizcaino · Accepted solution]

Hey @ELPC ,

Here it is.

Best,

Fernando Vizcaino

[JarekSkudrzyk]

Hi,

I have done the comparison using a combination of summarize, formula and cross tab tools - please find attached (cross tab tool allows the workflow to function properly even when new columns are added)
Hope this is helpful.

[JarekSkudrzyk]

Sorry, did not notice that the question has already been answered:) 

[fmvizcaino]

No worries @JarekSkudrzyk . The more answers and different solutions, the better! 

[ELPC]

Thank you so much!  That worked.