in the worksheet, a1 to a10 have numbers. I want to calculate to average value for two value. i.e. average(a1:a2), average(a3:a4),......average(a9:a10) (no....

need your urgent help I have a list a numbers as followings with extra bank spacing at the end of the numbers, please advice me how to set a formula to...

I have 500 email addresses in column D and 13,000 in column A. Now i want to delete all of the column A except the ones which are also in column D. in other...

Hi, Please can you let me know why this formula...

I have some fairly large reports that utilize the SUMPRODUCT functions. Daily I have to clear the unlerying data tables and repopulate with current data. I...

Hello, It would seem what I was looking for all this time was called an accumulator. Is there some way to alter the code below to link up to a page in...

Hi help please, =OR(F3="Schedule booked",AND("D3C3")) I am trying to write if field F3 quotes "Schedule booked" And the amount (field d3) is less than...

I am having a problem error proofing this formula. The formula as listed successfully takes a heading and concatenates some text onto it and then goes into...

Data looks like: Row Column A 1 Legal,Sales 2 Financial,Legal,Sales 3 Financial,Legal,Sales 4 Financial 5 6 ...

I have not been able to get text to speech to work in Excel that has Windows XP. I haven't used this function in quite some time and I don't know if it is...

Hi! I'm a teacher and we are scheduling students. Each student is assigned for classes. We are trying to find a way for Excel to count the number of times...

Is there a way to format specific text in a formula line. For example, can I make the 1 superscript in the following formula line. ="The current tax rate1 is...

Excel 2007, HP PC. I have a long array of data, with a varying number of entries per each individual on whom training data is kept, based on what events...

Hi all, I am trying to keep track of various types of tomato seedlings on growing trays. Each tray is divided into eight sections and each section will have...

How can I try to do an average requiring multiple criteria? For example, I want to do it by Employee Name and Date Range. So if cells A1:A100 is the Name,...

Hi, How to make + symbol variable in the below formula? This formula is in G25 and symbol is in F25 =(NOW()-E$592)+E614

I have a pivot table that is updated daily, but for reporting purposes, I only want to include the last 14 days in my report . I see date filters for this...

i have 1 worksheet with 2 columns....i need to know the names that show in both columns. i know there is a =countif formula but i cant find it anywhere. thx...

Hi, How do I take 3 lists with similar but not exact information and also compare and consolidate those lists into one list. For example: A B ...

I am trying to copy a long "=IF" formula down a row by dragging it. The "=IF" formula is linked to another worksheet, and I am trying to increase the...