|
Want a column of cells to have drop down box of another text file
I have this spreadsheet that I wanta column of cells to have a drop down box
that would show choices froma text file that periodically gets updated. I
would like the drop down box to "point" to this external file to get it's
data. Is this possible?...
|
3 |
21.09.2006 19:10:02 |
|
|
Multiple records per row
I would like to use the autofilter function on an imported database.
Unfortunately I don't have the ability to alter the database until after I
import it into Excel. The problem I have is that some of the columns have
more than one record per excel row. For example:
1 2 3
---------------
a b c
d
---------------
e b g
--------------...
|
5 |
21.09.2006 19:09:01 |
|
|
Parsing Cell Contents
I see many threads discussing how to take contents of various cells and
concatenate into a single cell on separate lines (= A1 & char(10) & A2 &
char(10) & A3 ....., etc.). How do I do the inverse process? In other
words, how do I take a single cell consisting of multiple entries (each on a
seperate line) and copy it to multiple cells so that each of these new cells
has only one distin...
|
3 |
21.09.2006 19:08:02 |
|
|
how can i hide zero results row in a pivot table?
tried using the formula but it showed all false. Something I'm doing wrong?...
|
1 |
21.09.2006 18:30:01 |
|
|
Redirect source of pivot table
Client inherited some files with pivot tables that are pulling data from an
Access database. The access database was moved to a different drive so when
she tries to refresh the database, she gets an error that the file can not be
found. We have tried to redirect it to the correct location by browsing and
selecting the file but we then get a dialog box asking for the administrator
passwor...
|
6 |
21.09.2006 18:29:02 |
|
|
COMBINATION FORMULA
I would like to have the (#N/A) caculations appear a (0) within the following
formula.
=VLOOKUP(A2,'RUNNING DATA wkly'!AO$3:AR$6000,4,0)
...
|
3 |
21.09.2006 18:26:02 |
|
|
Splitting the contents of a cell
I have been given a list of hospitals in the UK. The format is:
The Royal Infirmary of Edinburgh [Edinburgh]
As you can see the city the hospital is located in is enclosed in square
brackets. What I want to do is split it so that the hospital name is in
column A and the City is in column B
Is there anyway to do this without having to manually go through each one.
Also the entries ...
|
8 |
21.09.2006 18:21:50 |
|
|
Looking up information and returning a value
I have an Excel worksheet where I'm trying to display a value in a field
based on the state selected in another field.
For example if the state is TX, the value is 100, if the State is FL, the
value is 120 etc.
I have the states listed on a worksheet in column A and the corresponding
values in column B.
Then I set up the second worksheet, same workbook with my other information.
...
|
5 |
21.09.2006 18:13:02 |
|
|
Formatting Parts of Formulas
I've created a formula that includes text and also variables from other
cells. Is it possible to format different parts of the formula differently,
e.g. bold some of it? For example:
="Beginning of sentence "&TEXT($D$26,"$##,####.00")
I would like to be able to make the data brought in from D26 bold....
|
5 |
21.09.2006 18:08:01 |
|
|
List Bldg # according to sum of hours and bldg rank....
Greetings,
I have the following scenario that I'm trying to wrap my head around.
(col A) I have a column with a unique Building identifying numbers.
(col B) I have a column with a building ranking # (ranks how important the
building is, this not necessarily unique, there will be several buildings
with the same rank #)
(col C) Number of maintenance hours for each building
(Cell D2) a b...
|
4 |
21.09.2006 18:02:35 |
|
|
Excel sheets should move while selected cell stays in middle
Excel should allow you to keep the selected cell in the middle of the work
area so that as you scroll down (or sideways too) the sheet moves up but the
selected cell is always in the middle of the work area so that can see where
you want to stop before it is too late and have scroll back up because you
over shot your mark.
----------------
This post is a suggestion for Microsoft, and M...
|
1 |
21.09.2006 17:40:02 |
|
|
IF Statement
I am trying to create an IF that looks for a date range from one column and
then counts items in another column. The formula I have below is not looking
at the MONTH field. Any suggestions? Thanks!
=IF(MONTH(SHEET1!A2:A500*(2)),COUNTIF(SHEET1!G2:G500,"Successful"))
MONTH is looking at SHEET1 in cells A2 to A500 for February (2 month)
The next statement should look at only February da...
|
4 |
21.09.2006 17:40:02 |
|
|
Column Header Listing for highest value in a row
Thanks for anyone's help in advance . . .
A spreadsheet contains data in columns A-D, for 100 rows.
In row 1, a title for each column exists.
How do I have each row's Column E contain the column title for the cell in
that row that has the highest value?
Thanks!...
|
5 |
21.09.2006 17:33:01 |
|
|
Excel attachment
When I send an excel workbook and the recipient opens the it, the book
reverts to their formatting.
2 examples:
1. When I send the workbook and the sheets are in landscape, they will
revert to portrait.
2. The margins are changed and therefore all of the columns will not print
on 1 page.
I am working with employees who are not very computer literate, so it's very
important t...
|
1 |
21.09.2006 17:21:01 |
|
|
Can a pivot table calculate the difference between two fields
My pivot table is summarized by group, then by Actual Headcount and Budget
Headcount. So for example, HR is the first category broken down into 10
heads of budget and 9 heads of actual. The Total line sums the Budget and
Actual total to show 19. I would like the Total line to show the difference
between Budget and Actuals. So instead of the sum of 19, I would like the
pivot table to ...
|
2 |
21.09.2006 17:12:09 |
|
|
Run macro
Hello I have the following macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$D$9" Then
Call Calculation
End If
End Sub
How do I set it up to run the macro "Calculation" after I changed the value
in D9 rather than when I select cell D9?
thanks...
|
3 |
21.09.2006 17:03:03 |
|
|
Can you sort worksheets other than manually?
I have copied numerous worksheets from another workbook and I need to sort
all worksheets alphabetically. Other than manually, can EXCEL 2003 do this
for me?...
|
2 |
21.09.2006 16:55:53 |
|
|
Changing cell value according to list value
Hello! I have a list of 1 to 10 ($A$1:$A$10). In the column beside the
numbers, I have names ($B$1:$b$10). In cell $C$1, I created a validation list
of my numbers. In cell $D$1, I'll like to change my names according to the
number I choose in my list.
So lets say I have like data:
A1 = 1 , B1 = Toto
A2 = 2 , B2 = Tata
A3 = 3 , B3 = Titi
..
..
..
When I select from my drop down m...
|
2 |
21.09.2006 16:54:26 |
|
|
IF function won't post cell values
Below is the question I posted earlier but I for got to mention this:
I.E. On spreadsheet #1 in cell D48 I want the cell value of cell C4 from
spreadsheet #2 to post. If cell C4's value is 0 then I want cell F4's value
to post in cell D48 of spreadsheet #1. If both C4 and F4 of spreadsheet #2
are 0 then I want cell I4 of spreadsheet #2 to post in cell D48 of
spreadshhet #1. I didn't men...
|
3 |
21.09.2006 16:42:01 |
|
|
macro restricted to one column
I have the following macro, but I would like to run only when a "w" is
entered in any cell in column A.
Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveCell.Value = "w" Then
Range("I" & ActiveCell.Row).Select
End If
End Sub
Thanks in advance for the help!!!...
|
6 |
21.09.2006 16:26:08 |
|
|
User has a blank screen when document is open.
When the user opens an excel spreadsheet, the part of the screen where the
cells should be displayed is blank gray. All else is displayed normally,
including the cell location, formula bar, tool bars -- everything. All views
have been tried, it's not a minimized sub-window, everything is in full view
-- just that the spreadsheet is a blank gray area....
|
2 |
21.09.2006 16:08:02 |
|
|
opening excel 2003 files with excel 2000??
I'm pretty sure the answer to this question is yes, but I figured I'd double
check here:
If I create an Excel workbook in Excel 2003 I can save it as an Excel 2000
document, correct? And this will allow me to open the Excel file in XL 2000?
Thanks,
Dave
--
Brevity is the soul of wit....
|
3 |
21.09.2006 15:53:02 |
|
|
Excel's filters should give the option to filter duplicate cells.
When sorting information in Excel using the Filter feature under the Data
Menu, there should be an option to find duplicate cells. I saw a work-around
once but it was convoluted and dealt with a True/False function that takes
too much time to write compared to doing it manually.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with th...
|
1 |
21.09.2006 15:48:02 |
|
|
Formula - to accumulate the number of data appear
Hi
i got some problem with excel.
My 1st spreadsheet - No of appointment
Date Status Country
--------------------------------------------------------------------
01-09-2006 Accepted ABC
01-09-2006 Accepted ABC
01-09-2006 Accepted ABC
01-09-2006 Accepted ...
|
3 |
21.09.2006 15:47:02 |
|
|
Negative Times Displayed as # # # #
Cells A1:C1 are formatted as "h:mm:ss."
A1 is the time it took to complete a task the first attempt. B1 is the
time of the second attempt (preferably with a faster time). I want to
have C1 show the difference of the two attempts (B1-A1). This
calculates the difference perfectly if A1 is less than B1 (if it took
longer the 2nd time). However, Excel returns "######" if A1 is greater
than B1.
...
|
2 |
21.09.2006 15:43:15 |