Hey Guys,
Firstly, I want to welcome myself to the forum and thank you in advance for all those that read and reply. I am completely new to EXCEL so please bare with me. I would like to know if its possible to sort NUMBERs from lease (1,2,3...) to greater than numbers (...10,11,13) within rows, I know its possible within a COLUMN. My file is attached but let me explain. So I have the following data in an EXCEL sheet as followed:
CELL1- 11,9,7,3,1,22,25,13,9
CELL2- 24,12,9,1,5,3,2,18,25
CELL3- 3,2,9,6,14,19,25,11,12
etc,... Now I want to be able to highlight all CELLS and SORT so it is like this...
CELL1- 1,3,7,9,11,13,22,25
CELL2- 1,2,3,12,18,24,25
CELL3- 2,3,6,9,11,12,19,25
I know how to do it individually (ROW by ROW, but I have over 1,000 rows)
Also guys, is there a formula to find any NUMBERS sequence that was given within the data that repeated, and how many time?
Example: Using the same data
CELL1- 1,3,7,9,11,13,22,25
CELL2- 1,2,3,12,18,24,25
CELL3- 2,3,6,9,11,12,19,25
CELL4- 1,2,3,12,18,24,25
I dont know hot, but the formula will let me know that CELL2 (row) and CELL4 repeated and the numbers are as followed: 1,2,3,12,18,24,25
Hopefully I am making sense. Thanks again Guys!
P.S. I am using EXCEL version 2003.
Bookmarks