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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I retreive a replaced excel workbook?17 Oct 2007 05:14 GMT2
My office assistant asked if I wanted to replace a workbook that already
existed and I clicked on yes, accidently and I need it back desperately.
Please help
Check Boxes17 Oct 2007 02:58 GMT4
I have a workbook with multiple worksheets. On worksheet 1 I have 10 check
boxes (Cells A1 to A10) that, when checked, links the data in Worksheet 1
(Cells B1 to B10) to Cells B1 to B10 on Worksheet 2. Cell B1 on Worsheet 1 is
linked to Cell B2 on Worksheet 2 and so on. The ...
Unwanted dash16 Oct 2007 23:45 GMT5
sorry if this has been posted before, i didnt know what to search for.
I am sorting out my company invoice, in the sub total column i have for
example "=E24*F24" and so on, then at the bottom I have another sum
adding those up to give me the overall total.
Adding columns to an Excel matrix and listing them in the PT16 Oct 2007 23:44 GMT1
I have an Excel matrix that I need to add additional columns to.  When I add
the columns they do not show up in the Pivot Table List of items to be added
to a pivot table or report.  How do I make them visible in the PT list?
CountA, Subtotal and "move to the first cell in the next column"16 Oct 2007 23:30 GMT1
Help,
I am using the"CountA" Worksheet function to paste data from another
sheet into the 1st empty cell starting at "B2". It works fine all the
way to row 14 but it continues to row 15.
Excel 2007 :Standard Footer16 Oct 2007 23:21 GMT1
Can someone tell me if I can set up a standard footer that will appear
on every excel document that I create. Basically I want the footer to
appear on every new workbook that I create from scratch.
Thanks
match and insert from one workbook to another16 Oct 2007 23:16 GMT4
I have a project to match SSN's between 2 workbooks and insert columns from
one sheet to another.
Example:
File1
I have misplace my Excel 2003, 25 digit code, how do I get a repla16 Oct 2007 21:51 GMT2
How do I get Excel 2003 25 Didgit Product Replacement code?
SUMPRODUCT not working.16 Oct 2007 21:19 GMT2
Hi
I have the follwing grid
A               B              C                 D                   E      
      F           G
formula to find a value16 Oct 2007 21:10 GMT2
I have a spreadsheet with 2 worksheets, on the first worksheet I have 3
columns, column A has a number between 1 and 50, column b has a number
between 1 and 10 and column c has text string that varies. On the second
worksheet I have set up a grid with 1-50 in column A, and 1-10 ...
CREATING A FORMULA16 Oct 2007 20:56 GMT4
I'm hoping I can find someone who can help me create a formula to use in a
spreadsheet.
Let me explain what I am trying to do. I have two workbooks that I intend to
link so the end result in one workbook will appear in columns in the linked
Find and Delete Row16 Oct 2007 20:33 GMT1
Need some help...
I'm trying to find ANY text in a column and then delete the entire row.
In other words, if there is text in B3, B8, B16, etc., I want to find
the macro to find it and then delete the rows 3, 8, 16, etc.  These are
Deleting numerical values within a cell16 Oct 2007 20:10 GMT10
I have a column with numbers and text - I want to delete all numerical values
and leave the text intact.  Any help would be greatly appreciated.
Match Date/Time to Date list16 Oct 2007 19:09 GMT4
I have a Date/Time in A1 (mm/dd/yy hh:mm) and a list of dates (mm/dd/yy) in  
D1:D10.  I would like a formula to compare the date/time to the date list and
return "yes" if it is in the list and "no" if not.
Thanks
countif function using dates16 Oct 2007 19:06 GMT7
I want to calculate the number of entries in a column that are later than one
date and earlier than another.
This is what I thought would work, but doesn't:
=COUNTIF(M3:M158,">30/09/2007"&"<01/11/2007")
 
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.