Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I hope someone can assist me on this one. I was hoping it would be fairly easy for someone to write a macro which can look down a column U and find a positive number and then match this against a negative number of the same amount. Basically there should always be a positive and negative number. Where there is a match with say 34.28 and -34.28 then both rows should be highlighted. I want to basically find the rows where there is only either a positive number or a negative number with no match to the other side. There may well be two rows containing 34.28 and only one containing -34.28. I dont know how you can factor this in to the equation. Sorry if this is a rather complex bit of code....... Stuart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Adding positive or negative numbers in a column | Excel Discussion (Misc queries) | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
How to switch negative numbers to positive numbers in Excel ? | Excel Worksheet Functions | |||
Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) |