Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare/match positve number against negative number?
I have one worksheet that contains multiple fields. I wish to compar all of the rows in the sheet with each other and, when 4 of the field match, copy the matching rows to another sheet/workbook. Now, this I can manage but, one of the fields will contain a positiv numbers, say 100 and another field will conatin a negative; -100, s they aren't actually a match. It is these that I want to capture as 'match', although the other 3 fields will also have to be a prope match. Any ideas where to start? I guess the abs() function might come int this somewhere but I just need a pointer in the right direction? I' then happy to go off and (try to) work the code out. Thanks, Adria -- Kobayash ----------------------------------------------------------------------- Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87 View this thread: http://www.excelforum.com/showthread.php?threadid=31488 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
Can I automatically change all positve numbers to negative number. | Excel Discussion (Misc queries) | |||
Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) |