Evaluate numbers in a text-number string

[sam887]

Hi there,

I am using Webtrends to identify browser sizes. It provides output in the following form:

Browser Size Visits
1000x800 2000
1024x660 3000
300x400 4000
etc.

I want to easily be able to enter a pixel size (eg, "600") and determine whether the Left number, Right Number, or Either number in the text string in the Browser Size column (left or right of the "x") is greater than the number I enter. If the numbers in the text string are greater than the number I enter, it should display the data in the column to the right (Visits). If not, it should display 0.

For example, if I enter "600", I should see 2000 visits, 3000 visits, and 0 in the third row. Please see attached sheet and let me know if you have any questions. Thanks!

Text-Number Excel File.xlsx

[FDibbins]

Not sure if the last part in these is what you want, so change it as needed.

Left =
=IF($B$2<--LEFT(A8,FIND("x",A8,1)-1),1,0)
Right =
=IF($B$2<--RIGHT(A8,LEN(A8)-FIND("x",A8,1)),1,0)
Both =
=IF(AND($B$2<--LEFT(A8,FIND("x",A8,1)-1),$B$2<--RIGHT(A8,LEN(A8)-FIND("x",A8,1))),1,0)

[AlKey]

in C8

=IF(LEFT(A8,FIND("x",A8)-1)+0>=B$2,1,0)

In D8

=IF(RIGHT(A8,LEN(A8)-FIND("x",A8))+0>=$B$2,1,0)

In E8

=IF(SUM(C8:D8)=2,1,0)

[newdoverman]

This is my interpretation of your problem:

Left:

Please Login or Register  to view this content.

Right:

Please Login or Register  to view this content.

Either side:

Please Login or Register  to view this content.

[sam887]

Brilliant - these all appear to work. I simply had to swap out the Value If True with the cell information I wanted to display. Thanks!

[FDibbins]

Happy to help and thanks for the feedback

[newdoverman]

Thanks for the feedback.

Good luck with the solution of your choice.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.