|
How do i make grid map to input cord for a game
I am playing a war game and want to enter my findings with the cords, but
cannot find the way to make the map in excell...
|
1 |
19.08.2006 21:04:28 |
|
|
Any Way of Creating a 'Unique Key'?
I'm making a mortgage lending database system for my GCSE ICT coursework
and I have a field in the database called ID Number...is there any way
of making it a unique field i.e. no two values can be the same- any
sort of validation or anything?
THANX
--
hustla7
------------------------------------------------------------------------
hustla7's Profile: http://www.excelforum.com/member.php?act...
|
7 |
19.08.2006 15:42:18 |
|
|
Can I lock 2 columns together so that the 2 cells in a row are joined?
Hello,
I want to use Excel to compile a list of my DVDs.
This requires just two columns. The first column will be used to number the
DVD. The second column will be used for the actual name of the DVD.
However, I will want to sort the list in two ways: alphabetically and
numerically.
So the question is: Can I lock these two columns together so that when I
want to see my list alpha...
|
4 |
19.08.2006 15:36:45 |
|
|
Why use Subtotals 1-11 instead of the built-in functions directly?
I see the need to use 101-111 for Subtotals; e.g. I want to ignore hidden
values.
But, I don't see why I want to use Subtotals 1-11, instead of using the
built-in functions like average, count, max etc. directly.
I do understand that if I use Data>Subtotals, I can later modify the
Subtotals function which may have 1-11.
Please enlighten me. Why would I choose Subtotals 1-11 over a ...
|
7 |
19.08.2006 09:20:26 |
|
|
Creating "IF" arguments
I can't seem to firgure out how to set up the following argument in an Excell
spreadsheet!
IF cell B-6 has the value of "C" than cell J-6 = .8*H-6 and cell I-6 = .2*H-6
IF cell B-6 has the value of "P" than cell J-6 =SUM(H-6-E-6)
The part I don't understand is how to incorporate the "IF" condition.
Thanks to Anyone!
...
|
3 |
19.08.2006 06:46:45 |
|
|
Searching Across Worksheets: Please help!
Assuming I have a workbook with many worksheets and I want to search for
a particular word contained in one of the cells, in one of the sheets
somewhere in the workbook, how do I go about it?
Please help!
--
computerfineman
------------------------------------------------------------------------
computerfineman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37165
View...
|
5 |
19.08.2006 04:03:52 |
|
|
DSUM not pulling the data - why
Using Excel XP.
===============
I'm setting up a budget workbook, and one sheet (5 Year Strategic Plan) has
a DSUM in it under a column labeled "2007":
=DSUM(Capital,'Capital Projects'!$P$3,$E$39:$F$42)*12+DSUM(Capital,'Capital
Projects'!$P$3,$V$17:$W$23)
It shows "zero" as the value pulled, yet when I look at the sheet labeled
"Capital Projects", I see 2 values that should have been...
|
1 |
18.08.2006 20:12:18 |
|
|
List for AutoFilter and list for Subtotals have different meanings?
I need to type up a list if I want to use
(1) Date>Filter>AutoFilter or
(2) Data>Subtotals
A sample list:
Month Units
Jan 100
Jan 200
Feb 100
Feb 400
Mar 300
etc. etc.
I find the following interesting.
To do (1) AutoFilter, I have to actually **create** a list i.e.
Data>List>Create List ......
If I want to...
|
3 |
18.08.2006 20:02:33 |
|
|
DIV/O Error
Here is the wrong way:
=IF(B91/(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87),(B91-(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87))*0.5+(D4*D87+E4*E87+F4*F87+G4*G87+H4*H87+I4*I87)*0.166722)
This example was kindly provided and I must post for those at my level to
learn the better practice approach.
=IF(SUMPRODUCT(D4:I4, D87:I87)=0, "", IF(B91<>0, B91/2 -
SUMPRODUCT(D4:I4, D87:I87) *...
|
1 |
18.08.2006 17:28:02 |
|
|
Viewing multiple spreadsheets
I have Excel 2003 Professional. I'd like to look at two spreadsheets at a
time, but each in its own window. Excel defaults to opening each new
spreadsheet as another workbook in the current window. If each were in its
own window, I could have one spreadsheet on the left monitor, and the other
on the right monitor.
Thanks for any help!!
Mike
...
|
7 |
18.08.2006 17:00:11 |
|
|
PROBLEM WITH AUTOFILTER
I HAVE A WORKBOOK, AND I ACTIVATED THE AUTOFILTER DROPDOWN BOXES.
I NOTICED WHEN I OPEN THE DROPDOWN WINDOW OF THE AUTOFILTER OF A COLOM, I DO
NOT SEE ALL THE DATA THAT IS IN THAT COLOM. IT SEEMS LIKE IT GOES TO A
CERTAIN POINT AND THEN IT STOPS SHOWING ANYTHING AFTER IT.
EXAMPLE: I HAVE A WHOLE BUNCH OF DATES IN THIS COLOM. THE DROPDOWN WINDOW
ONLY GOES TO THE YEAR OF 2003. THERE ARE...
|
2 |
18.08.2006 16:41:25 |
|
|
PROBLEM WITH AUTOFILTER
..I HAVE A WORKBOOK, AND I ACTIVATED THE AUTOFILTER DROPDOWN BOXES.
I NOTICED WHEN I OPEN THE DROPDOWN WINDOW OF THE AUTOFILTER OF A COLOM, I DO
NOT SEE ALL THE DATA THAT IS IN THAT COLOM. IT SEEMS LIKE IT GOES TO A
CERTAIN POINT AND THEN IT STOPS SHOWING ANYTHING AFTER IT.
EXAMPLE: I HAVE A WHOLE BUNCH OF DATES IN THIS COLOM. THE DROPDOWN WINDOW
ONLY GOES TO THE YEAR OF 2003. THERE A...
|
1 |
18.08.2006 16:36:02 |
|
|
HOW DO I DISPLAY WORKSHEET TABS?
I've just got office 2003, and the worksheet tabs aren't shown at the bottom
of the page!!!! I need to switch between pages all the time in my current
project! Can anybody please help or my ass is going to get
fired!!!!!!!!!!!!!!!!!!!!...
|
4 |
18.08.2006 12:28:46 |
|
|
Auto transfer of row
I have a list of components to be ordered in each row is a cell with a
order number entered in it. What I want is to copy the row to another
sheet (which is to be displayed at goods) when the order number is
entered in that cell. Is this possible? many thanks for any help.
--
alanled
------------------------------------------------------------------------
alanled's Profile: http://www.excelfor...
|
3 |
18.08.2006 11:06:25 |
|
|
excel
hi i was wondering how to make a drop down box so i can select a name for
say my taxinvoices for my clients instead of having to type in the whole
thing
thank you...
|
2 |
18.08.2006 10:52:12 |
|
|
Countif Help
Hi,
I'm trying to count the number of time a specific value appers with in
a range of cells, but I want to place the results in a seperate
workbook. How do I do this.
Thanks in advace for any help
Calli
--
calli
------------------------------------------------------------------------
calli's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37561
View this thread: ...
|
3 |
18.08.2006 08:17:02 |
|
|
How do i set up check boxes in excel?
I am really green at excel and I do not have a book to find answers in. I
have tried the help feature but I seem to be getting no where.
Can someone please help me? I am trying to set-up check boxes that will
allow us to select a edge profile for counter tops that will then appear in
the correct spot on the bid sheet. If need be I can send a copy of the bid
template we have now so you c...
|
2 |
17.08.2006 22:59:01 |
|
|
how do I stop the cell from filling automatically?
I am trying to fill in scores from a golf match in an excel spread. When I
try to enter individual scores I get the # sign for some of the numbers.
This seems to be happening in only one column, so I must have something
turned on to make this happen. It's not happening in EVERY cell in the
column, however. I tried to turn off anything that said auto fill, but it
didn't help.
Hel...
|
2 |
17.08.2006 20:42:34 |
|
|
Excel application.quit in macro problem
I've created a macro that begins with an auto_open importing,
reformatting, and saving data. In the same macro, I have an open excel
form. Next, Im attempting to application.quit the excel wb because it
isnt needed. When I enter a simple application quite before end sub, 30
seconds later, the excel re-opens and runs the process again. Anyone
ran into this before? Any ideas to stop this?
Than...
|
4 |
17.08.2006 17:36:17 |
|
|
Forms: can a cell itself be clickable?
Hi! I'm trying to create a form for my boss. I'm using the forms toolbar,
but what it does is throw in a check box for instance, but if I change the
cell in any way, the "picture" of the click box stays where it's at. Any way
to change this?
In other words, I don't want to the click box to be a picture, I want it to
be an integral part of the cell, so I can modify it as needed (ie. plac...
|
2 |
17.08.2006 16:59:01 |
|
|
opening a worksheet at a specific point
i have a diary , i would like it to open at the specific date every time i
openen the file.PLEASE HELP>...
|
14 |
17.08.2006 16:12:39 |
|
|
Please help me decipher the result of COUNT.
Following data from A1:A7
Sales
12/8/2008
19
22.24
TRUE
#DIV/0!
=COUNT(A1:A7,2) returns 4.
I don't understand where the four occurrences of 2 come from.
22.24 = 3 occurrences
12/8/2008 = 2 occurrences
total of 5??
I know I am missing something. Please tell me.
Is there a tool that I can use to trace? I tried the formula auditing
t...
|
15 |
17.08.2006 14:31:16 |
|
|
inserting object
i try to insert pdf file to my excel file
in Insert>Object>Create from file>Browse the pdf file
there an message appear when opening the inserted file-"Cannot start the
source application for this object"
What does it means?
...
|
4 |
17.08.2006 13:06:27 |
|
|
search function
Is there a way to search an entire column for specific information? (Ex:
search a column for the word "item") Then, display the word I searched for in
another sheet? After displaying the result , is it possible to display
specific cells in the same row the word was found in excell?
...
|
4 |
17.08.2006 12:39:36 |
|
|
"making" a line red.
Can I make a whole line go red, if one column gets a higner number then 26.
That one column add´s up 3 others and when it hits 27, I want it to make the
whole line red.
Is that possible?
...
|
3 |
17.08.2006 11:35:30 |