Hi guys,
I need a macro that finds me the first value and the last value in a number of series.
For instance i have got two numbers: 0.4 and 0.7
Then there is a series of numbers 0.6, 1, 2, 5, 0.5, 0.4, 0, 4, 0.7, 69, 33, 2, 3
I want the macro to tell me that 0.4 comes before 0.7.
any ideas?
Are these in a single row or column? Where did the 0.4 and 0.7 come from?
Can you post your workbook as an example so we can see how its laid out?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
If your data is in A1:M1, try this...
=RANK(0.4,A1:M1)<RANK(0.7,A1:M1)
FALSE indicated 0.4 is before .07.
You could also put the 0.4 and 0.7 in their own cells and reference them
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks