+ Reply to Thread
Results 1 to 2 of 2

Return a number in sequence

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Return a number in sequence

    Good evening as an example of the attached file I would need to return to sheet2
    starting from cell F3 the number located on sheet1 in line from C7: AR7.
    When changing the number go to G3 then in H3 etc..etc.
    To compare even though column A is of the same Dip.
    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: Return a number in sequence

    Good evening I solved this matrix formula
    to confirm with contrl + maisc + enter

    Please Login or Register  to view this content.

+ 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] If number is missing in a sequence, highlight and show number
    By pkool in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-11-2017, 01:22 AM
  2. [SOLVED] Count the number of occurrence upto now and assign a unique sequence number
    By chathuranga in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-22-2016, 07:25 AM
  3. Replies: 7
    Last Post: 06-08-2015, 08:39 AM
  4. Replies: 6
    Last Post: 11-26-2013, 05:21 PM
  5. Replies: 5
    Last Post: 11-22-2010, 06:31 PM
  6. How can I match a random number with closest number from sequence?
    By matt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2006, 08:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1