I am trying to replace the range in an average calculation using the offset function but its not giving me the result the same as using Excels standard average...

I used this formula to seperate numbers in a string and return the numbers. Example: original string "BD456". the outcome is "456" The formula worked just...

Hi, I am trying to "lookup" values in a secured Access database from Excel using the SQL.REQUEST function. When the database is not secured the function...

Hi Everyone, I have 2 companies parts in a spreadsheet. One set is uppercase and one is lowercase. Example: 10x06-398f 4.54 10X6-398F 6.56 I would like to...

i have made excel worksheet, it consist of 15 pages. i need to total each page add all subtotals to make grandtotal on final page how do i incorporate...

I am attempting to find a value using a series of repeditive formulas. I am getting an #NUM error, which I know is wrong. I am attempting to...

An employee is purchasing vacation per pay. My spreadsheet works like this. Week 1 Withheld $39.00 Week 2 Withheld $39.00 Week 3 ...

Good Day, I would like a popup screen to come up automatically when a spreadsheet is open. This popup will provide directions to the users of the spreadsheet....

Is there a function like lookup that will return a true/false value. if this number on sheet 1 a1 is found anywhere on sheet 2 a1:a10000, return a value of...

I created a multi-page workbook to determine the sales bonus earned by my employees. The problem is that some of them forfeit their bonus if they don't meet...

I need a formula that will allow me to rank one column of numbers based on a value in another column. e.g. If I have values in column A and countries...

I want to disable refresh options while working in PIVOt table since it is disturing my own format while refreshing or adding my data... pl. advise...

I am trying to get text data from one worksheet to copy to another worksheet. For example, in column A in wkst1, I have a list of several customer numbers. In...

I have a formula that is simply adding cells E8:E184. When I insert rows (begining with E185) and populate those rows with data, the formula doesn't pick...

please help, i can find a way to freez the columns without splitting both rows and columns (panes). thank you

I want to be be able to set which worksheet opens when I open a specific workbook.

Hi. Got this formula defined as a name (Cell has formula): =GET.CELL(48;INDIRECT("rc";FALSE)) Used it when I had Excel97 Now I have Excel 2003 and get an...

How do you find 401(k) because I have a question asking, well saying, insert a formula to calculate the 401 (k) contributions for each employee. The formula...

Hi, I don't know if this is an excel issue or a network issue. With many of our excel files that have links to other excel files across a network...

Download An Open Letter From Al-RASHEDEEN Army To The American President click on one from the links below for...