Hi. I have a column where I have names and surnames. I want to put name in one column and surname in anoter column. In order to do this, I use Text to...

Hello everybody, I need your assistance.... No VBA help please I have columns A,B,C,D,E,F........................AG.... in sheet1. everyday data gets...

I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple...

I would like to create a worksheet in Ecxel 2007 that can be shared as an email with the worksheet as the body of the message. I've been able to do this with...

I have a set of data x, y and want to find regions (or ranges) of "constant" slope and I want the value of the slope and range x of that "constant" slope....

I am wanting to lock cell A1 from being able to be populated if both B1 & C1 are both empty. Is this possible?

Hello all. Thanks for the help in advance. I am trying to use a UNC to pull data from a MS Access database as a external datasource for a pivot table in MS...

Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last...

I have a column with numbers that represent seconds, for example 109. How can I change this number (109) to this format, 0:01:49

Windows XP Pro SP3 Excel 2007 Suppose cells A1:A10 contain integer values. Now suppose cells B1:B10 also contain integer values. I'd like to conditionally...

Hi I would like to calcualte the time over a permitted amount and display it in a cell. Column C is the start time dd/mm/yy hh:mm and Column L is the finish...

the broom icon shows in some instances. what does it mean and how do i remove it?

Tried to find an answer but haven't found one yet. :( I have two sheets. On Sheet 1, I have a Demo Code (1, 2, 3, etc.) in A9:A17 and a total quantity column...

Hi. Similar to a poster earlier today, I'm creating a Pivot Table based on data in an Access database. When I link to my database, in the Select Table...

Hello, I have scoured the newsgroups and searched quite a few posts for what I would like to do. We will use cell R3 as an example. I have Office 2007 and I...

I created a form that allows our CSR reps to enter in a set of fields and based on the sequence of answers, a calculation in excel yields the Lead Level...

I've put an Excel template (.xlt)(Excel 2003 sp3) in a public folder on a server that is running server 2008. I put shortcuts to it on several windows...

Hi, SUMPRODUCT(--(S3:S44="A"),--(E3:M44100),--(E3:M44=200))/SUMPRODUCT(--(S3:S44="A"),--(E3:M44"")) doesn't work unless it is E3:E44 Looking to modify...

I've posted a question that didn't show up in the excel community so I posted it again. Although I did find both when I clicked on my name and recent posts...

Hi, Will I be able to open and use any/all files created using my Office professional XP suite (2002), in a new Mac with the latest version of Office...