Results 1 to 8 of 8

Index / match functions

Threaded View

Helppplease Index / match functions 05-08-2012, 03:29 AM
Andrew-R Re: Index / match functions 05-08-2012, 04:07 AM
Helppplease Re: Index / match functions 05-08-2012, 08:41 PM
Marcol Re: Index / match functions 05-08-2012, 04:11 AM
Helppplease Re: Index / match functions 05-08-2012, 08:45 PM
vlady Re: Index / match functions 05-08-2012, 09:04 PM
Marcol Re: Index / match functions 05-09-2012, 02:10 AM
Helppplease Re: Index / match functions 05-09-2012, 02:35 AM
  1. #7
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Index / match functions

    ... Can i take it a step further to bring back the month the first time A5:G5 is less than 0?
    Try this array formula
    =INDEX(A3:G3,1,MATCH("-*",TEXT(A4:G4,"0"),0))
    Confirm with Ctrl+Shift+Enter not just Enter

    See A7 in this workbook, we seem to be talking about different rows.
    Attached Files Attached Files
    Last edited by Marcol; 05-09-2012 at 02:15 AM. Reason: Added Attachment to clarify rows used.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1