software

I have a spreadsheet thats connected to an Access DB. I have the spreadsheet
set up so one row is white and the next row is a light grey. So basically

I am new to excel and want to find out what function to use.

I have 4 columns of data which I want to add together to make one column of
data. 3 of the columns are text and one is a date.

Whenever I try to export data from access to excel I face a peculiar
problem. If the data has forward slashes in it, it gets converted to date

You'll need to re-create your ranges with Week01, Week02, etc.

I am finding that with the below calculation I am finding that SUMPRODUCT is
obtaining the wrong # of items. I have a column with 12 names that are

how can i set as default my comments to always show 12 font size?

i need a formulae that will make conditional formatting do the following.

I am trying to create a master template in Excel 2003 that collects data that
is entered and saves it to a separate collection file to be used for

I am having all sorts of problems with my spreadsheet. I fixed some but I
think the problem lies within the Rand() function.

I have calculations that I did in an Excel 2000 worksheet. When I open the
sheet in Excel 2003, the calculations don't update. I have them set to

Is there a way to configure Excel so that it doesn't open a new workbook when
I start the application? I prefer the design of my old version of Excel (from

is there a way to create a sum if statement with two criteria that sums a
different column. Sumproduct does not seem to work if there is an error #NA

I've checked the quot;gridlinesquot; boxes as instructed by the Help screens, but my
gridlines won't print. Any ideas?

I am using Autofilter in a spreadsheet and it automatically includes quot;Top 10quot;
as well as quot;Blanksquot; and quot;Non Blanksquot; in the drop down menus of each category.

I want my footer to say Damp;T, but instead it says D2:55PM. How do I turn off
the concatenating text?

I'm using the formula:
=IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)

Hi,

Have a list of 1000 rows of data (countries). Use the adv filter unique to a
new region but still get duplicate values for US and a 'salesperson'. Tried