ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to build a formula to match numbers in 2 columns with the equ. (https://www.excelbanter.com/excel-worksheet-functions/6092-how-build-formula-match-numbers-2-columns-equ.html)

mcdilash

how to build a formula to match numbers in 2 columns with the equ.
 
I'm attempting to write formula to match 2 seperate columns. The first
column will only match 2 sets of like numbers. The 2nd column involves
matching a positive amount with a negative amount (where the amount was
credited back). I need to delete these rows of matching potive/negative
amounts.



Frank Kabel

Hi
not really sure. Could you give an exmaple (or post some example rows
of data)

--
Regards
Frank Kabel
Frankfurt, Germany

"mcdilash" schrieb im Newsbeitrag
...
I'm attempting to write formula to match 2 seperate columns. The

first
column will only match 2 sets of like numbers. The 2nd column

involves
matching a positive amount with a negative amount (where the amount

was
credited back). I need to delete these rows of matching

potive/negative
amounts.





All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com