+ Reply to Thread
Results 1 to 4 of 4

Get filtered value in specifc cell

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

    Get filtered value in specifc cell

    Hello everyone
    I have data in range("A8:N200") with headers in row 8 ..
    I would filter data according to field N ...
    To get filtered value in cell B5 I used this array formula
    Please Login or Register  to view this content.
    I need to convert it to UDF function so as to add a point
    The point I need to add is that to return empty if filtered mode=false ..
    Hope it is clear
    Thanks advanced for help
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

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

    Re: Get filtered value in specifc cell

    I found this udf but it doesn't update after filtering data
    Please Login or Register  to view this content.

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

    Re: Get filtered value in specifc cell

    Any idea about this topic?

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

    Re: Get filtered value in specifc cell

    Is it impossible? or the thread is not clear?

+ 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. Returning SQL results into a specifc cell using VBA
    By meadsie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2015, 05:35 AM
  2. [SOLVED] Add/ Remove a specifc text string to a cell based on a checkbox
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2014, 03:24 PM
  3. Replies: 3
    Last Post: 12-18-2012, 07:19 PM
  4. formula to autopopulate a cell with specifc data from another
    By boltoncalling in forum Excel General
    Replies: 5
    Last Post: 01-11-2012, 12:55 PM
  5. Retrieving specifc cell value for loop
    By dpatel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2011, 06:11 AM
  6. Highlighting a Specifc Cell
    By supernova5271 in forum Excel General
    Replies: 1
    Last Post: 10-01-2008, 07:55 PM
  7. ???Refer to a specifc cell in a named range
    By Jaylin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2006, 07:50 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