| Thread | Last Post | Replies |
|
| Count unique numbers | 19 Sep 2007 12:04 GMT | 2 |
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 month | 19 Sep 2007 11:52 GMT | 3 |
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 hours | 19 Sep 2007 11:51 GMT | 8 |
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 GMT | 2 |
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 reference | 19 Sep 2007 10:00 GMT | 2 |
I need help to create a formula: Invoice Amount: ( 10,000.00) Less Fee: x Less Insurance: ( 136.32)
|
| Lookup | 19 Sep 2007 09:50 GMT | 3 |
Country Month Value Germany 1 100.00 Germany 5 250.00 UK 7 400.00
|
| CountIF Q | 19 Sep 2007 09:20 GMT | 6 |
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 name | 19 Sep 2007 08:30 GMT | 3 |
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 Table | 19 Sep 2007 04:10 GMT | 1 |
Table 1 A B 1001 166 1002 126
|
| Double Lookups | 19 Sep 2007 03:53 GMT | 3 |
Country Product Value Germany Car 1,500.00 Germany Bike 200.00 Japan Bike 300.00
|
| How to Match to table | 19 Sep 2007 03:52 GMT | 1 |
A B 1001 166 1002 126 10021 132
|
| Consolidated Sheets | 19 Sep 2007 03:16 GMT | 1 |
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 GMT | 1 |
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 GMT | 2 |
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 template | 19 Sep 2007 02:07 GMT | 1 |
I would like to create a formula that creates a unique identifier (invoice #) for sequential invoices.
|