I need help on how to average more than 30 numbers in a single column when the numbers are not in contiguous rows. Excel tells me I can only have 1 to 30...

how do i compare a Cell A1 in Worksheet 1 to the whole Column B in Worksheet 2 to see if part of any of the contents in Cell A are anywhere in the list...

I am in need of some help. I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know basics so I am running up into a problem once I pass 7...

I'm working with a spreadsheet that has automatic calculation disabled because a large number of UDF database lookups refer to one cell and recalculating the...

I have several columns of data. Column A is names, column B is hours, column C is dates. I'm looking for a formula that returns the date when the sum of...

Hi, I have a list of names and a list of names with a list of values and I'm using Sumproduct to compare the two and give the sum of the values for each...

I have a program that exports data to excel arranged like the following: Property 1 Property 2 ...

Is there a function that returns the range covered by merged cells? For example, if A1 through A5 are merged, what function would return A1:A5 if one of the...

I want to calculate the monthly mortgage payment in my spreadsheet. The interest rate is fixed Cell values: A4 = principle A5 = interest rate A6 = years of...

If I have a starting cell equal to say: 8/1/2004 I would like each cell under that one to show the 1st of the next month. If I change the starting cell, the...

I have a cell that equals the remaining number of hours of vacation pay. I would like to have a cell next to that that would indicate how many work days are...

I have four feilds, First, Middle, Last and Email. I want to use a concatenation function in Email to combine First middle and last and automatically add the...

I have a spreadsheet and I need to use a VLookup that then sums the returned values that repeat. Below is an example, where Ashish shows up 3 times in...

I have a spreadsheet. When I enter in a date in the "Date Reply Sent" column, the issue is now closed. I would like that row to line out. Is there a way to...

I am creating a form and certain fields are required. Can I force the user to input some value before they can save? Thanks! ~C

I would like an Excel cell to automaticlly populate a cell with the computer user's name. Is this possible? Thanks! ~C

A client emails me a worksheet with to indicate which duplicate records need to be deleted. The client has multiple locations, so each location fills marks...

I am using Excel 2000. I have a spreadsheet that has some calculations that are simple totaling of columns. Rather than rekey that total on another...

Hi all - I'm not sure if it's an IF statement I need - but if it is then I would like to know how to ignore cells with zero as the number. Let me explain...

I minimize Excel and size it so it uses 1/2 of my monitor window. I open another window in the other half so I can copy data from this to Excel. On...