J
JeremyBrown486
Hey,
I have an excel sheet with some 3000 lines that represent a truss I'
trying to design. I'd like to write an excel that checks the beam numbe
(in column A) and the load case (in column C) for the maximum value i
column E. Then take that line and paste it into a seperate tab t
generate a list of max values for each load case. Each beam has 3-4 loa
cases (column C) and I need to get the max for each load case for eac
beam!
ie. element 3 has 10 values reported for dead load, Live load, and win
load. I want the program to go through each of these 3 loads find th
max value and put those 3 lines of values in a diffrent sheet. and the
move on to the next element.
Any idea how to do this??? Help!
I have an excel sheet with some 3000 lines that represent a truss I'
trying to design. I'd like to write an excel that checks the beam numbe
(in column A) and the load case (in column C) for the maximum value i
column E. Then take that line and paste it into a seperate tab t
generate a list of max values for each load case. Each beam has 3-4 loa
cases (column C) and I need to get the max for each load case for eac
beam!
ie. element 3 has 10 values reported for dead load, Live load, and win
load. I want the program to go through each of these 3 loads find th
max value and put those 3 lines of values in a diffrent sheet. and the
move on to the next element.
Any idea how to do this??? Help!