When I copy and paste between cells many times, the clip board will automatically show up on the right, which is very annoying. Does anyone have any...

I am trying to read data based on the date criteria so that I can collate data as it is entered. Can I add TODAY() within a SUMIF formula if so how?

I got text in a1 like "Hydro carbon resin Petrolac 120" and in b1 like "Petrolac 120". Now I need in c1 as "Hydro carbon resin". A formula needed to extract...

pls help me out i have the data as below START DT(A1), END DT(B1), QUARTERLY COMMISSION DT. (C1, D1.....) A1 B1 C1 ...

I need to change the fill color based on the values of other cells. Ex. if A1 is not a null value and the cell I want to format A2 is a null then I need A2 to...

Hi - I have not yet found this on the web, wonder if someone else might have some insight. I am particularly interested in the percentages (better yet,...

I have a spreadsheet where all the fields (except those with numbers) have a ' before the data in the cell. The ' does not show up in the cell, but only in...

How can you get the dollar amounts including comma to transfer from Excel 2007 to a word document for mail merge?

I have a disk full of Excel files; I suspect they were created by exporting from an accounting program to Excel to share the financial information with...

Sometimes when I copy and paste in Excel I get the PDF icon instead of the data. Why?

Hello!! I want to sumproduct for 2 vert. array (A1:A15 & B1:B15) but with a slight modification. While doing the sumproduct, i want the a const value say...

In Excel 2003 I was wondering if it is possible to copy multiple cells A1:O75 in multiple worksheets (sheet1, sheet2, sheet3, etc) and pasting them...

When sorting a spreadsheet with rows of varying row heights, the row height setting does not move with the respective row resulting in not all data in cells...

I have an area in the middle of a form template I am making, from line 6 to 26, cells C D E F G (cells are merged and centered on each line) that I am trying...

I want to merge the text from about 25 columns into one column. It is a course list so each registrant has a different combination of courses. Is there a...

I'm currently using the below array equation to count records on one sheet that match certain criteria on another sheet: {=COUNT(MATCH(Tickets!G:G,...

Hello--I'm in a frustrating situation. Recently, we upgraded to Excel 2007 from 2003. First of all, I CANNOT FIND THE "HELP" FUNCTION in 2007, no matter...

I am dealing with a lot of data and I ma trying to highlight the row of the cell I am currently working on. Any suggestions that Excel 2007 can perform with...

I'm trying to randomly assign a number between 1 and 9004 for a mailing list in Excel. What I plan to do, is then sort cases from smallest number (1) to...