General

Excel 2007 - Rows - Height - AutoSize question
I am having difficulties using the Rows/Height/Autofit Row Height setting. When I autofit row height for cells that have greater than ~1250 -1300 characters, autofit will not set the row height beyond that number of characters. I can manually set row height. My row heights are no where near the maximum of 409.... 30 Mar 2010 11:39

function Making one row out of many
I have 72 rows, each one is about 10 cells long. Does someone know a function to make one row out of this? Thanks a lot! Melanie ... 30 Mar 2010 12:47

Conditional format Formula -Duplicate & n/a
I am trying to do a conditional format formula to highlight duplicate results, but I have #n/a on some. Is there a way to write the formula to find all duplicates in 1 column, but ignore all #n/a values too? Thanks, BeckyB ... 30 Mar 2010 11:39

UNREADABLE CONTENT
We receive an unreadable content error in our Excel (happens on both computers) spreadsheet. This was a 2003 file that we have converted to 2007 and has an extension of xlsm. Excel stripped the entire workbook of all formats (it called it repair-which is much better I'm sure than what used to happen in 2003 w... 30 Mar 2010 11:39

Dragging a formula across the row in 2007
When I drag from one cell to the next it puts in the correct forumla (i.e., O16+O31 is P16+P31 in the next cell); however, it puts the value from the O column in the P cell. To get the correct sum in P I have to re-enter the forumla (P16+P31). This is also happening with cells that have numbers referring to o... 30 Mar 2010 12:47

Measure on the date different
Hi, I had a huge file of aroiund 10 000 line. This 10 000 line only consist of 500 items. I wish to have an analyise a information. Example in the file it have items, order date, recept date and qty. Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on 15 Feb. Item A order 2 time on 1 Feb but ... 30 Mar 2010 11:39

Excel 2007 convert into tab delimeter text file with extra tab spa
Hi , Sub: I have excel 2007 trying to save as tab delimeted text file having an issue. I have saved my excel 2007 as separate Tab delimited Text files. I see extra tabs stored in the tab delimited text files. But when I do the same with excel 2003 it works fine there is not extra tabs stored in my tab de... 30 Mar 2010 11:39

Data collection Sum/Total (correction)
SUMIF should read: 2 - SUMIF: assume you want the result to be in columns D and E: ... (not rows) "Michael_R" wrote: Here's how I understand your setup: Column A has 365 dates (01.Jan - 31.Dec) (starting in A2) Column B has the weekday of the date in col.A. (starting in B2. col.header "Weekday"... 30 Mar 2010 11:39

Need a quanity of items printed
I am working with Excel 2003. I am new to excel and having some difficulties. I Have a form that requires 5 pages be printed out. WhAT I am trying to do is have a field that updates based on the quantity printed. For example for the first page printed the field would reveal a 1 and the next page would have a 2 ... 30 Mar 2010 12:47

cumulative counting
I have a sales database with >300 records (sales orders) allocated to 6 salespersons. The database is added to constantly. I want to be able to run a report at any given time for each person showing their total sales to date. Any ideas ? -- thanks Roy ... 30 Mar 2010 12:47