Hi, In my Excel Macro, the User selects the file to open.I have used the following command. ExcelFile1 = Application.GetOpenFilename("Excel- files,*.xls",...

In row 5 I have a formula that retuns: Text, negative numbers, and positive numbers In row 10 I want a formula that I can copy across and if the cell in row 5...

I have a spreadhseet withe names nad addresses I want to do a mailing to. THe list contains zipcodes I do not want to mail to. The list is too large for me to...

is it possible to filter out columns?

I'm plagued by a problem where a simple solution likely exists, yet I can't seem to unearth it. I am trying to capture the count of a text string in one...

Using Excel (XP) text in cell B6 go to B14 and type =B6 the result is "=B6" and not the text of cell B6

I have a timesheet in which only hours worked (hh:mm format)for each day are entered. 1. Is there a cell format that will allow the time to be entered either...

Hi I am using a formula to get a sum amounts between the first of the month and the last day of the month. I am using 29 as the last day of the month. months...

I have just purchased this Micosft published book Accessing and Analyzing Data with Microsoft Excel. I am currently on the Pivot Table section (Chapeter...

I have copied a file to re-use for another purpose. I made my changes, but now it has an automatic link from the original file. I have looked all over to try...

i have a cell in a spreadsheet, which i was currently displaying the values of two other cells, with a space between the values. what i would like would be to...

I have a spreadsheet with several hundred dates in diffferect cells. The dates are typed in as "01/01/2003" but show up in the spreadsheet as a five digit...

Hi I need to find how to work out the total number of months where I have a list of fixed start and end dates, always beging on the first day and end on the...

Can someone tell whats wrong with the following formula? i want to the number of lines that has vendor in column L etc and any cells in column F that contains...

Thanks, That did help me see what matches i have in the two sets of colums but I am still lacking the second part where if there is a match in the two colums,...

I would like to build an Excel expression that would always show the Sunday date of the current week Based on that date I would like to build a expression...

Hi All. How do create a formula which give me the sum of 5 cells minus the smallest cell? eg: if the cells contains numbers: 10, 12,15, 3, 14. The formulas...

Does anyone know what the limitation is on how many cells you can use in a Sum function? I ask because I'm trying to total about 60 cells into 1 and receive...

How do I get the following formula to work I want to count the # of lines that have vendor in column L and a date between the values referenced, and any cell...

I have three columns that I am using. I am trying to count one column if the other two columns meet some criteria. B2:B2000 has data that is either: 1, 2, or...