Is there a way to lock formulas but allow for data to be entered or deleted? I need to create a sales spreadsheet for a client to record their sales and...

hi Can u pls tell me how can i give name to a particular selection. which i can use as a data selection for any required command. -- MIS EXECUTIVE RKHS

I am trying to get a results for a score. for example in cell A, the cell (which is the results) shows as 5; I need cell B to tell me that if the value in...

I need to remove the spacing in between comma and capital L Chan, Lucy-CS Can anyone help me on this Thanks.

article from Gord "Last Line" microsoft.public.excel.worksheet.functions 4/7/09 And from Biff "Need help finding the last cell w/data" 4/6/09 Sorry, I...

In column b there are either a 1 in the cell or a blank. In column A there is either a number or blank cell. Is there a function that will say when there...

Hi there, I have a vertical data array that begins in cell C5 and ends at cell C214. Each pair of consecutive lines contains data applicable to a single...

I have an Excel workbook for scheduling employees in several departments. Each department has their own sheet and their scheduled days/times are linked to a...

Hello i was wondering if anyone can help me. I can't figure out how to make it where when i enter in three numbers it automatically puts a decimal after the...

I'm working on a spreadsheet with all employee names and their annual deductions. I need to send them a letter, addressed to each employee with the specific...

I am building a perpetual workbook where sheet B will reading sheet A via formula. Sheet B is a transposition of sheet A rows to columns, so my many rows of...

I am developing a retirement projection. I need to have the row highlighted if the years of service is greater than 10 (cell D2) and age is greater than 55...

I want to sum the values in column D when the value in column C is blank and the the value in column F is not blank. (I'm using Excel 2003. )

I am currently using a formula to calculate aging between dates. How can I take that calculated column of information and find an average for aging? Thank...

I used the macro below and it works perfectly except when I try to use it for cells that contain formulas. Example: Sub Delete Rows() Dim RowNdx As...

Anyone, Can you make a cell = 0 if original function is creating a"#ref!"? Normally, I can manually change the refs to 0, but for large worksheets, this is...

I am trying to figure out how I can count the number of rows where Columns AC:AM=10 when added together no matter what numbers/integers are in any of those...

Hi, I am trying to look up certain figures in an array and return the values. This sounds like a simple Vlookup or Index and Match but what I'm trying to do is...

My teacher has offered bonus points if we can use the same formula in two different cells to obtain different results. This is for an accounting worksheet...

While I was on vacation someone else used my pc and now Excel no longer opens with a blank workbook. How do I fix this to once again open with a blank...