+ Reply to Thread
Results 1 to 3 of 3

Find column number from specific range

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

    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

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Find column number from specific range

    Something like this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: Find column number from specific range

    Thank you very very much for this great and speedy reply
    It is working very well and as expected .. simple and effective
    Best Regards

+ 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] 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