Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tough one, for me anyway....
For the great people here though? Probably a piece of cake. :)
I have a series of data, something like this: A B C D E HTW-C59 289 CAW 399.29 3.73 HTW-C59 289 MPR 397.51 4.04 HTW-C59 289 REM 397.27 4.07 HTW-C59 289 REM 397.23 4.08 HTW-170 4D2042 MPR 406.96 3.84 HTW-170 4D2042 REM 408.17 4.07 HTW-167 4D2042 BKM 392.74 4.11 HTW-167 4D2042 MPR 379.42 4.11 HTW-169 6D4012 VLC 394.53 3.96 HTW-169 6D4012 HAB 395.99 4.73 I need to perform standard deviation and averages for column D, for all the same values in column B. I need the actual value(not the calculation) stored in the last row of each "set" where column B is equal, say in columns E and F. There are more of each values than listed above, just wanted to keep the list short if possible, and there are differing numbers of each value in B. Meaning, say from above, there might be 35 289's, but 48 6D4012's. The next thing would be to delete all the rest of the rows for that "set", keeping just the row that has the average and std dev values in them, but that can be done manually if necessary. Again, as long as the value is in columns E and F and not the calc. Any help??? Thanks!! Shawn PS - I hope just the text values came through from what I pasted above, and not something in HTML. If it did come thru in HTML though, PLEASE accept my apology. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help. This is way too tough for me. | Excel Discussion (Misc queries) | |||
Tough one | Excel Discussion (Misc queries) | |||
Tough one: | Excel Discussion (Misc queries) | |||
OK tough one ! | Excel Worksheet Functions | |||
Tough one... | Excel Discussion (Misc queries) |