Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search bleed next cell
If I have data "123, 45" (ie, 123 in cell a1 and 45 in b1
How can I search for "123 45"? - = - Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist http://www.facebook.com/vasjpan2 ---{Nothing herein constitutes advice. Everything fully disclaimed.}--- [Homeland Security means private firearms not lazy obstructive guards] [Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos] |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search bleed next cell
I'd add headers to the data in row 1.
Then I'd filter the range (data|filter|autofilter in xl2003 menus). Then I'd filter column A to show the 123's and filter column B to show the 45's. Data|Filter|show all will show all the data quickly. wrote: If I have data "123, 45" (ie, 123 in cell a1 and 45 in b1 How can I search for "123 45"? - = - Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist http://www.facebook.com/vasjpan2 ---{Nothing herein constitutes advice. Everything fully disclaimed.}--- [Homeland Security means private firearms not lazy obstructive guards] [Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos] -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search bleed next cell
Clarification please... do you mean you want to find (select?) the range
A1:B1 because it has "123" and "45" in them respectively OR did you mean you want to find (select?) other ColumnA/ColumnB combinations that have the contents of A1 and B1 in them respectively (for which your 123 and 45 are just example cell values)? Also, is a VB solution acceptable? And do you mean select when you say "find"? -- Rick (MVP - Excel) wrote in message ... If I have data "123, 45" (ie, 123 in cell a1 and 45 in b1 How can I search for "123 45"? - = - Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist http://www.facebook.com/vasjpan2 ---{Nothing herein constitutes advice. Everything fully disclaimed.}--- [Homeland Security means private firearms not lazy obstructive guards] [Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos] |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search bleed next cell
First, thanks.
Someone claimed the searched (CTL-F or EDITFIND) for two adjacent fields (eg col 2= "23-45" and col 3 = "56 street", ie, house number and building number by entering "23-45 56 street" in the search box. It never worked for me and I was wondering how they did it. - = - Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist http://www.facebook.com/vasjpan2 ---{Nothing herein constitutes advice. Everything fully disclaimed.}--- [Homeland Security means private firearms not lazy obstructive guards] [Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing full bleed (ie. no print margins) | Excel Discussion (Misc queries) | |||
copy a cell value based on search of another cell | Excel Worksheet Functions | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
Cell Formats "Bleed" down Columns | Excel Discussion (Misc queries) | |||
format cell to search text in another cell | Excel Discussion (Misc queries) |