LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default cell link from the filtered data

hello there,
I have this data:
column A
xxxx
xxxx
zzzz
zzzz
zzzz
xxxx
yyyy
when I filtered it & choose the xxxx, the data shows this:
xxxx
xxxx
xxxx

Now, my problem is, i want to make a formula which can give a result from
the filtered data. In this case the result should be xxxx.

can somebody help me with this.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How 2 Link DATA instead of CELL REFERENCE - Pulling My Hair Out! NineuhtOK New Users to Excel 6 June 8th 07 10:44 PM
how do i copy data from the top cell of a filtered list to anothe. Brian Excel Worksheet Functions 1 December 14th 06 11:03 PM
Use filename in cell to link data HughT Excel Worksheet Functions 2 August 15th 06 07:41 AM
link dynamic data to cell? [email protected] Excel Discussion (Misc queries) 0 June 27th 06 02:36 AM
How do I link data from a cell on one spread sheet to another? Richard Deldonna Excel Worksheet Functions 4 March 18th 06 03:28 PM


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"