+ Reply to Thread
Results 1 to 8 of 8

Returning first "1"

Hybrid View

martis941 Returning first "1" 02-17-2017, 04:31 PM
TMS Re: Returning first... 02-17-2017, 04:49 PM
TMS Re: Returning first... 02-17-2017, 04:51 PM
Aardigspook Re: Returning first... 02-17-2017, 05:15 PM
TMS Re: Returning first... 02-17-2017, 05:18 PM
Aardigspook Re: Returning first... 02-17-2017, 05:37 PM
AlKey Re: Returning first... 02-17-2017, 06:03 PM
FlameRetired Re: Returning first... 02-17-2017, 06:33 PM
  1. 02-17-2017, 05:18 PM #1
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,290

    Re: Returning first "1"

    Guessing that should be
    Formula: copy to clipboard 
    =INDEX($A$1:$A$10,MATCH(2012+ROW($A1)&1,$B$1:$B$10&$C$1:$C$10,0),1)
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  2. 02-17-2017, 05:37 PM #2
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Returning first "1"

    Quote Originally Posted by TMS View Post
    Guessing that should be...
    Yes, that works too, since the returned value is in the first column - probably simpler to understand too .
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding the largest absolute values but returning the "+" "-" sign
    By amartino44 in forum Excel General
    Replies: 8
    Last Post: 07-12-2017, 05:32 PM
  2. Returning "yes" or "no" if a value is found in an entire table (across multiple columns)
    By cora.ts in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2015, 03:44 PM
  3. [SOLVED] How to check two columns for the presence of text and returning "yes" or "no"
    By Karelia Suite in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 09:36 AM
  4. Returning Closest Match between "y" and "z" to "X"
    By promotor in forum Excel General
    Replies: 4
    Last Post: 12-05-2011, 10:34 AM
  5. Formula returning result of "True" or "False" instead of "1" or "0"
    By AllenMead in forum Excel General
    Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. Recogising various products in 1 column + returning "in" or "out" of stock in another
    By Russ3578 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-08-2008, 12:48 PM
  7. if statement see "Male" or "Female" returning "Y" otherwise leave blank
    By qwervbnmasdf in forum Excel General
    Replies: 3
    Last Post: 12-14-2006, 01:36 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1