difficult

Hi All, I have a list of serial numbers that are split into the first half and second half. Eg: First half: 9813/ Seconds Half: 3200 Now I could easily go through these and type the second half on the end to create: 9813/3200. But since there is a list of around 10,000 of these, I'd rather...

Hi All, I have created a vlookup which looks to pull data from a separate file to the one that the lookup is contained within. This file has two categories 'Service Manuals' and 'Operator Manuals'. What I am looking to do is rather than use separate tabs for each one, since the format is all...

the formula am trying to create will be used over and over with different text so I can see an example of one I should be able to fix to work on others I will use condition as my example I will have 4 choices poor, fair, average, good the value will be compared against the subject property...

Hey guys, I'm creating an algorithm for daily fantasy basketball and I have hit a little roadblock. Here is the link to download my spreadsheet: <a href=http://www.filedropper.com/linestsolver><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br...

Hi Community, I am trying to enhance a formula I created, but I am stuck now. Situation: There is an Input sheet "SellerInput" and there is an Output Sheet called "Seller Side" My formula is searching in SellerInput all rows with a specific "Office" and a specific "Range" and pastes...

I need to search down the cars column for separate instances of equal to or greater than 2 that do not occupy the same 60min time frame. As you see below, it would return a no in D2, a Yes in D3 and then must ignore C4, C5 & C6 because they are within 60 minutes of the first instance of 2 cars...

Hi All, I have been putting together a general journal style spreedsheet and I'm not sure if Excel can accommodate for this: I need users to enter values in sheet 1 i.e (A6:R99), then theses values to be automatically be stored in sheet 2 (A6:R99), now here's the issues, from this point the...

I'll start with pictures to better explain what I am trying to accomplish. imgur: the simple image sharer This is a typical chart I work with. imgur: the simple image sharer The Data tab that creates the graph. imgur: the simple image sharer The starting point of data I need. I believe...

Hey! I am a tax accountant trying really hard to impress my manager...long story short one of our big clients give us a very un organized Excel sheet of there trial balance... and I want to find a quick way to organize it...below is an example of what the excel looks like and what I want to...

Here are 4 tables of iterated values for bottom hole pressures in CO2 injection wells. I’d like to be able to input a Surface Pressure (Psurf), TD (total depth), average fluid temperature Tavg, and CO2% and have excel go find the best approximation of the bottom hole pressure from the tables...

Hi, this is James For an IT company I'm working with, I would like to create a monitoring excel sheet for myself with EXCEL 2003 Requirement : Use external data and create alerts I have used web queries (external data) for an INTRAnet website, (only works in the company) to extract data. The...

Hey everyone. I'm currently a student and my studies have nothing to do with excel, but I have am in the middle of an internship where all I do is work with spreadsheets. Currently, I'm working with a paper company in Alabama, where they asked me to create a spreadsheet that measures efficiency...

Hello Everybody I am having quite a problem with a spreadsheet I am working on. I basically need to copy a row, and if the value in cell "V" is greater than 1, then that many rows (as specified in cell "V") need to be inserted below, and the copied row needs to be inserted that many times...

BEEN ON IT FOR 2 DAYS NOW VERY CONFUSED I THINK IT CAN BE DONE BY SUMPRODUCT CANNOT SEEM TO FIGURE IT OUT I AM TRYING TO SUM ALL THE COLUMNS THAT HAVE A TITLE OF "GCE" LOOK ACCROSS THE ROW AND THAT HAVE A DATE BETWEEN 16 JUN 11 AND 20 NOV 12 LOOK DOWN THE COLUMN I PUT THIS AND ITS NOT...

Here is a challenge, that can probably only be solved by an Excel expert. Can this be organized into rows and columns properly? The below data is from 3 SNPs. I have a text document with just over 148,000 of these. I would like the below data to be turned into 3 rows, with as many columns as is...

I have a hard formula that i want to construct in excel and i need help... I have made up an equation in one cell (A1) that is the average of 4 other cells. What I need, is this answer (A1) to then equal a "Pass" in another cell dependng on the if the answer in A1 is between values x (cell B1)...

Hey all, I'm having a little trouble with a Macro at the moment, I need to copy 4 columns on one page, (A, B, C and D) and paste them into another sheet on Columns C, D, E and F. That I have achieved... However, I also need to filter out any row where the value of column A begins with a 6...

I have a formula that works fine in excel 2007, but contains too many levels of nesting to work in 2003. I don’t know if there is a solution or not, but if there is the people here will know it. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p>...

Im trying (for 2 days now) to create a macro to create a set of dynamic named ranges. there are column headers in row 5 and 5 rows below that there is the beginning of my data. Heres where the sticky part comes in: i have another table below my data that references the above table (that is...

Can anyone help I am new to VBA? Below is a basic way to find rows that match 3 criteria, work out the average to each column G to M of all the rows that match the criteria and copy and past to a repot sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...