#1   Report Post  
Junior Member
 
Posts: 2
Default Structures

Hey,

I have an excel sheet with some 3000 lines that represent a truss I'm trying to design. I'd like to write an excel that checks the beam number (in column A) and the load case (in column C) for the maximum value in column E. Then take that line and paste it into a seperate tab to generate a list of max values for each load case. Each beam has 3-4 load cases (column C) and I need to get the max for each load case for each beam!

ie. element 3 has 10 values reported for dead load, Live load, and wind load. I want the program to go through each of these 3 loads find the max value and put those 3 lines of values in a diffrent sheet. and then move on to the next element.

Any idea how to do this??? Help!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Persistent Data Structures in VBA [email protected] Excel Programming 5 September 10th 07 04:20 PM
data structures vivmaha Excel Programming 2 June 26th 07 10:18 PM
help on looping structures Janis Excel Programming 2 September 4th 06 01:00 AM
Using VS 2003 .NET structures in VBA application Wayne Clements Excel Programming 0 March 27th 06 01:18 AM
If...then structures HeyMickey Excel Programming 5 September 14th 05 01:20 AM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"