Need some help with Excel

Talk about computers, hardware, applications, and consumer electronics.
User avatar
Cowboy Magician
Posts: 510
Joined: 2008.09.23 (13:07)
NUMA Profile: http://nmaps.net/user/wedgie123
MBTI Type: ENTJ
Location: Essex, England

Postby wedgie » 2009.06.10 (07:30)

Ok basically I have a worksheet containing a load of data in a sort of table/list type thing like this:
untitled.PNG
If I click on the company name tab and go 'text filters>contains', and then type something in, then it will return any records in my table that contain what I've typed.
What I'm trying to do, if possible, is just shorten down this method into a search box of some sort. I just want to be able to type what I want to search for into a box at the head of the table and then have this perform the same sort of lookup filter that the original way did to return the search results.
I've searched around loads trying to find this out, but I just keep finding answers that involve visual basic and all types of coding that I just can't get my head around.
Any help would be greatly appreciated.

User avatar
Retrofuturist
Posts: 3131
Joined: 2008.09.19 (06:55)
MBTI Type: ENTP
Location: California, USA
Contact:

Postby t̷s͢uk̕a͡t͜ư » 2009.06.10 (17:20)

[spoiler="you know i always joked that it would be scary as hell to run into DMX in a dark ally, but secretly when i say 'DMX' i really mean 'Tsukatu'." -kai]"... and when i say 'scary as hell' i really mean 'tight pink shirt'." -kai[/spoiler][/i]
spoiler

Image



Who is online

Users browsing this forum: No registered users and 14 guests