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 / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Highlighting cells in one column from a formula valuein another co29 May 2008 19:25 GMT4
I want to highlight any cells in column A (Cutomer Name) when the If formula
(=IF(EM26>EN26,"Short DataPac's","Config is OK") in the cells from column EO
return a formula value of "Short DataPac's"
Worksheet autocalc with min function in error29 May 2008 19:24 GMT2
My worksheet has begun autocalculating cells I highlight with the min
function results instead of the normal sum total, in the status bar area.  I
don't know how this happend (was on vacation) and now need to fix.  Any
suggestions.
IF formula results not displaying29 May 2008 19:09 GMT1
I have an IF formula which will display the proper result in the functional
arguments pop-up but not within the cell itself.  I thought this was a simple
format error on the cell but I verified it is set as a number but still
displays "0" as the result.  Formula is:
calculate total number of items that meet 2 over multiple sheets29 May 2008 19:04 GMT5
I have several sheets setup from which I need to caluculate: how many of the
cells in a range meet both criteria.  It's setup something like the below:
 A  B  C  D  E  F....
1 y  y  n  n  y  y
unique records in specified range29 May 2008 18:59 GMT5
I have a very large table of non-unique items shipped; the table contains
“item id” and “ship date” columns.
I need to find the number of unique “item id-s” shipped in a given
timeframe, ex. 01/01/08 - 03/31/08
Return the filtered value into a specific cell29 May 2008 18:28 GMT4
I haven't figured out how to return the filtered value into a specific cell.  
I have a large spreadsheet where I filter 3 specific columns and I need those
3 specific filtered values (which are text) to be display in a different area
of the same spreadsheet in a specific cell.  ...
what function/formula do I use?29 May 2008 18:11 GMT2
I have one sheet in my workbook with raw data entered daily.  This
information includes employee number, and scores.  I want to pull scores from
that sheet to a different sheet based on the employee number in order to
calculate an average score.  This should be easy, but I'm ...
Hyperlink varaible substitution - How To29 May 2008 18:03 GMT10
My dilema is that I have a cumulative 3 month rolling report that takes input
from 3 seperate workbooks that contain 12 worksheets each.
The cumulative report cells have multiple hyperlinks (up to 9) back to the
individual workbooks. eg.
countif & subtotal functions29 May 2008 17:49 GMT3
I need the ability of both of these functions but combined.  I would like to
be able to count if All or Tops appears in my filtered list without having to
filter on the column that contains these values.
Removing Spaces In Cells29 May 2008 17:45 GMT9
Just wondering if it is possible to remove any SPACES/GAPS after text in
cells?
As I recieve data daily somtimes has gaps at the end of the text.
This text gets copyed and pasted into another spredsheet where a script is
is there a way to show what each cell links to?29 May 2008 17:44 GMT1
i have created a massive document containing 15 spreadsheets, some cells are
linked on multiple sheets and i wanted to know if there was a way to click on
the cell and it would show what other cells have it linked in their formula
Request for formula to refer some letters from Cell29 May 2008 17:42 GMT8
COL-A                             COL-B
00XA10010253                      5
00XXXA10012267                  1
00XA20045682                      2
Adding new data to tables and charts in excel sheets from 97/200329 May 2008 17:42 GMT1
I would like to be able to add my new data for 2008 to existing tables and
charts started in 2004. I can add the tables but then can't get into the
charts to change the heading . Also, I am unable to use the redo/undo button.
Appreciate any help you can offer.
Excel-how to link source workbook to copy of destination workbook29 May 2008 17:36 GMT1
I have two source workbooks that are linked to a destination workbook.  I
want to make a copy of the destination workbook and retain the links to the
two source workbooks.  Then I want to change the name of the new destination
workbook and retain the links to the two source ...
Advanced Probability.29 May 2008 17:36 GMT10
   I have a set of data that is 14 cells.  I want to find the probability
that the average of 5 randomly selected cells out of these 14 is over a
certain point.  HOW?!
 
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.