Search results for query: *

Have numbers on sheet 1, column A that I would like to bring over to sheet 2, column A. Easy enough, but I would also like to bring over other date (names,etc.) that corresponds with those numbers from sheet 1, column B, C, D, etc to sheet 2 column B, C, D.

I need a formula that will automatically sort sheet 2, from info entered on sheet 1 column b with numbers and carry over with it column A containing names, to sheet 2. Sheet 2 will automatically sort column b from smallest to largest and carry colume A with names, each time an entry is made to...

I have 100s of iteams enter into excel by date. I am wanting a simple formula to enter to retrieve all entries of data that are specific to a certain day (date). Example: Have 13 entries spreadout through the database with the date of September 18, 2012 (column A), and only want the data pulled...

Attached is a .jpg of what I am needing. Have a large database the track both laptops and worstation computers. We are wanting to look at column E for the type of computer (wks or laptop) and also column I ( year placed into service). The formula would be set to look at a particular year and...

I am dealing with two cells to get a percentage. Either cell can begin with a zero, giving me a #DIV/0 error. Currently, as seen below, cell F6 is set to deal with the #DIV/0 error. How can I set this as both cells F6 and H6 can handle the #DIV/0 error. =IF(F6=0,0,(H6-F6)/ABS(F6)) See...

In the attached photo, am needing a formula that will pick up on a month (Jan) in column B, and pick up on both names (nancy and Lynn) in column D, and then look throughout the spreadsheet E9:X24 and give the total number. The tab for the sheet with the data is called "Production". The formula...

I posted this once before, but really could not figure it out. I have attached a pic to assist you in exactly what I am needing. To simplify this, on the spreadsheet there will be a list of names and their individual weights. This is in the red incircled area and will be hidden from view, once...

Thanks for the input anotherhiggins. Just got home and are looking at it, but to be honest, haven't worked with a VLOOKUP before. Not sure where to start.

We have spread sheet that our pilots use that calculates weight and balance for there medical flights. Am attaching a pic as an example. Have created a dropdown list of personal in column B from column d. Column E contains the current weight of the personel. What I am wanting is when selecting...

Am needing a formula that will show weather one sum (column A)is greater than or less than the other sum (column B)by percentage. This value should show up in column C. I will then use conditional formating to colorize the numbers. A B C 100 50 -50% 100...

=SUMPRODUCT((Production!D9:D28="Nancy")*Production!G9:G28)*5 Am using the formula above and want to extend the search area to another column. Am adding column Z9:Z28 in the following way. =SUMPRODUCT((Production!D9:D28="Nancy")*Production!G9:G28,Z9:Z28)*5 However, the formula does not work...

Thanks, not worried about locking in the date, as once the data is enter, they will not be going back to change anything. With that in mind, I tried both formulas above and both are giving me an error. Is it me or did I miss something. I placed the formula in Column A.

Don't know if this is possble, but here goes. For simplicity sake, I have two columns A and B. Would like to set up column A to automatically enter the current computer system date when it detects that text or numbers are entered into column B. We have folks that enter lots of data and would...

Am wanting to sum a row by looking at certain criteria list in columns A and B. For this example, am looking in row 105,column A for the entry of "12a" and row 105, column B for the entry "Toner". Both criteria MUST exist, and if so, then sum the numbers in column C. Last, I want to subtract...

I have created forms (templates), to be use in word. There can be as many at 2 to 10 pages for each form. Was wanting to know if there is a way to set a form field, whereas you would entered something such as a number into it and it would automatically fill in the same fields on ajoining pages...

We have several laptop computers with windows 98. When looking in windows exployer, the folders and files appear in the long filename format. However, when we load a CD containing a folder and its files onto the laptop, only the newly loaded folder with its files show up with short file names...

We have set up an Access database using Microsoft Frontpage 2002 database Wizard. On the database editor page, every entry is assigned a key number and is placed in chronological order. Is there any way to reverse the order of the key? For example, instead of going 1-10, can we get it to...

In Excel, we have a spreadsheet set up to print. We would like to rotate it 90 degrees. Is this possible to do. We have checked all the print commands. We are printing to a plotter and would like to rotate the document to print lengthwise. Any tips would be greatly appreciated. Thanks.