Ok basically I have a worksheet containing a load of data in a sort of table/list type thing like this:
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.
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. Need some help with Excel
- Cowboy Magician
- Posts: 510
- Joined: 2008.09.23 (13:07)
- NUMA Profile: http://nmaps.net/user/wedgie123
- MBTI Type: ENTJ
- Location: Essex, England
- Retrofuturist
- Posts: 3131
- Joined: 2008.09.19 (06:55)
- MBTI Type: ENTP
- Location: California, USA
- Contact:
[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]


Who is online
Users browsing this forum: No registered users and 13 guests