| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of all even and odd numbers between two columns | New Users to Excel | |||
| Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
| How do i Match all COLUMNS? | Excel Worksheet Functions | |||
Linear Mode
