Search : in
By :

Search excel for grouped cell contents?

Last answer on Oct 9, 2009 6:02:20 pm BST JK, on Sep 28, 2009 6:53:25 pm BST 
 Report this message to moderators

Hello,
I want to be able to search an excel chart looking for "groups of cells" that have the same sequence of contents. For instance cell 1 would have AB, the next cell 2 would have TZ. I want to be able to search the sheet to find all instances where such a pair of cells with these contents might be located.
I tried separating the search data with ^t and^n, but the program seems only able to locate contents of a single cell.
Any ideas? Thanks.

Configuration: Mac OS X
Safari 531.9

Best answers for « Search excel for grouped cell contents? » in :
[Excel]Clear the contents of specific cells. Show [Excel]Clear the contents of specific cells Issue Solution Notes Issue I have 6 cells with dropdowns list and they are selected each time. I wish I could have a reset button for the last entry for 6 cells(to clear them) but of...
Can vba return excel cell value with formats Show
Excel macro to copy cell content highlighted Show
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
Ask your question Reply

1

venkat1926, on Sep 29, 2009 2:19:52 am BST

What is that ^n (^ is wildcard symbold)

"next cell" what is next cells. next to the right, down, left or up.

all information may plese be given

   
Reply to venkat1926

2

JK, on Sep 29, 2009 10:58:52 am BST

If two adjacent cells have a certain pattern of contents, cell 1 has Tz# and the adjacent cell had aK4, and I want to search for all groups of adjacent cells on a work sheet that contain identical matched adjacent contents, is that possible?

Example: Cell 1 Cell 2
Cell Contents: Tz# aK4 Can excel help me find all locations of similar adjacent cells
with identical grouped adjacent contents?

Thanks,

   
Reply to JK

3

venkat1926, on Sep 30, 2009 1:17:19 am BST

Again you have not said what sis meant by adjacent cells to the right or down etc
I assumed it is adjacent cells in the same row.
my sample data is like this from A1 to B7

TZ# ak4
q w
w e
TZ# ak4
r t
t y
TZ# ak4

in C1 type ths formula (or copy paste)

=IF(AND(A1="TZ#",B1="AK4"),1,0)

copy C1 down.

so the values 1 in column C indicate your required rows.

   
Reply to venkat1926

4

jk, on Oct 9, 2009 5:56:56 pm BST

Thanks for the help to Venkat1926. I wasn't being clear and I apologize.

Assume cell S26 has cell contents of [%&]. And the adjacent cell in the row S27 has cell contents of [98*] .

If I want to search the rest of the excel table to find all other adjacent cells that match the same adjacent cell contents of [%&] next to [98*] that I had put in S26 and S27, is there a way to do that?

Sorry for the confusion. Hope this is clearer.

   
Reply to jk

5

 jk, on Oct 9, 2009 6:02:20 pm BST

I SCREWED UP. MESSAGE REVISED:

Thanks for the help to Venkat1926. I wasn't being clear and I apologize.

Assume cell S26 has cell contents of [%&]. And the adjacent cell in the row T26 has cell contents of [98*] .

If I want to search the rest of the excel table to find all other adjacent cells that match the same adjacent cell contents of [%&] next to [98*] that I had put in S26 and T26, is there a way to do that?

Sorry for the confusion. Hope this is clearer.

   
Reply to jk
Ask your question Reply
They need your help