Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Displaying Drop down list items based on selection of another colu18 Feb 2008 14:15 GMT3
Good Morning!!  I am running Excel 2003.
Is there a way to display items from a dropdown list based on what is
selected in another column.
For example... Column D has a list of Work Flow's in it and Column E has
Coding data18 Feb 2008 13:16 GMT2
I have compass bearing wind direction forecast measurements with an accuracy
to one degree. Which is being compared to obserevd wind directions which is
recorded in the 16 points of the compass.
Using EXCEl 2007 I need to convert the forecast into the same format with
How do I connect two worksheets together?18 Feb 2008 12:46 GMT7
I'm trying to connect two worksheets together whereas the input into a cell
of one will influence the outcome in the cell of another.
EX: Inputting 300 in a cell of the first sheet will give me an answer in a
cell of the second sheet, less 15%.
F1 and F2 keys desactivated18 Feb 2008 11:35 GMT6
My F1, F2 and other F functions keys are desactivated.  Could you tell me how
to activate them again.
Regards
countif with cell ref vs fixed number...18 Feb 2008 11:07 GMT5
I am trying to use countif to establish whether a range of cells have a value
greater than or equal to a number in another cell - the number is 21.8% and
lives in cell C4
this formula works fine =COUNTIF(C16:R16,">=21.8%")
Stopwatch time18 Feb 2008 08:03 GMT2
How can I enter stopwatch (or elapsed) time into cells in the format of
x:yy.zz where x is minutes, y seconds (0-60) and z is hundredths of seconds
(i.e. 0-100). I would like to show the actual time in the cell and then be
able to chart these times. This will allow me to compare ...
Updating linked cells within a workbook, from worksheet to workshe18 Feb 2008 01:15 GMT7
(Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.  
Many of the sheets contain cells that refer to values in other sheets.  I
recently found that some of the values were incorrect (I believe they were
just not updated).  When I double clicked on the cell, ...
Can't get Forms option bjuttons into a Group box18 Feb 2008 01:09 GMT3
I want group option button so I am trying get a group of option buttons into
a group box unsuccessfully.
This is what I tried unsuccessfully.
I tried selecting the Group box and dragging and dropping the option buttons
numbers won't autofill18 Feb 2008 00:44 GMT2
  numbers, (1,2,3) won't autofill for me in my excel. Everything else
does, like Monday, Tuesday, Wednesday, and 9:00, 10:00 11:00, but if I
type in "1" and autofill, all I get is more one's. Help??
Changing Cell Background Color Depending on the Number18 Feb 2008 00:41 GMT1
I recently asked a question on how to Count the days a person works even
though there is a formula in the cell and was given =COUNTIF(F4:L4,">0") By
WLMPilot which works wonderfuly.
Now I would like to know if there is a way for it to automaticly change that
count days17 Feb 2008 23:16 GMT2
I have a list of 41 dates employees can possibly work. I need to calculate
how many days each employee worked of the 41 dependant on their start date.
so I can work out a percentage of days worked.  So if employee john started
work on the 1st day and was still employed on the ...
Customized Formula17 Feb 2008 22:51 GMT7
I'm in need of a very specific formula please.
A1 to A100 are all different dates as 02/17/08 ( m,d,y) (could also omitt
the year)
B1 to B100 will be formulas ( of course I just need B1 formula so I copy it
Can I randomly select values from an array with removal?17 Feb 2008 22:49 GMT2
I am trying to set up a random value generator with removal of the selected
values.
Is there a way to accomplish this?
web query will not fill down formulas17 Feb 2008 22:28 GMT2
In Excel 2003 I have had a web query working for several years pulling down
currency rates from msn. Previously, it also filled down formulas next to the
data that came in from the web.
Now, however it seems the table dimensions have enlarged because it deletes
Remove grouped items and fields from pivot table17 Feb 2008 22:06 GMT1
When items are grouped a new field with new items are created.  Is it
possible to remove them completely without redefining the data source for a
new pivot table?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.