i have a drop down box with 3 items say A,B,C then i need the following to operate from that single dropdown box as follows: (if A4=A then A6=D9,B6=D10,C6=D11)...

I know how to use countif in a range but what if I want to add text in a big spreadsheet when the text is not in a range so I can total how many supervisors...

I'm wanting to build an if then statement, and if the value returns true then return one numeric value, and if it returns false it returns another numeric...

I have 3 worksheets, where on one I enter data (numbers), on the second I would average those numbers with the exact formula =AVERAGE('1'!F:F). Now on this...

Good day. I am using Excel 2002 on Windows XP Pro. I have a worksheet that I have added a Command Button to. I have printed out the instructions...

Time Result 0 0 5 300 10 52000 30 100 So that when the "result" is at a max, the coressponding time is...

How do I calculate elapsed time and return the number of hours expressed in hours and tenths of an hour. For example 8:00 AM to 10:15 AM is 2.3 elapsed hours.

I order from overseas and I need to consider the lead time, transit time with the inventory I have at the end of each month. For instance I will 57 days of...

I have 12 men covering 8 routes, they work 4 days on and 2 days off so on any one day 4 drivers are on a rest day. I change the route drivers cover each week....

is it possible to create a pull down menu in excel? And if so, how do I do it? Thanks!

Hello, I have exported a document to excel and one of my rows have descriptions in it. When I exported it over it brought over all these return marks and...

I have several columns in a spreadsheet and the spreadsheet ahs to be Group by One column and Sort by Another one. I can use Data Sort option and sort the...

Good day. I am using Excel 2002 and Windows XP Pro. I have a worksheet that controls my product pricing. The data input to this worksheet is an export from...

I have set up a customized date format in Excel that works with a txt file. However, if the date is only the year, i.e. 1955, without a day or month, it is...

I have 18 employees, which each have monthly 12 files for timecards. Each file is identical in it's format. The difference is each file then has...

i'm trying to input VAT info into a spreadsheet but my totals at the bottom of the columns aren't adding up, am i doing something wrong? Total invoice amount...

I am trying to make a database type spreadsheet on excel. I have 5 cells which are search fields. when i type in a number or word in one or more of these...

Need help on this problem: SM(A) PROD (B) REV (C) MAT PSP1004K 2395 MAT PSPWIPEOUT 499 MAT PSPLUMINES 399 MAT PCLDVD25MINUS ...

I have would like to create an invoice template in excel and each time I use the template to create an invoice have a number assigned to the new invoice...

Can the IF Logical formula be used with an argument that asks if a number falls in a rang between 2 numbers. I am trying to create an A/R Aging worksheet. I...