I maintain some spreadsheets containing formulae like this:-
=IF(OR(AN135="",AN135="-"),"-",IF(RIGHT(AN135,2)="OR","-",LOOKUP(AN135,Crib!$A$1:$A$272,Crib!$B$1:$B$272))).
The cells containing the formulae are locked, and protection is normally
turned on.  Most of the time, the ...

I have a spreadsheet that used to have a chart in it.  I removed the
chart and the entire column that it resided in.  My spreadsheet is just
a report.  It has no calculations it it.  Yet every time I resize a
column I get a "a formula in this worksheet contains one or more ...

Is it possible to search on the results on a cell?
For example, a cell may have a formula such as
=3+5
You can search and find the 3 or the 5.  The cell with show 8, is it

Can someone point me in the right direction?  Or tell me what the below
"concept" is called so I can search for the answer?
I have a cell [A1] {containing the number 2) that is referenced in
numerous calculations throughout the spreadsheet.  If I change [A1] to

1.) I have a formula in a cell that when clicked, sends an email to
recipients in the formula.  I have pasted the formula below.  What I
want to do is put the date after the "End of Day: " part.  However,
when you click on the link, it gives the serial representation of the

I am trying to combine text that is in 4 different cells into one cell.
For Example:
 D1            E1       F1    G1
FIRST FLOOR   PAVING   PLAN  DRAWING  

I have a workbook that consists of 15 worksheets. One for each
month and then a summary page for the year plus a couple of
worksheets containing charts. Every time I open it I'm prompted
that the workbook contains macros. I haven't created any macros.

OK, here's what i want to do. I have a spreadsheet (condensed below)
Store Location ID  Acc Amount
A        67583         $2895
B        78594         $5000

I have SEVERAL vendors, by name, that are listed different ways - Example:  
ABC Co  may be ABC Co or ABC Company or abc co or ABC Co., Inc.
I want to consolidate "like" names within the column on a workbook and also
consolodate with "like" names from another workbook to make one ...

The lookup seem not to work it the first column in text, can any one
help please,
=LOOKUP(B20,A1:H17,H1:H17)   if B20 is text and # , and it was a
reference of a cell in column A , this would work if column A was

I need some help. I'm trying  to put a formula in a cell to ready onl
the date.  When i set the date and type in 02162005 it gives me a dat
for 5/14/19. how can I fix it for it to show todays date in that on
cell.  Yeah i can use control, ; but i have multiple users and don

Want to have a macro that will hold a value in its memory and subtrac
a different value from the value in the memory then write the result
to a cell in a column as I proceed down the column. Then I need t
change the value held in the meory as so on. Any ideas

I've found a macro to allow exporting of Quote/Comma delimited files.
And I have it working in my workbook.
How can I make this Macro appear as available in all Excel files and
workbooks without having to import it into each one?

I have two huge (53000 rows each) worksheets (file size 50MB)and I want to
build one pivot table from them. There are 15 columns of data each, with
exactly the same columns headers(only the data is different. How do I do this?
I have been trying multiple consolidation ranges and ...

How do I undo specific colums in an excel data base?