General

Assign text to numeric value
have weekly store gross profit report(s) and want to assign a letter based on a range of $0, 1000,2000,3000,4000,5000, 6000 which would return 7,6,5,4,3,2,1 respectively...have tried =lookup(A1,{0,1000,2000,3000,4000,5000,6000},{"7","6","5","4","3","2",1"}) which gives the same rating for all stores. is cntl-sh... 26 Jan 2010 21:14

Taking data from a row moving it to another row and sorting it.
I have a worksheet that outputs totals to row F columns 10-20. I would like to be able to automatically transfer these outputs to Row B columns 10-20 and automatically and sort in ascending order. Is this possible? ... 26 Jan 2010 14:23

delete document list under office button on excel 2007?
Microsoft Office Excel 2007 - I deleted a few documents that I no longer need but when I go to Office Button (top left hand corner), the documents are still listed there but of course I cannot open them. How do I dete them from the list. ... 26 Jan 2010 14:23

Merge Two Files
Hi Reza, There is a new PC software that you can use as a supplement to Microsoft Excel and Access. For one thing, it combines multiple files. Visit www.genresoftware.com and look at the pages Importing Files and Programming Instruction Set. Cheers, Reno reza wrote: merge 2 files 25-Jan-10 Dear Al... 26 Jan 2010 13:14

How do I get the tab key to go to the next cell after entering
... 26 Jan 2010 13:14

Can't shift cells up or down
I'm a new user. Can't figure out what happened. I have been using right click>insert/delete>shift cells up/down. This function is suddenly locked and I only have shift entire row/column functionality. -- Thanks, Tim ... 26 Jan 2010 13:14

background commands running in Excel?
I have created a new spreadsheet for some reporting that involves many charts that feed off one worksheet within the workbook. Every time that I open the workbook, the chart tab names are reset to "chart 1" "chart 2" etc. Also, even if I open the workbook and immediately close it, it asks if I want to save ch... 26 Jan 2010 13:14

formulas
how do i avrage two ro mere avrages ... 26 Jan 2010 12:06

Formula result disappeared
Everytime I visit a cell with a formula in a certain column of my worksheet and press enter, that cell will only show the formula instead of the result. Any idea on how to show the result back again for those cells? Nancy ... 2 Feb 2010 17:27

Issues with linking to exported source files
We recently loaded excel 2007 onto my PC at work, but kept excel 03 on it as the default program since the rest of the company still uses excel 03. I noticed that now my links do not work. Most of my excel reporting is done as a shell summary workbook that links to multiple source files that have been exporte... 26 Jan 2010 12:06