PC Review


Reply
Thread Tools Rate Thread

I"M STUCK! help please!

 
 
ppaauull@gmail.com
Guest
Posts: n/a
 
      9th Nov 2006
here is what i want to do:

2 columns: A & B

col A: list of months (12): cell A1:jan/06, A2: feb/06, A3: mar/06, A4:
apr/06, A5:...... A12: dec/06
col B: list of sales that correspond to the month (only 4): B1:100,
B2:112, B3:105, B4:112

I want a formula that will tell me the latest month that the sales is
inputed (in this case B4) = apr/06

i've gotten the formula to find the last number of the set: which give
me the number of "112" (i put this formula in D1)

=INDEX(A1:A12,MATCH(9.99999999999999E+307,B1:B12))

or

=LOOKUP(9.99999999999999E+307,B1:B12)


but where i'm stuck at is using index/match, (i put this formula in E1)

=INDEX($A$1:$A$12,MATCH(D1,$B$1:$B$12,0))


and in the example above, it would always return to me (feb/06) as it
is the same sales figure as apr/06, but I want the formula to to tell
me apr/06!

i've also tried changing the match type to '1' and it did do anything.

i feel i'm so close but cn't figure it out!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
My "WebClient" Service is stuck in "Stopping" state Michael Windows XP General 4 28th May 2009 06:25 PM
A "delivery receipt" is stuck and I get "sending" failure messages =?Utf-8?B?Tm90IGEgUmVhbCBHZWVr?= Microsoft Outlook Discussion 1 24th May 2007 03:47 PM
"" Stuck in endless Registration Request Loop at bootup "" Polecat Windows XP Help 6 26th May 2005 08:45 AM
"" Stuck in endless Registration Request Loop at bootup "" Polecat Windows XP Setup 0 23rd May 2005 11:30 PM
Outlook 2003 - When I use "Reply" e-mail stuck in "Outbox." Jeremy Microsoft Outlook 2 9th Apr 2005 09:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:58 PM.