i would like to combine the followings in ONE single (choose) formula :
=CHOOSE(MATCH(E44,"X",0),5)
=CHOOSE(MATCH(E45,{"X","Y"},0),6,7)
=CHOOSE(MATCH(E46,{"z"},0),8)

My original worksheet had 354 pages, but I have deleted data from page 5 to
354.  How can I delete the empty pages?  At this point I am not ready to
print the worksheet.

i would like to combine the followings in ONE single formula :
=CHOOSE(MATCH(E44,"X",0),5)
=CHOOSE(MATCH(E45,{"X","Y"},0),6,7)
=CHOOSE(MATCH(E46,{"z"},0),8)

worksheet is not protected. autofilter key is disabled in the worksheet.

Greetings All,
I have been working on a spreadsheet that was set up with macros, as I was
working on it today I noticed it was not pulling info from the other
spreadsheet. I checked the list of macros and is not there. Is there a way

That's perfect Dave.  Many thanks!
I do have another question.  The function
=If(Iserror(Match(A1,$B$1:$B$6,0)),"",A1) works perfect although I would like
to also return the value in column C.  In other words, if there is a match

I am in the middle of a bad situation. I have a lot of rectangle
symbols that have shown up in my excel document when I open it. When I
try to copy this symbol and do find and replace it does not want to
copy over. Is there any way to mass delete all of these symbols at

Hi! I'm creating a time sheet to log daily hours worked - in order to get a
decent idea of what my Gross paycheck will be. Right now the formula I'm
using to figure out my daily hours worked, is just a simple Time Out - Time
In. The only problem is that this reports the Hours ...

Is there a less labor intensive way to delete scattered blank cells as a
result of doing an unmerge?
My thanks,
Troy

I am using 2003, and I am trying to fix my employers timesheet.  It started
as a basic timesheet where we had to manually fill in each date and shade in
the weekend columns.  I have everything worked out so that I can enter the
start date and everything updates from there.  My ...

I have a list of Tab Names.  Is there any way to automate the process of
inserting a new worksheet and naming it from the list?
List
A

Using Excel, how does one chage the settings to all the search results to be
more evident...possibly highlighted?

how would i check if a cell is empty every 2 seconds?

It is possible to protect word or excel file contents from being copied and
pasted into new ones??

Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...?