LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default find largest data (part2) hard work..

Hi,

It's request for a good programmers.
I have following table:

Owner Nr_flight Date Distance Pigeon Points
X 1 10-05-2003 100 X1 20,2
X 1 10-05-2003 100 X2 21,3
Y 1 10-05-2003 102 Y1 22,1
Y 1 10-05-2003 102 Y2 23,5
N 1 10-05-2003 105 N1 19,1
N 2 15-05-2003 120 N1 25,1
X 2 15-05-2003 121 X1 26,1
X 2 15-05-2003 121 X2 27,4
Y 2 15-05-2003 125 Y3 25,2
X 3 20-05-2003 130 X5 30,4
Y 4 25-05-2003 150 Y3 32,1

There are above is thousands records...
Range contents of columns:
-50 Owners,
-20 Nr_flights,
-Date (no matter),
-Distance in km (no matter),
-Each Owner has dozens pigeons,
-Points (no matter)

I'd like folowing automatic result:

W = sum best of points of 2 pingeons in range beetwen 100
and 125 km.
N = sum best of points of 3 pingeons in range beetwen 126
and 140 km.

count_optimum = W + N
Necessary condition:
Total distance counted pingeons must be minimum 650 km.

(in another sheet)
Owner perform condition (e.g. X) sum of points = ...
item Nr_flight Date Distance Pingeon Points
1 (e.g. 1) 10-05-2003 100 (e.g. X1) 20,2
2
3
4
5
sum of total distance ...

(3 rows empty)

Owner perform condition (e.g. Y) sum of points = ...
item Nr_flight Date Distance Pingeon Points
1 (e.g. 1) 10-05-2003 102 (e.g Y1) 22,1
2
3
4
5
sum of total distance ...

etc....all case perform condition

How could I do this?
It will appreciate if anyone can help.

Best Regards
Mark

 
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
I need find largest value in row Lion2004 Excel Discussion (Misc queries) 11 October 15th 07 02:08 PM
How to find the largest value in a column? needofhelp Excel Discussion (Misc queries) 2 December 28th 06 07:34 PM
Find 2nd Largest Value Session101 Excel Worksheet Functions 2 April 10th 06 09:16 PM
formula won't work unless column of data is a hard number Ron Excel Worksheet Functions 2 May 17th 05 03:21 PM
find largest data Mark[_17_] Excel Programming 8 October 15th 03 06:14 AM


All times are GMT +1. The time now is 11:48 PM.

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

About Us

"It's about Microsoft Excel"