|
WHAT FUNCTION SHOULD I USE?
Im a very rookie..
i want to make a quiz using excel 2003..
ex.. i insert batman forever poster.jpg on it
then i put a question below..
"what movie this is?"
if you write down "batman" i want the cell appear " which batman ?"
but if you filled with "batman forever" it will appears " correct "
thank you..
i have try using "function with =IF function..but that is only true or
fal...
|
2 |
22.09.2006 11:25:01 |
|
|
date format
I need to enter data into excel and have it remain in "general" format rather
than have it become a date (eg when i enter 3/1952 it becomes 3 march 1952)
this happens with any viable number that can conceivably be interpreted as a
date (5/2500 also becomes a date!). How can i force the cell to maintain the
format?...
|
3 |
22.09.2006 11:03:07 |
|
|
Exceeded font space error message
Hey all,
I'm in the process of making a workbook with two different sheets with
about 40 or so graphs each. However, I get a weird message saying that
I have exceeded the font space and new font changes can't be made.
That was easily enough fixed by splitting those two sheets into two
different workbooks and that just works fine. But I am just curious as
to what exactly is the font space li...
|
1 |
22.09.2006 10:35:10 |
|
|
How do I remove text limit on a cell
I’ve created a program in Visual Basic which transfers data to a new work
book but it gets chopped short after a predetermined number and I can’t find
how to change it. ...
|
2 |
22.09.2006 10:06:32 |
|
|
Data entry too slow even with calc set to manual
Hello Everyone
I am using Excel 2002 and the workbook concerned is 20MB in size. I
have set the calculation mode to manual to try to speed up data entry
but it doesn't seem to make much difference. Changing the data in a
data cell still takes too long. When I press enter after amending data
in a cell it can take 2 to 3 seconds before the cell below is selected.
For some reason selectin...
|
2 |
22.09.2006 10:00:21 |
|
|
rank
I have a list of data that I need to rank from 1-?? based on two sets of
criteria. here is an example of what I need.
Customer Name Product Sales Rank
Customer A Product 1 100 1
Customer A Product 1 50 3
Customer A Product 1 75 2
Customer A Product 2 540 2
Customer A Product 2 390 3
Cust...
|
3 |
22.09.2006 09:54:28 |
|
|
Is this code error-bearable
Hello All,
following is a code to delete all contents of Two drives.But
it is not working if first drive is not found. Is there a possibility
to bypass the code if the drive is not there in system or any code to
find if there is <drive letter> drive in the system.
---------------- Careful, Either change drive letter to non exixtent
ones or create virtual drives for experiment-...
|
3 |
22.09.2006 09:39:36 |
|
|
Populate lists automatically
Hi,
I have a requirement which has 2 lists to be populated automatically. The
2nd list value is based on the 1st list. For eg:
1st List 2nd List
Fruits (Should display list of all fruits mentioned)
Vegetables (Should display list of all veg mentioned)
Frozen Items (Should display list of all frozen items mentioned)
If i s...
|
6 |
22.09.2006 09:08:20 |
|
|
Grouping problems
I have a sheet of data that I have pulled in from Access. It is based on 2
tables that are joined.
One table contains data on a persons entitlement for holidays so it has
their name, annual days per year and public days per year.
The second table contains the holidays the person took. This is broken down
into total annual and total public.
How do I sum the days taken and subtrac...
|
1 |
22.09.2006 08:48:02 |
|
|
Is it possible to copy a conditional format formula as paste value
I have several rows of data with a header row that has a conditional format
applied depending on a row below.
When I copy that header row to another sheet, the conditional formula still
refers to a row which is no longer where it expects it to be. (because I
copied the header row somewhere else).
Is there anyway that I could get the 'result' of the conditional formula and
NOT have the f...
|
3 |
22.09.2006 08:40:01 |
|
|
change date default settings
hi
i need to create a list in excel using the date format 21- Sep. everytime i
do this it automatically formats this as 09/21/2006 how do i change this?...
|
2 |
22.09.2006 06:52:02 |
|
|
Unable to horizontally mouse scroll in 2007
I cannot horizontally scroll in Excel 2007 with any kind of mouse with this
feature. Any suggestions or comments? Will the final Excel 2007 version
enable this function?...
|
3 |
22.09.2006 06:15:01 |
|
|
multiple conditional formating
i want to create a conditional format/formula that will do the following
if cell <2 then colour green or if same cell is >=2 or <15 then colour
yellow or if same cell is >=15 then colour red
...
|
2 |
22.09.2006 05:40:09 |
|
|
What is the formula to add days to a date
please help...
|
2 |
22.09.2006 04:28:30 |
|
|
How to restore F2 functions
Lately, I am unable to display, when entering edit mode in a cell, the
cell's formula-referenced cells. I used to, upon pressing F2, see a
cell's formula and, highlighted in differing colors, the cells
referenced by the formula to be edited/viewed.
Any ideas how this very useful feature, highlighting the formula's
referenced cells, may be restored? F2 still gets me into edit mode, but
I ca...
|
5 |
22.09.2006 04:22:02 |
|
|
How to delete the blank cells/rolls/colunms to reduce file size?
Hope someone here can help...
I hav an excel file with a vy big file size which i believe is out of
the fact that there are many "blank" cells/rolls/columns
Can someone tell me how to delete them in an effective way?
Await ur advice ^^
...
|
2 |
22.09.2006 04:15:53 |
|
|
Re-use Excel macro
Hello:
Do know how I can re-use an Excel macro. For example, I have imported a tab
delimited ASCII file into Excel and recorded the process in a macro. Is it
possible to use that macro to import other tab delimited ASCII files(so open
the macro and open another file using the macro without having to go through
the wizard - the wizard is automatically opened because of the tab delimiters
...
|
3 |
22.09.2006 02:51:01 |
|
|
Excel formula?????
This seems like a simple scenario although to get it to work on excel seems
impossible.
Here goes.. i would like to set up a spread sheet whereby i could type in
the various forecasts sales for the week from cells A1 to A7 say. I would
however like the numbers i type in to appear as if nothing is in those cells.
Then i would like to be able to type into the same cells the actaul sales
...
|
4 |
22.09.2006 01:58:30 |
|
|
how do I change graphics from a drop list?
I'm trying to use an existing drop list (containing an "if" statement) to
change an area on the spreadsheet designated for graphics. The idea is to
change logos as each selection from the drop down changes. Is there a way to
do this without changing or refering to an entirely different sheet?...
|
2 |
22.09.2006 01:58:02 |
|
|
divide
how do you use thw ((mod )) to divide in excel ?????????????...
|
2 |
22.09.2006 01:56:32 |
|
|
Validation List
I want to use a listbox for a cell. But I want to have 2 different lists to
choose form based on what a certain cell is. EXAMPLE in cell A2 I want to
have a list box. Now if A1 shows "2418" then I want A2 to have a list showing
different options. And if A1 shows "2499" then I want A2 to have a list with
different options. Is this possibe? if so, how do I do it.
Thanks in advace
Travis...
|
8 |
22.09.2006 01:54:35 |
|
|
changing seconds to timecode
I have been given a spreadsheet log of over 1100 audio files, with the
duration of each file given in seconds( eg '57').
I need to convert the seconds to timecode for import into a video editing
application.
Eg 57 needs to display as '00:00:57:00', (hours, minutes, seconds, FRAMES,
with colons as separators).
82 seconds needs to display as '00:01:22:00'
The frames info will always be...
|
3 |
22.09.2006 01:51:38 |
|
|
How do I make a dynamic print range in excel?
How do I make excel automatically adjust the print area to print only the
rows with information in them?
Thanks for the help.
Herd...
|
3 |
22.09.2006 01:48:02 |
|
|
[pivottables] multiple table selection fields update in one click...
Hi
On a worksheet, I have 100 pivot tables. Let's say one criteria of each
pivot table is "month"
Ho can I do in order to only type somewhere the month (let's say in A1
for example) and this month is then automatically populated to all
pivot tables ?
If this is easy... additional question : on the same worksheet, I have
100 pivot tables split in two columns. with the same "month "crit...
|
2 |
22.09.2006 01:42:59 |
|
|
Auto Calculate
could you tell me how i could auto calculate multiple excel spreadsheets.
what i'm trying to say is, in a folder on our network, there are multiple
excel documents. we have to go into each document and go through Tools, the
Auto Calculate. is there a way to just do it once or send out a rule through
the server to say auto calculate all of these spreadsheets in this folder?
Thank yo...
|
2 |
22.09.2006 01:42:37 |