| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting
Hi Everyone
New on this Forum Sure that this kind of stuff have been already... I apologize... I was on XP Office 2003 and Macro Excel 4 Laptop died... Now W7 Office 2010 and starting to learn VBA... Datas Date................Name.............Results 01/02/2012......Jean...............10 01/02/2012.......Paul...............5 01/02/2012.......Jean..............-5 01/02/2012.......Pierre............-5 O2/02/2012.......Jean.............-5 02/02/2012.......Pierre............10 etc My problem : sort that datas (up to 1000 lines !) By date 01/02/2012... Negative.... Positive.... Net.... Ratio(Pos/Neg) 02/02/2012... By name Jean.............. Negative.... Positive.... Net.... Ratio (Pos/Neg) Pierre.... And the VBA code to do that... Thanks Everyone B (this site is amazing but so hudge... that it is difficult to find something) PS I already tried Pivot Table : I can't insert =0 or =0 inside Pivot to have a column for negative values /positive values Last edited by bert505 : April 9th 12 at 03:43 PM Reason: More... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming | |||
Threaded Mode
