I have excel and I have folders containing excel spreadsheets. I would like to be able to print only the titles of the files contained wihtin an excel folder.

I am trying to write a formula that will copy a cell or group of cells from one sheet to another based on a null value. Here is the formula I am...

There is a bug in the help section for function SUMIF. Last line says "Sum of the commissions for property values over 160000 (21,000)" but it should say "Sum...

Microsoft Excel 2003 I have a list of names for a roster in a single column covering several months. The information is imported from another source (MS...

Yesterday I posted a question about auto filling the date in a field (posted bellow). Well today to my dismay all those dates advanced to todays date. Is there...

If column a has a limited # of phone numbers in 1 sheet and in the 2nd sheet I have those numbers embedded with many others as well as additional information...

Is there a function that can determine if a date is even or odd? Thanks!

I am trying to merg worksheets so that the columns in each sheet are compared to the master sheet, any new columns are added to the master sheet. Is this...

i worked with a excel spreadsheet but i dont have excel on my home computer is it possible to open this and work on this without excel or microsoft home office?

I am looking at data on one worksheet and transferring to another using the below...

How can I search all the required data say some 'A'from a list of data where 'A' is at some different locations. How can i use Vlookup for this or is there any...

The new version of Excel automatically prefills the formula with the GetPivotData function when I try to use Pivot Table data. I don't want to have this...

I have an Excel document with 2 worksheets. The first worksheet has 20 columns with headings and then dollar figures in each cell and a total of each column at...

Dear reader, I know i am mistaking but the problem is that i cant find my mistake. I am actually practising IF formula... below is the situation DATA: A1=...

This is hard to explain...but I have a drop down list in a worksheet. Whatever name is chosen in the drop down list I need to show up in a different sheet in a...

I am exporting database files from a database program into a comma delimited format that can be opened in excel. When I open it in excel, all looks fine except...

i want to list all the worksheets in a particular workbook on a worksheet that i have named Master. Can someone hlep me on this please ?

How can I copy a ready formula in Excel into codelanguage for macros? For shorter formulas (1 line (function) in Excel), it is possible to start the recorder,...

I have a file with two spread sheets used for First Article Inspection/ First Article Reports. I am trying to automatically load data from the inspection sheet...

I would like to use the CountIf statement but applied to a set of separated cells, rather then a range. like countif((a1;a3;a5;a7);1). However I get a...