LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default getting value filtering series of data

Hi all
Can anyone help me!!!
I am explaining the problem, I am trying to write a macro to find the
value A, corresponding to maximum value of D of a range of A values
(say A=6 to 10.5),
A B C D
0 0 0 0
4 0.010792285 150.3484068 2.58938E-06
5 0.009873071 24.47563184 1.24368E-05
6 0.019727386 345.1068965 4.80516E-05
6.5 0.041660798 242.8148119 7.26371E-05
7 0.09908156 193.5461266 0.000116676
7.5 0.124952681 167.7272614 0.000215809
8 0.10273104 135.9831675 0.000300097
8.5 0.081458799 76.67124238 0.000305775
9 0.132468668 18.87816881 0.000246303
9.5 0.227877539 353.0003297 0.000175705
10 0.333064374 339.2699452 0.000178194
10.5 0.43478522 330.3798441 0.000252355
11 0.526932227 323.9273295 0.000324887
11.5 0.607145865 318.885661 0.000370728
12 0.675315927 314.7447969 0.000390683
12.5 0.732447812 311.227155 0.000392778
13 0.779975241 308.1682968 0.000383911
13.5 0.819406661 305.468458 0.000368906
14 0.852094769 303.0589086 0.000350575
14.5 0.879207908 300.8935055 0.000331675
15 0.90175447 298.9374976 0.000312242
15.5 0.920536129 297.161394 0.000294002
16 0.936208927 295.5444679 0.000276399
16.5 0.949317073 294.0664348 0.000260046
17 0.960293536 292.7136982 0.00024447
17.5 0.969508729 291.470526 0.000231317
18 0.977247323 290.3262732 0.000218649

Thank you

 
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
Filtering data S. Kissing Excel Worksheet Functions 3 March 2nd 07 11:37 PM
2nd Axes - primary series data of only 1 series disappears! cheriw Charts and Charting in Excel 1 February 23rd 06 12:32 AM
how do I plot a data series against two series Frustrated in Sydney Charts and Charting in Excel 7 February 16th 06 04:24 AM
Displaying single and multiple data series.Single data series Donald Macleod Charts and Charting in Excel 2 January 30th 06 02:52 AM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM


All times are GMT +1. The time now is 04:01 AM.

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"