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 / March 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Two People Using Same File24 Mar 2006 21:24 GMT1
It it possible for two people to use and update/save the same file
located on a network at the same time?
Thanks,
CRW
Exceptions to =Countblank function24 Mar 2006 21:22 GMT3
Hello..I am creating a worksheet for the work schedule for X number of
employees.  I have the worksheet arranged so that if someone has a day
off a value of "o" is inserted into a calender type schedule.  I then
use a =countblank function to add up the blank spaces (which indicate
copying sheet references that refer to a cell in the preceding she24 Mar 2006 20:51 GMT1
I need a cell reference to another sheet to move as I create succeeding
sheets.  E.g. I name a sheet 03-22-06.  The next day, I copy this sheet to
create 03-23-06 and on this sheet I reference cell A1 on the 03-22-06 sheet
(i.e. =+'03-22-06'!A1).  Now, on 3/24, I create sheet ...
Auto fill dates24 Mar 2006 20:45 GMT1
I have a time sheet with a 'date' column for entry from a1 - a7.  Once the
first date in a1 is entered (mm-dd-yy) is there a way to have the remaining
cells auto fill the sequence of dates?
copying with a Macro24 Mar 2006 20:45 GMT2
    I need some help! I have a workbook which has four sheets, the two that
matter are named work in progress and receipt. My problem is that I need to
copy the name, address, city, state, and zip code from the in progress sheet
to the receipt sheet, one at a time and place them in ...
Matching Text24 Mar 2006 20:45 GMT5
it seems like a simple problem, but I can't find an answer anywhere.
Worksheet One
Column A        Column B
Apples             Little Apples
Display Rows From Sheet1 In Sheet2 (Import)24 Mar 2006 20:40 GMT1
I have Sheet1 and Sheet2.  I want, in a specific starting cell, to show the
rows/columns from Sheet1 that match a single condition (whether or not a
month/year of a date matches a specified date).  Is this possible?  Thanks,
Mythran
Conditional Formatting Help.24 Mar 2006 20:29 GMT1
Can anyone help.
I have a database with about 6000 entries in it. What im trying to do
is to be able to put new records in and then if any get duplicated on 2
seperate columns it would bring it to my attention.
Excel sum, conditional, if??24 Mar 2006 20:21 GMT3
I have  columns A and B. I want A5 to display SUM(A1:A4), only if
SUM(B1, B3) is 0 or 1 else the value in A5 should be zero.
Is there a formula for doing this? Would appreciate any help.
Thanks
special case of sumif24 Mar 2006 19:41 GMT4
I am trying to do a sum but based on a substring instead of the entire
contents of a cell. example, A1:A4={"monday, tuesday", "wednesday","
thursday","friday"} and B1:B4={2,4,1,5}. the values in column A may have 2
days in a single string and I want to add based on any one. ...
special case of sumproduct24 Mar 2006 19:18 GMT2
I need some kind of escape character in the criteria part of this function.
example, =SUMPRODUCT((A4:A15=("January"))*(B4:B15="Monday")) should also
count cells in B4:B15 where the cell contains both Monday and tuesday.
something like =SUMPRODUCT((A4:A15=("January"))*(B4 ...
russian excel vlookup24 Mar 2006 19:16 GMT1
Hi - I am trying to teach a colleague over the phone how to use the
vlookup function but he can't find it in the Russian version of excel
he's using - any one know what vlookup is called in russian language
excel? thanks if you can help!
Is there a way to create a toolbar icon for 'page setup'?24 Mar 2006 19:15 GMT2
Long ago I created an icon on my tool bar for 'Page Setup', so I wouldn't
need to go File>Page setup, it is now gone.  
Could someone tell me how to do this - I have forgotten.  
Excel Math problem24 Mar 2006 19:08 GMT1
I have an excel spread sheet I'm using. I have found a math error in it on
one cell so far. If any one knows where I can send it to. That would be
great. It has never been fixed or found since it is also showing up in the
newer verions of excel. I have even let our enginners ...
Number to be like in colum A, if number in colum B and C  are like24 Mar 2006 19:05 GMT1
How can i get the number of column A to show if column B and C are like in
diferent rows?
    A            B            C                   D
1   33221     4131       4000             (value of A3)
 
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.