Get IF number is match?

Need help
1

Hi, i want the system to know if the Column A row number is match or equal to Column B

ex.

Column A
row 1 = 200
2 = 500
3 = 150
4 = 220
5 = 300
Total = 1170

Column B
row 1 = 1050
Total = 1050

so to make it equal to Column B Total number, in Column A row 4 system will only get 200 since from row 1 to row 4 the total is 1070 already so its close to Column B Total number then it will create a thing called Matched that will mark it as “yes”

how can i do this
Step 1 = check if Column A is = to Column B Total number
Step 2 = Create a thing “Matched” search for row 4 (whatever row that is matched the number) and mark it as “yes”

NOTE:

  • the system needs to make sure that row 4 or whatever row has the exact match number then drop the excess number

hope it make sense

thanks for the help

2

ok i think i got it working now

so what i did is get the total amount from 1 to row 4 or whatever row then check IF that total amount is the FIRST total amount that is greater than Column B Total amount IF yes then i will mark it as “yes”

3

This topic was automatically closed after 70 days. New replies are no longer allowed.