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 / January 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
GOTO error reading cell ADDRESS18 Jan 2004 21:01 GMT2
I've run out of ways to try to get the cursor to highlight a particluar cell that is defined by the contents of a different cell.  In other words, I want to GOTO the cell that is named in another cell in which the destination cell is identified. The destination cell addresses ...
help with calculating a timetable in excel18 Jan 2004 20:18 GMT1
Look to build a timetable in excel using 8,9, and 10
minute intervals...almost there but not sure what i'm
doing wrong...any help you can provide - please email me -
thanks!
Literal appears in cell18 Jan 2004 20:00 GMT5
I have an Excel spreadsheet and when I try to sum a column the literal
appears in the cell instead of the sum.
For example, if I have 1,2,3 in cells A1,A2,A3 and this formula:
=SUM(A1:A3) in cell A4, instead of 6 appearing in cell A4 the literal
Copy Group rows formatting18 Jan 2004 19:48 GMT1
Any idea if there is a way to copy my group rows format from one sheet to another?  For example I want to group rows 6-24 and 26-38 etc.  But I want to copy this from 1 worksheet to 10 others.
Thanks in advance
Dan
Please help me writing this simple formula18 Jan 2004 19:18 GMT2
How can you look up for data in a particular cell and freeze that cell
while draging the formula to other cells. In need for example A2 and
A11 remain the same while I am copying this formula to other cells.
The problem is when I am copying this formula A2 and A11 will change
=VLOOKUP("a",table1,2,FALSE)     is not working for me  why?18 Jan 2004 18:25 GMT5
WindowsXP, and Excell 2002 (XP), Celeron 1gig
Something is wrong here.
I have rebooted. Twice
And rebuilt the notebook.
Unsaved text recovery18 Jan 2004 17:16 GMT2
Urgently need to recover text inadvertantly "not saved"
when spreadsheet closed. Is this possible?
Thanks for any help - desperate Medix
SUMIF for two conditions?18 Jan 2004 16:24 GMT1
I need to sum a range of values checking for two condtions.  I check a shift
and week number and based on both conditions sum the total hours.  I have
tried using the AND function without success.  I thought it might be
possible to join two SUMIF functions, one checking for week ...
teacher's questions18 Jan 2004 14:41 GMT7
I'm a teacher trying to make my life easier but…
Any help would be appreciated, thanks.
I have a few questions concerning a spreadsheet.
It is used to calculate pupils Levels (range 1-9) from their test
Sumproduct help18 Jan 2004 14:12 GMT4
Hi. I am doing a Lunch Detention spreadsheet for my
school and I have included 18 different classes on 18
different sheets, with all of the students from the
different classes  on their respective class rosters. I
Rounding problems18 Jan 2004 13:52 GMT1
I use excell to calculate the 18% tax deduction required
for construction workers and then subtract this from the
gross pay to achieve the net.
If the 18% tax calculation ivolves rounding (I have the
Refreshing pivot table drop down lists18 Jan 2004 13:45 GMT2
How do I get rid of old values in pivot table drop down
lists?  The original data has been deleted for months,
even years, yet, the pivot table drop down still shows
them and I have to scroll through the entire list in order
Delete Rows With no "F" in Them18 Jan 2004 12:58 GMT9
Hi All...
I would like to get a macro to work that would look through what is selected,
if it doest find a "F" anywhere in them, delete all rows in the selection that
have no "F"
Question for the Pros18 Jan 2004 12:57 GMT4
When you are writing complex nested formulas, do you type the formula
directly into the formula bar or do you use the function wizards?  The
reason I ask is that I always mess up the syntax when I dont use the
wizard for complex formulas.  I don't know if using the wizard is a
automatic fill-up columns18 Jan 2004 12:03 GMT4
Good day to all,
I have this spreadsheet for our weekly billings.
A       B           C         D      E
s/n  Description  Section    Code  Amount
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.