Need to sort tire sizes, need to sort by rim size and width.

Is it possible to sort by the reverse of a number? I need to sort a column of tire sizes but I want to group them by rim size.

I need:

215/45R17
225/45R17
225/50R17
215/40R18
215/45R18
215/55R18
225/40R18
225/45R18
245/45R19

Is this possible?

Hi, welcome to the forum

Probably the easiest way for this would be to use helper columns.

Copy the entire range to the column next to it, select Data/Text2Columns/fixed width, then sort the entire range based on that

Hi, welcome to the forum

Probably the easiest way for this would be to use helper columns.

Copy the entire range to the column next to it, select Data/Text2Columns/fixed width, then sort the entire range based on that

This is the closest I can get and that still requires two columns. This solution can however be improved upon by the right people...

Wow, I love the second column that automatically rearranges the number, but I'm lost at the third and fourth column. It looks great as far as the tires being correctly sorted in the fourth column, but I tried to copy down the formula and it didn't work. I entered '275/35R20' into column A, column B correctly rearranged the number but I got #NUM! errors in column C and D.

I am probably doing something wrong, I am used to working with very simple formulas in Excel. The sheet you provided is a work of art.

I used T2C and got the same results lol...

	F	G	H	I	J	K
1	Tire data	1	2	3	4	5
2	215/45R17	215	/	45	R	17
3	225/45R17	225	/	45	R	17
4	225/50R17	225	/	50	R	17
5	215/40R18	215	/	40	R	18
6	225/40R18	225	/	40	R	18
7	215/45R18	215	/	45	R	18
8	225/45R18	225	/	45	R	18
9	215/55R18	215	/	55	R	18
10	245/45R19	245	/	45	R	19

Sorted by 5, 3, 1

Enter this formula in I2 and fill down. I also deleted the empty rows at the bottom and created a table out of the data so that you can sort on any of the columns.

Formula:

Please Login or Register  to view this content.

OK, I may be asking for too much now, but is it possible to create a box on the side where inputting a tire size returns the dimensions that pertain to it? I can use ctrl+F just fine, but looking for a way to make this simple for someone else to use.

I was thinking of creating a spot either on top, beside, or maybe a new sheet. A blank box where if I input a tire size (225/40R18) the weight, dimensions, and dimensional weight appear next to it. I suppose dimensional weight is not important since it is pulled from the actual dimensions.

EDIT:

I have two sheets full of inventory that I am formatting so I can upload them onto my site. I am creating this chart so that I can find dimensions for each size and copy/paste them beside the sizes, but I just thought of something. I am thinking it may be possible to use a VLOOKUP formula that I can paste into a column within my inventory list so that it automatically pulls the dimensions for each tire listing by using the data within this sheet. Please tell me this is possible this would save me so much time.

EDIT2:

I have marked this as solved since my original question has been answered. Again, I greatly appreciate the help I received and am impressed with the quality and quickness. I will finish filling out my sheet with data for all the tire sizes and will post my VLOOKUP question once it has been completed.

I'm not sure that I understand. If you are wanting to add your additional data to the table, just copy and paste the correct values directly under the table. The table will expand to accept the new data and any formulae that are in the present table will be automatically copied down the length of the expanded table.

Maybe this is what you are after: (formula entered in K12 and filled across)

	K	L	M	N	O	P
10	195/70R14	=VLOOKUP($K$10,$B$2:$H$144,COLUMNS($A$1:B1),0)
11	Weight	Length	Width	Height	xx	Dimensional Weight
12	17	25	25	8	0	31

Sorry, stumbled on this and had to correct it. My old solution was too mad, must have been really tired. Maybe someone will stumble on this in the future and make use of it. Sorting tire sizes.