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... |
#2
|
|||
|
|||
Hi Guys,
My point is : I dont know how to SPEAK/WRITE VBA!!! I started VBA 10 days ago and I am half way : select files by browser (thks J. Wallenbach), transform CSV files to xls files through delimiters, wipe some unnecessary columns, transform some "crazy" datas to numeric data... not bad... But I need your help... to "transform my datas a/ Pivot is not a way coz not possible to sort neg value / pos value (=, <=) b/ Old way : Set value in Day1 variable of Range A1 While row is not "" Search next occurence of value Day1 Set value in Day2 of this position (Trap error if value Day1 = value Day2) Select Area Sumif of area(C) = Store value in variable X Sumif of area (C) <= C Store value in variable Y Now put these values in new sheet + calculations (y-x and x/y) Back in first sheet Day1=Day2+1 Wend Some errors errors.. perhaps.. but globally is that |
Reply |
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 |