3/4

Hello guys, I have a small project running and I have faced a few issues. Firstly, take a look at the first picture. It's MS word and the data are copied (and pasted as unformatted text) from a website. The data are tab separated therefore it's easy to copy them to Excel and continue with...

Hi all! I would like to sort by size but its size x size like the fallowing ( I already tried creating a custom sort list but that has a max 255 characters) Any ideas how this can be done? 1/4" 1/4" x 3/8" 1/4" x 3/4" 1/4" x 1" 1/4" x 1-1/4" 1/4" x 1-1/2" 1/4" x 2" 5/16" 5/16" x 1-1/4" 3/8"...

Not sure if this is doable or not...but figured this would be the place to find out. I make boxes out of plywood for storing various materials, kids sports stuff, tools, etc. I'd like to have a spreadsheet that I could enter in the thickness of the material and finished dimensions of the box...

I am using text to columns to modify the following data: <colgroup><col></colgroup><tbody> 1-1/8 61X145 PB 1-1/8 61X121 PB 3/4 49X97 PB 3/4 49X97 PB 3/4 49X97 PB 5/8 49X97 PB 5/8 49X97 PB 1 49X97 PB 1 49X97 PB 1/2 49X97 PB 1/2 49X97 PB I want to see this...

I have a summary spreadsheet that pulls data from other spreadsheets within the workbook. How do I get it to sum the current column and place the sum formula, then look at the spreadsheet that I pulled the data from and get that column total and place that formula total below the previous then...

<colgroup><col><col></colgroup><tbody> Col 1 Col 2 7/8 5/8 7/8x 5/8 7/8 5/8 x 7/8 7/8 7/8 x 3/4 3/4 3/4 3/4 3/4 3/4 x 7/8 7/8 </tbody> Hi everyone, I need a helping hand. In my excel sheet, in col1 whenever value changes, i require a expression as shown in col 2...

<o:p>I need a macro that will look down column F and look for the criteria below and then look at column M and put a different color for each pay class that meets the criteria. Please use a different color foreach Pay Class in the total column:<o:p></o:p> Part Time- anything over 23.99...

Hi guys, I have Peer Group values e.g. 1,4,8,10. I would like all non peer groups records to be ranked by the scale above, e.g. 0.5 to have a rank 1, 9 to have a rank 4 etc. Rank 8 can have rank 3/4, for this purpose it's not crucial. Is there a neat way of doing this?

Hi, I have a program that generates a cut list of materials depending on size and type of unit. Now the guys just take the files and manually aggregate it. I would like to do this programatically. I want to sum the quantity where the width, length, thick, and Matl. match. Red totals 20 parts...