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 / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Is there a formula to hide/ display row based on cell value in Exc14 Sep 2007 21:33 GMT2
Excel 2003.
Is there a formula to hide or display a row/column based on the value of
another cell?
Find Function14 Sep 2007 20:26 GMT2
Is there any way to integrate the "Find" Dialogue box right into the
Excel file such that it is always visible?
I want users to be able to find a file based on a key word entry (much
like they would do with ctrl + F).
Formula14 Sep 2007 20:26 GMT1
I have a column that accepts dates (8/14/07). some of the cells don't have
any dates cause there is no need. I am trying to use an if statement
referring to this column to perform a mathematical function.  what i have is
=IF(C7=C6,SUM(Z7-Z6),"").  If works fine but when both ...
Excel memory not working14 Sep 2007 19:50 GMT2
My excel 2003 sheets are not automatically calculating formulas any more. I'm
not sure what happened. For example:
if I add:
200
How do you use sumproduct to return specific cell data?14 Sep 2007 19:42 GMT2
I have the following scenario:
A               B           C               D            E
1Hotel#     1Job#     2Hotel#     2Job#     Staff#
101            6001       100           5002       231356
Pulling info 2 cells and putting it in one14 Sep 2007 19:24 GMT3
I have two separate cells, one in worksheet 1 and another worksheet2. I would
like to make it so when I enter info in either of them it will automatically
populate a cell on worksheet 3. I would like the cell in worksheet 3 to pull
the info from either cell automatically in ...
Refering to a named range in a chart: 200714 Sep 2007 18:52 GMT1
Excel 2007: Working on a dynamic chart with named ranges. Trying to use the
following formula in my chart (in the 'Chart Data Range:' box):
=SERIES('Tot Revenue'!$M$4,TotRevenueYTDlabels,TotRevenueYTDvalues,1)
...but I am getting an 'Reference is not valid' error. I have checked ...
Expanded view of Validation List14 Sep 2007 18:38 GMT2
I have a problem viewing the entire content of a validation list I have
created in one cell, is there a way to make the entire contentvisible when
you click on a validation list? Thank you in advance.
Lookup based on 1st non-blank cell14 Sep 2007 18:30 GMT3
This should be easy but I'm having problems.  Data looks like this.
          Jan      Feb     Mar     Apr.........Dec
John                10        5         6
Mary                           2         4
Match function problem14 Sep 2007 18:02 GMT3
I have a workbook in which one worksheet contains data for several companies,
and the second worksheet pulls the data into a report using data validation.  
I am using an index/match formula to pull the name of the company that shows
up on the report, which worked fine for quite ...
comparing two list and need to find exact in both lists14 Sep 2007 17:58 GMT1
I need to compare the data in todays list and see if it was in yesterdays
list and if so bring back a true otherwsie false value
How to make a Let statement in Excel?14 Sep 2007 17:42 GMT2
I have a list of dates in a column, that is sorted by name and then date.  
The dates vary, but in assending order for each person.  I have also filtered
the data by determining which dates would be sequential, using a break of two
days - ie-weekend, as sequential periods.  I ...
Percentages14 Sep 2007 17:10 GMT2
I have a group of building that equal 911,815 Gross Square footage
Each building has a set gross square footage, one is 115,325 GSF
How do I figure what percentage of the total gsf  each of the building
come out to be.
have cell in sheet 1 look up last row of column 'x' in sheet 214 Sep 2007 15:20 GMT4
I have a summary table in sheet 1 that needs the totals from other sheets in
the workbook. the totals on the other sheets totals are on the last row of
the sheets however these rows constantly change.
Is there a way i can tell exceel to look at column b in sheet 2 and always
Create a printable FORM14 Sep 2007 15:14 GMT2
I need to create a FORM that prints data rather than enters data - odd I
know.  The forms are certificates required by regulation.  So, data is
entered into a table and then merged into a FORM that is printed on the print
command.
 
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.