| Thread | Last Post | Replies |
|
| count and return pair numbers | 28 Jul 2007 16:51 GMT | 14 |
What function can I use to return the number of pair or impair numbers in a row A B C D E F Row 1 2 6 9 11 16 20 Pair number = 4
|
| Finding the earliest date from a range of cells | 28 Jul 2007 16:46 GMT | 2 |
>From a range of cells in multiple columns with dates I am trying to get the earliest date listed in my summary row. I have managed to do this using the MIN function however I am having two problems with this, if the users have entered text in these
|
| How to auto update a spreadsheet with data from a .xls file? | 28 Jul 2007 15:24 GMT | 1 |
I am saving a banking statement to a file in xls format and want to be able ot open the spreadsheet and have the data already loaded. Also, I would like to keep appending the file that the banking statement is saved to if you have any ideas on that.
|
| First day of month | 28 Jul 2007 12:42 GMT | 7 |
A cell in an Excel workbook contains a date. I want to write macro code to generate, in another cell, the date of the first day of the next month. I was going to use the Excel EOMONTH function, but Excel 2002, does not seem to support the function. I can generate the date using ...
|
| insert images in a protected worksheet | 28 Jul 2007 11:31 GMT | 10 |
hello.. please help me.. How do i insert an image in a protected woksheet? thanks
|
| seperating data from one cell to multiple cells? | 28 Jul 2007 10:27 GMT | 5 |
I have a worksheet open that has 250 rows of data, all the data appears in one cell and is seperated by commas, can anyone tell me how I can get excel to seperate the data divided by commas into individual cells, having seperate columns?
|
| Finding the earliest date from a range of cells | 28 Jul 2007 06:50 GMT | 1 |
>From a range of cells in multiple columns with dates I am trying to get the earliest date listed in my summary row. I have managed to do this using the MIN function however I am having two problems with this, if the users have entered text in these
|
| Function refering sheet index. | 28 Jul 2007 05:27 GMT | 4 |
I have some 100+ sheets in a file. in the first sheet I want get a consolidated information. say count the entries in column-D. how can I write a funcion indipendant of the sheet name.
|
| Combining worksheets with common column but different number of ro | 28 Jul 2007 04:38 GMT | 3 |
I have two excel spreadsheets, one that is complete with product part numbers, item descriptions, prices, quantity, photo url's, etc. I get a daily update in the form of a spreadhseet with part number and quantity only. Is there a way that excel can recognize that column A in ...
|
| How do you calculate a negative percentage | 28 Jul 2007 04:31 GMT | 2 |
Sorry if this is a dumb question... All I am trying to do is calculate the difference between two numbers, as a percentage. I tried what the "help" suggests of "=(D4-C4)/ABS(D4)" yet the percentage is off by a few points (not just rounding errors) each time. I
|
| Date issue | 28 Jul 2007 04:22 GMT | 3 |
Writing a function in Excel 2003 that starts"=IF(<11/30/2006..." When run the function returns a false result, however if the date is entered as "=IF(<39093", the "serial date" that Excel uses it returns a correct result. Shouldn't the function be using the "human friendly" date ...
|
| negative and positive sums | 28 Jul 2007 03:12 GMT | 8 |
How do I create a formula that subracts A1 from A2 if A2 is a negative number, but adds A1 and A2 if A2 is a positive number? Thanks for your help
|
| vba | 28 Jul 2007 01:40 GMT | 3 |
does anyone no how to answer a proposed question like this. I was looking through some old papers for next years module in this. As im doing this as a module on my course and I want to get a head start in understanding how to write this in essay formats.
|
| Grades in Excell 2007 | 28 Jul 2007 01:32 GMT | 1 |
I have a grade column with daily activities and homework averaged. I want to take that average and show it in a letter grade based on accumulated points. What should I do?
|
| Formula to determine selling price with cost known @ X margin? | 28 Jul 2007 01:16 GMT | 3 |
I'm trying to create a formula in Excel to project a selling price of a product using the margin I wish to make as the variable. Any help would be greatly appreciated. Thanks.
|