+ Reply to Thread
Results 1 to 3 of 3

Picking a number from an array

  1. #1
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    169

    Picking a number from an array

    Hi ...
    First attempt on this forum.
    Hope it's the right section.

    I have this array of 8 columns and 8 rows down.
    And I have a column with number to look for in the array.
    I have found out how to get the row number of a peculiar number, using the INDEX(MATCH)), but ...
    Some times there is multippel occasion of the same number in the array. If so I want to pick the position of left most of those number, AND if there is, let's say three of them, not report the two earlier reported positions.

    I will return in a few hours with the spreadsheet in question.

    I am self taught when it comes to Excel, but no VBA programmer. Mostly a copy and paste guy.

    In advance, thanks
    Attached Images Attached Images
    Last edited by Tresfjording; 09-02-2015 at 11:26 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,240

    Re: Picking a number from an array

    Please post a file as we can't work with an image and/or are not able to view it

    Click "Go Advanced" than Paper clip icon to Add/ Upload file.

  3. #3
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    169

    Re: Picking a number from an array

    Sorry about that.. Problem no longer valid...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Picking An id number from a page
    By 1967chris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2015, 02:59 AM
  2. [SOLVED] picking one item from an array
    By HarryKlein in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-22-2014, 12:22 AM
  3. Replies: 3
    Last Post: 07-11-2012, 08:21 AM
  4. Listing a number when picking a name
    By rgirardi in forum Excel General
    Replies: 5
    Last Post: 12-16-2011, 10:00 PM
  5. Excel 2007 : V Lookup not picking up 'table array' data
    By Phil_Morgan in forum Excel General
    Replies: 0
    Last Post: 08-22-2011, 05:53 AM
  6. Sum if array picking up wrong values
    By Loisw in forum Excel General
    Replies: 3
    Last Post: 06-28-2010, 10:21 AM
  7. Picking up n:th number from a cell
    By Juhanen II in forum Excel General
    Replies: 2
    Last Post: 06-19-2008, 01:38 PM

Tags for this Thread

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