formulas functions

example: HINGE SBR.60X40MM (LEFT) BRASS (column G3) all I need: HINGE 60x40mm brass (column c3) I have been using a formula that has worked for most of my work but I think this one has more characters in the first word. Can someone please help?????

Example: PULL MET.76MM (8/32) BRUSHED NICKEL (column G) All I need is: 76MM to copy to column C Example: PULL MET.224MM (M4) CHROME&BLACK (COLUMN G) All I need is: 224MM Please help.

So, here's my deal. I have two separate sheets, one with parcel ID #'s and corresponding names. In the second sheet, I have only a select group of parcel ID #'s, all of which exist in the first sheet (>10%). What I was wondering is how to get my second sheet, with the smaller list of ID's, to go...

I need to count a list of rank, and using the countifs seemed the proficient way, however I cant get it to work. Here's the formula I currently have, but it keeps returning a zero. I've tried the insert function but to no avail. =COUNTIFS($E:$E,"PVT",$E:$E, "PV2",$E:$E, "PFC",$E:$E...

Hello - I am I have 4 columns of data - 2 sets of first names and 2 sets of last names that I combined from 2 different files. I want to insert an IF statement that tells me of all the first and last names that do not match: ie: <table width="256" border="0" cellpadding="0"...

Hello, I have a spreadsheet which uses 2 different colors to designate how something is mailed. If it is mailed one way, there is a corresponding date in one column and if it is mailed the 2nd way, another date in another column. For example - code 1110 is in cell C1, date1 is in cell A1 and...

Hello Excel Experts,<o:p></o:p> <o:p></o:p>I wanted to have an overview of all projects my team is working on - with a conditional formatting that forms a bar chart. Thing is I want each new project that continues right after the previous project done to come under the same column i/o to...

i have a worksheet with a list of students in the rows in the columns i have a question one for example and their marks, full marks represented by the number of points (5) for example under heading "y" in the next column if they answer wrong (0) under heading "n" and another column for a partial...

Hi I'm using an equation to work out age based upon DOB when case opened. I have three columns Formula, DOB, Date case opened. When either the DOB or date case opened is cut and pasted further down the column, the formula refernce numbers follow the dates. There is no need to cut and...

I am new to both statistical analysis and Microsoft Excel, which I am sure will become apparent from my question. I write for a basketball blog, and I have a question about what type of analysis or formula to use. My idea was to compile a database of statistics for a group of...

I am using this formula in my spreadsheet =IFERROR(SUM(AQ5+AN5-AO5)/AP5,0) , but sometimes I get a negative %. What can I do to have a negative % just show 0%? If I need to post a partion of my spreadsheet I will...thanks in advance. Jonathan

I need help writing a formula for this scenario for Excel 2007: <link rel="File-List" href="file:///C:%5CUsers%5CSam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData"...

Hi, I have been tasked with creating a tool that will randomly select 'x' amount from a list of entries and distribute to 3 named persons over a 5 day week. Basically we have 75 servers that each need to be checked once a week (5 days) by any member of a team of 3. Therefore 15 servers per...

This is my first post, please forgive my limited knowledge. I want to create a formula that: IF(A1+A2)<=0 à enter 0 in B2 IF(A1+A2)>=1 à enter the sum in B2 I tried: =IF((A1+A2)<=0,0,1) (This was as far as I could get with Excel 2007 Help and my limited knowledge) It produces the correct result...

I would like to make a flexible macro that uses the formula in row 3 of a column to calculate the results of row 5 to last (32333 f.e.) This is my code so far: Sub formuletest() Rijen = Range("AS1").Value kolom = Range("AS2").Value formule = Range("AS3").Formula For i = 5 To Rijen T_lu =...

background : workbook with 6 worksheets of input 1 worksheet with proper inputted data summary sheet 1 - summary worksheet cell: A2 drop down menu (different builder) cell: A3 drop down menu (builder specific series) cell: A4 drop down menu (series specific models) _100 series...

:confused:Been pounding my head up against a wall trying to figure out how to do this, and I must tell ya, I am a real idiot when it comes to macros and vba, please if you can help me please put it as simple as you can. Thank you... My situation: I am trying to make it where the other 12 sheets...

I have been working on this for quite a while and am stuck! Col A & Col B is for user entry. Have tried to insert, lookup, IF, match, formulas without any luck. What results I am attempting: In Col A user will type type of equipment, Col B user will type connection size. Building a sheet...

I cannot for the life of me figure out how to format a column full of data so that I can subtotal the column. I'm working with data that we exported from Quickbooks. A client exported list of journal entries which needed so many rows that it took nearly two whole tabs to capture all the data...