Regarding a worksheet with columns A-E; Columns A-D are for name, company,
status, phone #; column E is for notes, some of which are lengthy. I
- Aug 28 Tue 2007 20:39
wrapping text in excel
- Aug 28 Tue 2007 20:39
Total an array
I am looking for the formula that will total the amounts of column B based on
Column A Matching Cell A10.
- Aug 28 Tue 2007 20:39
Saving excel files
Is there a way to configure excel to actuall modify a spreadsheet that it is
editing, as opposed to makeing a temporary copy of the file, and overwriting
- Aug 28 Tue 2007 20:39
creating a file name from a cell
I am working on a macro to export certain data to a txt file. Everything is
working now but I would like to add a little sizzle to it. Right now
- Aug 28 Tue 2007 20:39
Working with =IF(ISNA,(myformula),0,(myformula)
I am trying us the =IF function with the following... =INDEX(Crew!$A$1:$G$25,
MATCH(B23,Crew!$A$1:$A$25,), MATCH(quot;Ratequot;,Crew!$A$1:$G$1,))
- Aug 28 Tue 2007 20:39
streaming csv data
I am streaming a .csv file to the browser using application/vnd.ms-excel. I
am sure that yesterday the file was opening correctly in Excel format, but
- Aug 28 Tue 2007 20:39
Find max number of character and return cell address
I have a range of cells from E18:E21 that look like this:
- Aug 28 Tue 2007 20:39
Can I sort in Excel and leave the formatting (color) in place?
I have colored lines every other row and when I sort the colors go with the
text. How do I lock the formatting?
- Aug 28 Tue 2007 20:39
Combine multiple workbooks into one workbook
I would like to combine a number of workbooks inside a folder into one
workbook and maybe have the worksheet name be the name of the file or
- Aug 28 Tue 2007 20:39
please i need an answer
How can I change a weekend day defult in the networkdays function in the
excel sheet ?