Search results for query: *

PHV, Works great. Thanks! Have a star! thunderkid

How do I use awk to select last record in data below: 23 100 345 F0001 24 400 241 F0002 25 234 213 F0002 30 234 211 F0003 31 212 211 F0003 32 112 211 F0003 26 212 211 F0004 desired format 23 100 345 F0001 25 234 213 F0002 32 112 211 F0003 26 212 211 F0004 Thanks thunderkid

futurelet, your solution worked. vgersh99, as for my comment on "col1 fields may be repeated", here is further explanation. In those cases where column 1 repeats a value, I wanted to make a new calculation for each occurence. In my example, alpha is repeated, so two calculations I wanted two...

Thanks PH. Just what I needed. You get a star. thunderkid

I am trying to sums up col2 data in following data file # ----- data.txt ------- alpha 2 alpha 3 beta 4 beta 6 beta 10 gamma 1 alpha 4 alpha 10 desired results Col1 sums alpha 9 beta 10 gamma 1 alpha 14 Note that col1 fields may be repeated, but I want to make new calculation when they...

jdhilljr, Your solution was right onthe mark. Thanks. have a star! thunderkid

I am running into limitations with IF worksheet function--allows seven nested IF statement. I have budget worksheet and I want the balance to be read based on month of year. Here is an example: B2...

Perfect futurelet! Thanks a million. Have a star! thunderkid

Need help! I am trying to calculate the average for the 5th column values for records when value in third column changes. A sample of data is given below. thanks thunderkid data ----- short 2 1 3 2 0 short 2 1 3 2 0 short 2 1 3 2 0 short 2 1 3 2 0 short 2 1 3 2 0 short 2 1 3 2 0 short...

I have solved my problem using awk. Thanks thunderkid

I am trying to format inputs from several processed files. I want to use cut command. Current: File1col1 File1col2 File1col3 File1col4 I have tried: cut -f1,2 File1.dat > firstsec.dat cut -f3,4 File1.dat > thirdfourth.dat The files have space as a delimiters. As I have use Cut it is not...

vgersh99 & PHV Thanks for your solutions. PHV, that was a nice touch for the sort on the output data. Both deserve a star! thunderkid

I need to calculate the total for last two columns and print values in summary table. Sounds simple? I have tried modifying other scripts and searching the forum, but just don't get it. Below is sample data: 1 redx 55 1 redy 47 2 redx 23 2 redy 42 3 redx 50 3 redy 51 . . . 30 redx 30 30 redy...

mikevh Double thanks for solution and follow-up explanation. Have a star! thunderkid

futuerlet Once again you came through with a gem! There is much to be learned from you and others. Thanks. Have a star! thunderkid

futurelet, Your solution worked like a charm. How would your solution change as modified below? See desired results. short 1 1 455 17 8 0 short 1 1 455 20 6 2 short 1 1 455 20 4 2 short 1 1 345 20 4 0 short 1 2 405 17 8 0 short 1 2 220 17 6 2 med 1 1 455 17 8 0 med 1 1 450 20 6 2 med 1...

This is second part of previous thread. I need help with summarizing the results of data collection process. The data is as follows: short 1 1 455 17 8 0 short 1 1 455 20 6 2 short 1 1 455 20 4 2 short 1 1 345 20 4 0 short 1 2 405 17 8 0 short 1 2 220 17 6 2 med 1 1 455 17 8 0 med 1 1 450...

mikevh, Your answer worked great. I have seen the use of ":" and "?". Could yo explain how it works? Thanks. thunderkid

I am trying to make a calculation from data below for equipment simulation.Sample of data is given below for short and med cases. The calculation is for solvent that is expended during operation. Col 6 shows the amount of solvent available. To get expended solvent you have to subtract next...

I managed to get macro to work with the following. Thanks for the help. Charts.Add With ActiveChart .ChartType = xlColumnClustered .SetSourceData Source:=Sheets(sh1).Range("E10:F14"), PlotBy _ :=xlColumns .Location Where:=xlLocationAsNewSheet...