I would like to allow users to change a cell value as long as it is a whole number between 0 and xxx,xxx. I can do this with Data Validation. However, I...

I need help with the error I am getting. I have 2 spreadhseets and need the dashbaord to pull from the data sheet using an HLookup. What I am using now is...

I have data in columns as follows: Start date | End date | April | May | June What I am trying to get is how many days are in each of the column months....

write number 96 and want excell to type in the written number ninety-six. is there a way to do this

I could not find help on this one. I have the spreadsheet below that I want to do this: Count the number of times that an SC1 has Rev between 250 and 550....

Hi I'm using ms excel 2002 version 10.68. I would like to use the option "create list" from Data List Creat List..Unfortunately i can't see that on my...

Ok so here's another one. I have 3 cells that I'm concerned with: ET (Q2), Used (R2), Balance (S2) If it's the begining of the month ET is filled with a...

Jimminy Cricket!!!!!!!!!!!!!1 there's got to be a way to format one worksheet and have that same format be reflected in additional worksheets as they are...

I'd like to use COUNT IF with OR. My criteria a A2:A300 OR B2:B30=2 I found plenty of posts on how to do COUNTIF where two criteria must both be true...

Ok... heres what I need: column A1 contains the date the letter was sent column A4 contains the date we received a response I need column A3 to automatically...

I have a workbood template for accounting purposes that has thousands of formulas that reference another workbook in another file. I also need several...

I am trying to find the MIN price for rows that have a volume attached. So in the example below I want the result to equal $8.25. The formula I'm using is...

I have a large spreadsheet and want to see the numbers in thousands. Is there a way to highlight all the cells and divide them all by 1000 without going...

I have a worksheet where using a table and vlookup, I enter a student's ID number, and get their name. Then, using a nested IF statement I convert their...

I am working on a project for school and I was wondering if I could get some help. I have a list of part numbers in column A and columns B-Q contain...

I need to convert a spreadsheet from Excel 2007 Compatibility Mode, to Excel 2007. I did a file save as, but I only got the 65,536 lines like I had in 2003....

Normally I know how to paste a link to a spredsheet into a cell in another spreadsheet - however I want to not only paste a link but I need to have the...

I have a project in Excel that has 28 worksheets. I want to be able to lock the first worksheet so it stays where it is and I can see the tab while I am...

Can you use the match function or any combination of any function to find in intersecting cell's value by matching to arrays of row values or matching to a...

Col C = Text and Col F = dates I would like to count the # of times a value occurs in Col C based on a date range in Col F. Does anybody have an answer to...