Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have an advanced filter set up to match on the contents of 4 columns, using the criteria =("=" & text) . It works fine, except on one column the text is quite long, and the match only seems to work on part of the text. So I get matches where the the first part of the text matches, but the end of the text is different. How can I set up the criteria to get an exact match on the text regardless of length? Thanks.. -- In the nation of the blind, the one eyed man is king.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text is not showing up in cell. Why not? | Excel Discussion (Misc queries) | |||
Text in cell as Formula | Excel Discussion (Misc queries) | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions |