I made a score sheet for a game. It's like a standard type grid or table
with squares.
Just to jazz it up, can it be made with circles instead of squares??
                          Thanks in advance,

I have a table consisting of multiple rows and columns on a sheet and I
need to break out certain rows depending on a specific value in the
column into a new sheet. For example, I have a list with multiple
"companies", "contract numbers", "contract dates",

IF function
if you omit the false parameter, the function returns "FALSE"
=IF(A1="Bob",TRUE)
so why doesn't it return "TRUE" so you can omit the true parameter

Please help I to make cell b1 flash when it becomes greater than 5

I am working in a spreadsheet created by my predecessor at the state
agency where I work, and have come across a peculiar bug. In certain
cells, whenever I type in a value, then that value will repeat
endlessly. For example, if I type in "45", then Excel converts it to

I am trying to write an expression that takes an amount in a separate column
and if it is less than or equal to $100 shows $100. If it is greater than
$100 then show the original amount.
So, if the amount is $500 then $500, but if the amount is $56 then $100.

I've been trying to put together a spreadsheet of addresses, so I need to be
able to include addresses that include number ranges - eg. 11-12 High Street
or 14-16 Main Road. The problem is that in the column in which I enter the
number part of the address, these kind of addresses ...

Someone tried to help me but I didn't had any results...
I'm working on a two worksheets.
The formula is as follows:
=VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE

It used to be that when I double-click on an XLS file in Windows
Explorer, my excel spreadsheet popped up with no problem.
Now, when I open up a file, I can't see the last 1/4 of the sheet
because Excel2003 puts an annoying window that covers the last 1/4 of

I'm using excel 2003 and for some reason with my spreadsheet, I cannot
scroll to the right.  I do see the data showing up on top but I cannot
view the columns that have the data.  When I hit on the right or left
arrow, the screen stays on the same cells.  Could anyone please tell me

This must be a simple key stroke.
I work out a formula in H2 cell - it works! So I want to copy that to the
rest of that column. It's a long column, I don't even know how long unless I
do an "END".

Greetings!
We are using the 12 hour clock format in our time sheet and were able to
calculate the hours worked, however, we want to display the time 4:00 PM as
4:00 without the PM with the same calculation result.

Currently I am unable to download information from the accounting system in a better format. So one line of information come into Excel in one cell, hence, the example below:
     @1 0325@1 OPENING BALANCE : .....ESTIMATED COST - MATERIAL@1<       813,936.29
     There are ...

I am importing data from an external source, database query.  When I
"edit query" (not represented graphically), and then edit the sql,
after clicking ok,  microsoft query runs the query and displays the
results in the microsoft query screen.  Then when I click on "return

The situation is as follows:
Sheet #1 contains the following:
Tax Paid                              $120
Tax Collected                       $100