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
Count unique numbers19 Sep 2007 12:04 GMT2
I have a spreadsheet in wich I have timevalues (in A3:A750).
I also have av timemark 1 to 6 (in H3:H750).
I need help with a formula that gives me the summing of how many unique
timevalues there is together with the timemark 1 or 2 or .... 6.
Count hours per month19 Sep 2007 11:52 GMT3
I have a spreadsheet where i need to count the number of hours and minutes  
spent working on products per month
In cell range 'H' i have the time spent working i.e. 00:40 (40 minutes)
In cell range 'P' i have the dates i.e. 15/09/07
Calculating hours19 Sep 2007 11:51 GMT8
I need to do a sheet where I put in a time, 7:15 for example in a cell. In
another cell I would enter 11:30 for example. The difference in time is 4.25
hours. What formula would I use to get this answer?
Thanks for any help
Nesting IF's and AND's - a bit of help please...19 Sep 2007 10:10 GMT2
Hi. I have 3 formula's which I would like merging into one?
=IF(AND(C3<$B$1,C3>1/1/1,D3=""),"N","")
=IF(AND(C3>$B$1,D3=""),"M","")
=IF(AND(C3>1/1/1,D3>1/1/1),"Y","")
Formula help in a circular reference19 Sep 2007 10:00 GMT2
I need help to create a formula:
Invoice Amount: ( 10,000.00)
Less Fee: x
Less Insurance: ( 136.32)
Lookup19 Sep 2007 09:50 GMT3
Country    Month    Value
Germany    1    100.00
Germany    5    250.00
UK    7    400.00
CountIF Q19 Sep 2007 09:20 GMT6
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()
Thanks
Display cell name19 Sep 2007 08:30 GMT3
Say in cell B4 contains text "John". Based on text "John", I'd like to
display "B4" (colomn and row of cell that contains "John") in other cell. How
is the formula to do that?
Thanks.
Match Table19 Sep 2007 04:10 GMT1
Table 1
 A           B
1001    166
1002    126
Double Lookups19 Sep 2007 03:53 GMT3
Country    Product    Value
Germany    Car    1,500.00
Germany    Bike    200.00
Japan    Bike    300.00
How to Match to table19 Sep 2007 03:52 GMT1
  A            B
1001    166
1002    126
10021    132
Consolidated Sheets19 Sep 2007 03:16 GMT1
I've consolidated some spreadsheets, but Im trying to get my consolidated
sheet to "read" from my originals? How can I accomplish this?
Is it possible to set up an AutoNumber in Excel?19 Sep 2007 02:22 GMT1
I have created an Invoice form in Excel (for an assignment) and want to use
AutoNumber for the invoice number - is this possible?
Signature

Chris

How do I changet a text telephone number (xxx) xxx-xxxx to xxxxxx.19 Sep 2007 02:20 GMT2
I have a data export that lists telephone number in a (xxx) xxx-xxxx format
that I need to change to a number format without spaces or commas.  Anyone
know of a formula to apply to a column of text numbers to make such a
conversion within a spreadsheet?
how to create sequential invoice numbers from a saved template19 Sep 2007 02:07 GMT1
I would like to create a formula that creates a unique identifier (invoice #)
for sequential invoices.
 
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.