Looking for a way to filter this - see example

[Buchu]

Hi,

I'm looking for a way to filter two eight digit serial numbers located in one Excel cell. (data was imported to excel from a database)

So the cell could contain two 8 digit numbers, but sometimes will only contain one. I want to filter out any cell with number below a certain value say 25028500. The problem is the two numbers in a single cell. Not sure how to filter for this...

For example:

25028336 25032995 (first number is below 25028500, second is above)
25014962 (below)
25013562 25034339 (first is below, second above)
25029962 25031032 (both above)
25036921 (above)

etc

Thanks in advance!

[TMS]

You could use LEFT and RIGHT to get the numbers and compare each to the number.

For example, =LEFT(A1,8)+0 > 25028500, and, =RIGHT(A1,8)+0 > 25028500

The only complication is if there's only one number. In that case, =IF(LEFT(A1,8)+0 = RIGHT(A1,8)+0, "", RIGHT(A1,8)+0 > 25028500)

[Buchu]

Is there a way for the filter to keep the value of the number rather than a "True" or "False"?

I'm almost there, I used LEFT and RIGHT to get the first and second number (8 digit value) in a new column (Serial 1 and Serial 2), however I have a repeat number if there is only 8 digit number one to begin with. Anyone know a good way to remove the entry in Serial 2 if it is equal to Serial 1? I could manually go back and delete the duplicates, but I'd rather have Excel do the work for me. I used conditional formatting to highlight value > 25028500.

Here is an example of how it looks: Left column is how data is pulled from data base (one or both 8 digit numbers in one column) and the two columns on the right (Serial 1 and Serial 2 respectively) are where I used the LEFT and RIGHT to extract the first and second numbers from the original column.

Attachment 752715

[AliGW]

Attach a workbook, not a picture of one.

Administrative Note

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. Thanks.

[Buchu]

Here is a workbook.

Attachment 752728