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
Summing columns that contain letters29 Oct 2007 18:13 GMT11
I have a colunm that I want to sum.  The problem is that each entry
looks like this:
Total: 80.60
Total: 95.00
Input data in excel29 Oct 2007 17:52 GMT3
Hello guys,
we are going to input data very frequently, and we need an easier way to
input it.
I remembered i came up to an excel file were it had:
User Name Automatically Populate29 Oct 2007 17:41 GMT7
Hello,
Is there a way to automatically populate column Z with the user name who
puts text in column A?
Thank you
Date Range & Difference29 Oct 2007 15:51 GMT2
Hey Gigs... Need your guidance...
I need to find the difference between list of dates and the result should be
in months - for eg. 01-01-06 minus 31-12-06 is equal to 12 months.
I am sure its an easy fix but i think i am not using the right date format.
Counting Poll Results29 Oct 2007 15:43 GMT3
Is there a way to total all answers in one column.  For example, looking to
count all the answers that were "Yes" and all the answers that were "No"
Thank you
insert row / insert column command buttons29 Oct 2007 15:41 GMT1
My insert row / insert column command buttons in my tool bar are light in
shade and don't seem to be available.  Any reasons why?  As a side note, my
delete row/delete column command buttons are working fine.  Also, does anyone
know the command keys for insert / delete ...
What is wrong with this formula?29 Oct 2007 15:29 GMT3
Am i entering too many arguements or is there some other issue?
=IF(I30>0,"",IF(AND(I22="NOT APPLICABLE",I23="NOT APPLICABLE",I24="NOT
APPLICABLE",I25="NOT APPLICABLE"),"INVALID ENTRY",IF(AND(OR(I28="NOT
APPLICABLE",I28=0),OR(I27="NOT
Using the If function for text29 Oct 2007 14:45 GMT3
I am having trouble with the if function for comparing two cells with the
same text.  The function will not recognize the two cells as the same text
and sends back false than true.  Does anyone knows why this is happening.
Thanks
Grand totals on another worksheet.29 Oct 2007 14:19 GMT1
I have a worksheet for user data entry that consists of a few columns of
names and descriptions and monthly columns for quantities.  Users enter their
data and are free to create subtotals based on the text column entries to
evaluate their data.  Each workbook also needs the ...
split coloumn29 Oct 2007 14:14 GMT3
I have a coloumn with dates in the format dd-mm-yyyy
I neet to make a sub total for each change in month
I know it is possible to split the coloumn so I can get the month in a  
coloumn of its own, but how do I do it
Deleting multiple blank rows29 Oct 2007 09:33 GMT5
How do I delete all the blank rows throughout my workbook after unmerging
cells in Excel?  There has to be a better way than scrolling through and
deleting each blank row.  At least I hope there is :-)
Thanks
need formula29 Oct 2007 09:19 GMT5
Column a has numbers 1 to 12, column B has names.
I want a formula to change number in column A to zero or blank when I delete
the name in column B
Thanks
Link Complete Sheet29 Oct 2007 08:16 GMT6
I have to link complete sheet to another sheet
e.g. if i do the changes in one sheet, the changes should reflect in other
sheet.
How do i do???????????
Urgent Help!!!29 Oct 2007 06:20 GMT2
           I am prepairing master sheet based on 14 sheets. I need to copy
data from every sheet and paste it into the master sheet. So, is there any
shortcut or formula for the same to paste all the 14 sheets to a single
master sheet.
Multi thread in Excel29 Oct 2007 06:07 GMT3
Is it possible to do multy thread Programming with Excel. i.e. Assiging each
worksheet to a thread and run all threads simultaneously to reduce the time
for execution of a work book. If so Please help me out.
 
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.