I have a table which contains data from 2 sources.
The first source shows what my customers paid to an affiliate, and the second source shows what that affiliate paid me. I am trying to highlight when the amount that I should be paid does not match what I was actually paid.
To accomplish this I need:
Where TEXT in COL 1 begins with "FH"
if VARCHAR in COL 2 matches any other rows in the table (where TEXT in COL 1 does not begin with "FH")
then index NUMBER in COL 11 and calculate the total sum of all indexed/matched cells (where TEXT in COL 1 does not begin with "FH")
if total of amount indexed/matched does not equal the amount in COL 11, then add ID to that cell
37 freelancere byder i gennemsnit $123 på dette job
Hi, So the script will injected after 2 data source has been feed into the table right? Could I take a look at how the table look like? I then can iterate over COL1 value and proceed the comparing Thanks Ngan Le
Okay I got that! I can accomplish that for you, what Customer paid to Affiliate and what Affiliate paid to You Inbox me and I'd love to work on that for you My reviews speak for my quality of work :) ~ Zain B.