I have an excel file that I always save as a text file for importing into another program. I was wondering if a Macro could be made to do this? I have tried...

Please refer to Ntobias' thread on Aug 24, 2006 and Sandy's comment before you read on. Sandy, Thank you for your comment and a different perspective. ...

I am using MS Office ExCel 2003(11.6560.6568) SP2 and have a single sheet with a 2D array of numbers roughly 202x202 in size. Could someone tell me the...

This is a phenomenonally simple task: All I want is the formula "=SUM(B38:F38)" result to display on my spreadsheet. Excel shows $0.00 in the cell. The...

I'm currently using vlookup to select paragraphs of information depending on a dropdown list. The vlookup refers to an array in another sheet. Is there any...

Hi, I want to use formula in condition syntax, but I don't know how to reference the value being tested. Like: SUMIF(A1:A10;"10 AND 20") Or: ...

How can you remove filter records which are the same in 3 to 4 columns only the ones that have in all 3 columns same wording

hiya, i have a small project and i've spent too much time on this already - can't figure it out myself. What i need to do is to create a formula which will...

we sell products that sometimes get "split" between 2 salespeople. I have set up a basic spreadsheet that tracks sales and profit but can't figure out how to...

Hello, At work today I was asked to create a spread sheet with products and they want the colums on the top to say the name of the product in a slanted lined...

Hi, In Word, it has Columns function that is very useful. When the column A is full in one page, the data automatically go to column B and then C.... ----- In...

when I print (hidden on the paper print only) without erasing or deleting the word or formula in the cell? Thanks in advance.

I use Excel a bit but I don't have much experience with formulas. I'm finding more and more things that I would like to put into a spreadsheet and have Excel...

i have an excel worksheet to do and i have been instructed to drad a formula and i have no idea what that means. thanks spencer

I have quite a bit text entered in a cell. But Excel doesn't display all. I tried wrap text, merge cell, but none worked. All text is in there when I click the...

I am trying to set up a 4 day "Scorecard" for a golf tournament using Excel 2002. Column A is players name. column B is handicap. Column C is Day1 Gross...

Hi, I have two worksheets, an invoice, and an inventory. What i need is to be able to deduct quantity sold (from the invoice) from the quantity in stock (in...

I want to know how I can get a new row to add at the end of my data entry w/o having to manually click "insert" "rows". In column A, there are entries in...

Hi, please help... I am trying to total up commission figures in a column that match a specific year. Each row contains a cell for the date it was entered,...

I'm trying to put a football league table together, which i'd like to include: the team, matches played, won, drawn, lossed, goals for, goals against, goal...