I am trying to setup an Excel spreadsheet with Column A containing several items. Column B has a list of each cost for Column A. If I were to sell the item in...

Very simple question..... Is there is any way to get the same result in Excel WorkSheet (under Cell) as of PrintDate in "MS WordInsertFieldDate and...

I am looking for a way to be able to group data on subsequent rows together and then sort those groups into a list. My data looks something like...

I need a formula (or other solution) that will pick out certain data in a data set that is a particular value, and then calculate the median, 90th and 10th...

I have a column filled with 6 digit numbers and wanted to only show numbers that ended in equal to or greater than 91 and less than or equal to 95 (ie. *91,...

I am using a formula to gather info from 4 worksheets in a separate workbook but same folder and am getting an error of formula too long. Can anyone help with...

Hi I have 2 basic questions 1. I have an Excel file with a Form I created in VB. How do I get this from to load automatically when the Speadsheet is...

Hey I'm looking for a way to sum rows but ignore the adjacent rows which are hidden. excel is adding the stuff in the unhide rows (which is what i want) but...

I need to move only the color of a cell into another cell.

Hi guys, Assume the table below in cols A to C. I'm looking for a formula which can be placed in the Adj_Prize (col C) to compute the adjusted prizes...

Hi, I would like to find out, does Find (Ctrl + F) works in protected file with formulas? As one of my user tried to use Ctrl + F in her protected file (with...

If in Sheet1 A2 is a negative number put in A2 in Sheet2. If in Sheet1 A2 is a positive number put in A3 in Sheet2. How can I do this with a formula???

Hello Why does IF(logical_test,a1:z1,value_if_false) in one cell use a value in sell z1 and in another cell use a value in cell a1?

I am working in Excel 2003. I have a table of data that has been extracted from a database. It details peoples name / month / basic pay / grade / hours over a...

I am currently working on a template for a coworker that allows them to quickly see which products need to be ordered now, soon, or not in the forseeable...

I want to make a worksheet function that will search for an empty cell and then stick a character in it. "IF" only seems to work with a cell's contents, not...

My IF function is not working when I populate the appropriate cell with speech recognition. Is this a limitation with speech recognition? Is there...

A vlookup is simple in it's capabilities, but I want to get clever. I'm looking up a value from another workbook. Simple enough in itself, but heres the...

I got a new computer and am missing a function I loved on my old one. In Excel, I could highlite a group of numbers with my mouse and the sum of those numbers...

I would like to create an data input form for cash payments journals that will be accessable by everyone in the company, and then have the information in the...