Results 1 to 8 of 8

Finding Match in actual position.

Threaded View

  1. #1
    Registered User
    Join Date
    07-23-2007
    Posts
    34

    Finding Match in actual position.

    When we use Match function it returns the relative position of an item. And if we have same items in a data sheet the result mentioned first cell position repeatedly. My problem is,

    "Is it possible to get exact position of different cells?" For example, when 200 is mentioned in F2,F4,F5,F6 and F7 and we match 200 of E3 with this function [=Match(F2,E:E,0), the result returns 3, #N/A,3,3,3,3. But I want to get matching result in actual position like, 2,4,5,6,7.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding actual start of shift for employees
    By notsamsnead in forum Excel General
    Replies: 3
    Last Post: 05-20-2014, 09:08 AM
  2. Replies: 5
    Last Post: 12-21-2010, 10:25 AM
  3. How to make formula to calculate position per Schedule and actual time
    By wcedeno in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2010, 12:03 PM
  4. finding position of number in text
    By momo123 in forum Excel General
    Replies: 9
    Last Post: 08-07-2009, 07:35 AM
  5. Finding the position of a value in an array
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2009, 06:06 AM
  6. Finding the position of a value in a matrix
    By jamesryan in forum Excel General
    Replies: 2
    Last Post: 04-27-2009, 02:47 PM
  7. Finding Column Position
    By Brian Mann in forum Excel General
    Replies: 1
    Last Post: 09-22-2005, 04:26 AM

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