Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort with IF functions?
I didn't know what to put in the subject. Here is what I hope to do. As you
go down column B each time the cell equals false (based on an if function) it will place the value in Column A (in the same row) one column over to the right. This will allow me to add up each column seperately when it is sorted this way. How in the world can this be done without some crazy macro? See an explantion below. I would arrive at this type of scenario after an alphabetical sort: Column A B C D E F A1 100 TRUE 100 A2 200 TRUE 200 A3 300 FALSE 300 A4 400 TRUE 400 A5 500 TRUE 500 A6 600 FALSE 600 A7 700 TRUE 700 A8 800 TRUE 800 A9 900 FALSE 900 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Automatic Sort with VLOOKUP/LARGE Functions | Excel Worksheet Functions | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) |