Question re. Excel Magic Trick #213

[PaulRi]

Hello,

I am constructing a make-shift database in excel but can't seem to find a way to get magic trick #213 to work.

What I am trying to do is create a dynamic filter via 16 criteria. I would like any results that match all criteria that I specify and then displays results in a separate table to the right.

Thank you so much for your help - I would attach my spreadsheet to this message if I knew how.

BR,

PR

 

[Smitty]

Welcome to the Board!

If you follow the link in my sig to the HTML Maker, you'll be able to post a shot of your sheet.

 

[PaulRi]

I posed it to my album, here:

http://cid-9bed61f45e5cb3d5.photos.live.com/self.aspx/New%20album/Spreadsheet%20Screen.JPG

 

[PaulRi]

Latest Development:

I managed to get the spreadsheet to work almost entirely.

When I attempt to do a search for "Test", it highlights the matching criteria and appends it to the dynamic list to the right.

However, when I attempt to do a search for "Overview", it highlights the matching criteria but it does NOT append it to the dynamic list to the right.

This is apparent here:

http://cid-9bed61f45e5cb3d5.photos.live.com/self.aspx/New%20album/Test%20Works.JPG

and

http://cid-9bed61f45e5cb3d5.photos.live.com/self.aspx/New%20album/Overview%20Doesn%5E4t.JPG


Any help would be greatly appreciated!

PR

 

[DrExel]

When entering search fields with text you must copy exactly the text plus any blank spaces which may be in your data fields (you may not realize they are there!) If you find some search strings don't work or match when you think they should, try checking the syntax in this manner to verify any spaces. Copy your data field you want to match directly into the search string instead of typing it in. If this still does not work copy your test data field into a Word document and then highlight it as if you are about to copy it. This will highlight(in dark) the whole syntax string including any spaces you may not realize were there. Place your cursor at the far right of the black highlighted area. Now backspace and count back the number of character spaces from the right back to where the text word ends. If it is say 8 spaces, make sure when you create your search string add these 8 spaces to the search string to exactly match. This should then match and enable troubled search or match formulas cells. Hope this helps anyone, it worked for me fixing many cells which were not matching properly.