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 / Worksheet Functions / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel Question12 Feb 2008 21:20 GMT4
Here is my problem.
Say I have a list of 20 baseball player names in one column and how many
home runs that they have in the next column.  How can I make a cell = all the
players names that have over 20 home runs?
Conditional format question..12 Feb 2008 21:02 GMT2
Can't seem to figure this out...
Three columns of data.
If the value in column 1 is a text string that is "N/A" I want to format
cells, for that row, in column 2 & 3 (which will be empty of text) with a
reference work sheet name by using a formula12 Feb 2008 20:45 GMT3
I have multiple sheets.  Instead of using the harcode sheet name and the
reference cell in that sheet, is there a way to refer to the worksheet name
using a label.
I want to copy a value from sheet named "XYZ" cell "F5" to my current Sheet1
creating 2 columns12 Feb 2008 20:31 GMT3
Just need to know how I can eliminate pages by creating columns with my list
of addresses.  For some reason this new program baffles me sometimes on the
simplest tasks.
circular reference question12 Feb 2008 20:30 GMT2
I am trying to calculate answers that use the answers from other
calculations. Is there a way to do that without getting errors?
Problem with date display12 Feb 2008 20:18 GMT1
Despite changing the formatting of the cells, typing in a date displays the
serial date, i.e. 35608 etc.
Other worksheets open and function ok.  
Can't see in the options where something may have changed on the problem
protection is not work.12 Feb 2008 20:11 GMT5
I  created an excel file and set two colmumn on one worksheet to hide ,and
then set protection on the worksheet. those two colmumns are refered by other
worksheet.
My problem is that user can unhied the protected colmumns. Protection is not
Conditional Vertical Lookup12 Feb 2008 19:43 GMT2
I am trying to write a functional statement that picks up  a certain value on
a different worksheet.
If the first 4 letters of this column in this sheet equals this, insert H-
in this cell.
ExportAsFixedFormat for Multiple Sheets in a Single Excel File12 Feb 2008 19:42 GMT2
It seems I can only save to PDF one sheet at a time, is it possible to print
multiple sheets in a single PDF document i.e. multiple page PDF?
Thanks.
Multiple values from the same list of numbers12 Feb 2008 19:13 GMT3
I have a (long) list of spectral data. It consists of 1 column of time
increments, and 1 column of intensity values. I am trying to find the maximum
for each of three peaks in the data, plus, once the maximum has been found,
the values closest to halfway between the baseline and ...
I WANT TO CREATE A FORMULA USING DATES12 Feb 2008 19:02 GMT8
I have dates in 3 seperate colums for 3 seperate tasks on Sheet 1. On Sheet 2
with in the same file i have a colomn that has either nothing or an X in it
when a specific task is complete.
the three date colomn's are:U5, V5, W5.  
Normalfordeling12 Feb 2008 18:21 GMT3
Pleas, I have to draw a normal fordeling kurve, I have x and y data, and I
draw histogram, but I would like to draw en kurve "normal fordeling"
Thank you very much
Given today's date, I want this week's Monday's date12 Feb 2008 18:16 GMT3
I cannot find a good way to extract this week's monday's date.  I want the
sheet to read Today() and return the date of the monday of this week.  I
would prefer to NOT do this in VBA but that is an option.  
I consider myself a pretty advanced Excel/VBA user so please unload.
IF formula help part two12 Feb 2008 18:01 GMT2
I am trying to do a similar thing but my values are different.
>>> The idea is that if J16 equals 0, then G11 will show 0
>>> If J16 is greater than 0 and less than 1, then G11 will show 0
>>> If J16 is equal to 1 but less than 2, then G11 will show 1.5
Formula Nightmare12 Feb 2008 17:54 GMT6
I need to compare a range with a number and then have a certain result based
on the range. Can anyone help?
 
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.