Results 1 to 3 of 3

Find column number from specific range

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Find column number from specific range

    Hello everyone
    I need to create UDF function to get the column number for specific value
    Suppose that the parameters are : the whole table range and the second parameter is a single cell ..
    Then to search for the value of the single cell in the whole table and get the column number for that value

    For example: I have table of values in F3:N4 and the single cell is F8
    Pointing to the UDF_Name(F8,F3:N4)

    The value in F8 is 3.8 and this value is existing in column H (H3 and H4) ... H3=3.6 & H4=4 so the expected result for 3.8 is 3 which is the third column of the table ...
    3.8 >> 3
    5.3 >> 5
    14 >> 9

    Hope it is clear
    NB: I don't need any other solution except UDF .. No code * no formulas * no array formulas
    Just UDF ....

    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find next empty cell (Row)within a specific range in column A
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2014, 05:39 AM
  2. [SOLVED] Find specific values and multiply them by a number in their column
    By Thomas92W in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-29-2014, 01:22 PM
  3. How to autosum numerous data in a column and find a specific number.
    By ExcelQuestionHelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2013, 12:42 PM
  4. Replies: 4
    Last Post: 05-26-2013, 05:54 PM
  5. [SOLVED] Find specific cell and return column number from a dynamic range
    By nivoe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2012, 12:39 PM
  6. Find column number that has a specific value
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2011, 05:32 PM
  7. how do I find an average number of specific words in a column
    By cashgrfx in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 01-06-2005, 01:06 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