I have a question? When you are making a cell with a formula the references are set. But when you copy the cell each cell reference changes relative to the...

I have a scanner that i can ues in excel. it will place a number into cell A1. What i need it to do is lookup that number and place the description into...

I am trying to set up a way to confirm commission payment on a particular account. I have a spreadsheet with orders that we have placed with the main...

I received a large file with several different sheets. Is there a way to save the one sheet to another file without having to save it and remove all of the...

I have a table with 5 columns and about 30 rows. A containes litres, B kilometres, C average consumption in 100 km, D additive litres and E should have...

What I would like to do is add up hours shown within specific columns or ranges on multiple timesheets. But here's the tricky part, to add up only those...

Hello, A B C 1 Name Address Ph.no 2 xyz xyz 2357226, 3 abc abc ...

I have an issue with sum formulas not updating for new info in the range cells? It looks PC specific, but I don't know how to check the problem. Ant help...

In one section of my form there are 2 columns: A and B. Cell range B1:B7 contains a series of different numerical values associated with the corresponding...

Hi All, E.g. in cell A1, sheet1, I have =sheet2!D12 to reference whatever is in sheet 2, cell D12. I want a formula that looks into A1 to see what is...

hi - I want to report a fixed value of '1' if the term 'defect raised' appears in a range of cells, regardless of frequency. the current formula I have is...

I currently use Office 2003. Is there a format i can set up for cells where i can type in just 4 characters for a time, say 0845 for 8:45 AM without having...

Hi, I have 30,000+ rows of order lines (extract from database). I have a report setup that takes four criteria (retailer chain, order type, product group,...

I got minium order quantity and firm order quantity in a pivottable, and add a calculated formula for order quantity which should be a least multiple of...

I have two spreadsheets with columns of variables. I have a unique identifier variable consistent in the two spreadsheets, but some columns in the second...

Thanks in advance for any help. Here is my challenge. I want to track stats for players on rows. Have a different row for each of the last three seasons...

Hi Group, I am in "Microsoft Excel Data Analysis and Business Modeling." Chapter 42, pg 342-343 and put the R squared value on a chart, which equals .9828....

Ok guys, here's one to work those muscles. So far I have the following...

Is there a way to count cells that have been highlighted similiar to using the COUNTIF but instead of a variable checking for the formatting of a cell?

Hi, I have the following challenge: In my teaching a have to count the number of hours students spend on their extra curricular activities. This is the table...