I have a workbook which details some of the dtat in graphical format. The workbook is basically an anylytical tool for accounts. The data and graphs are all...

I am importing a comma-delimited text file. I need to format one column in the file to show as currency. What is the best way to do this so when the file...

I have on sheet 1 john -- sick bill --- sick john --- sick ...

I am comparing three prices I want to no the cheapest one could someone please type in a formula so that I can find the cheapest place. Thank you a ...

I am trying to find excel 2003 templates for 2 sheets that I currently am maintaining 1) a sheet of all our batch schedules. this has the batch name, schedule...

Dear friends pls help me, I have and Excel file having six work book Wb1, Wb2, Wb3……… they are all linked together. I want to send daily report and...

I have several drop down menus on sheet 1 with employee names in column H is there a formula I can use in sheet 2 that will only count individuals -- for...

I am helping set up a spreadsheet for a physical therapy center. One of the Excel 2002 worksheets is for their invoices. There are about 33 current...

I have an excel file with 100+ range names. How do I easily convert those range names to cell references?

Hello, I copied from a pdf several lines of data, in which included the time formated like this: 12:40P. Two questions: 1) how do I convert this text time...

I have a sheet with multiple columns with ouput from survey; I need to count how many people have said 'yes', 'no' etc to a particular question (which I have...

I have been running an involved spreadsheer for a number of years. Couple of macros (not automatic) and lots of formula. Ran with few if any problems under...

Is there a way to copy the contents of the Find (example: Options: Look in: Formulas) and copy/paste into an Excel worksheet since I want to analyze the data...

All the column (DC) titles are different. I want to search each column and return the results to a blank sheet in the workbook - return the column name and ...

I am fairly certain there is a way to do this and I am not finding it.

I need to convert a load of documents into Excel format so it can be uploaded into a program. I have been told there is a program that does this but for the...

I have a template for a purchasing form and each time I use the form I need the number to advance in sequential order on its own.

I know how to use Autofill to fill in series, but wanted the values to grow exponentially. Can this be done with formulas or just numbers? For example, if A1...

My merge cells button is not active. The sheet is not in a table (to my knowledge), and the allow editing option is selected in the Advance Options menu. I...

hi I have a sheet in a work book that is reading off approx 70 other sheets. I am trying to copy the formula down a column for all 70, but I don't know how to...