Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Advanced filter search
Gents,
I have a problem on one of my spreadsheet where I have a table with data on columns A thru E. What I want is to have a macro which can look in column A for rows having exactly the same value, cut them and paste them somewhere in the bottom of the same sheet but only in one condition. Their values in column E have to be opposite. This is an example. On the below example, A1 and A3 are similar and their values on E are opposite (similar but opposite), our macro should then cut these two rows (1 & 3) and paste them on row 8. A2 and A4 also have the same values but their values on column E are not opposite (E2 & E4 are equal but not opposite) the macro should not get them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |