| Thread | Last Post | Replies |
|
| Applying Percent Decrease Across Set Periods | 30 Mar 2006 05:34 GMT | 1 |
I have a column which includes dates when items were purchased. I have used the DATEDIF function to find the number of years between that date and today's date. I now want to decrease the purchase amount 10% for every year calculated via the DATEDIF function.
|
| [$-409] in Custom Number Formats | 30 Mar 2006 03:24 GMT | 1 |
I've seen [$-409] in some number formats and I was looking through the help files to see if I could find out what it means. I couldn't find anything on it. I've also seen [$-F800]. Does anyone know what these codes are for or where I can find info telling me what they are for ...
|
| Weibull paper in Excel - how? | 30 Mar 2006 01:38 GMT | 2 |
I want to create Weibull paper in Excel. The problem is the labelling at the Y-axis. I want to label probabilities (between 0.1 and 99.9%), but want to plot the transformed logaritmic data; calculated out of the probability via
|
| average data from diff sheets | 30 Mar 2006 00:23 GMT | 1 |
need a quick formulae help from you in excel. This is what am trying to do. I have 2 sheets (A and B ) . From sheet B am taking the average of (A1: B3) and want it in the A1 cell of sheet A. To put it concisely
|
| Highlighting or otherwise identifying top salesperson | 30 Mar 2006 00:09 GMT | 2 |
On a summary worksheet the YTD statistics are copied from the salespersons detail worksheets. From that date we can identify the top salesperson weekly. I have figured out how to find ther highest value in the sales column.
|
| How to Filter cells and save the file with certain criteria? | 29 Mar 2006 23:55 GMT | 6 |
Hello. I have a Excel file that contains a large list of Tracking Numbers. The tracking numbers are from two sets of order types- Internet orders and Mail Orders. Orders that are from the Internet are matched up with a order number such as
|
| IF statement help | 29 Mar 2006 23:54 GMT | 3 |
What im trying to do is, Calculate a Cell x say 0.5. If the result is a negative number, sho 0. If it is a positive number, work it out and show the answer. Jus tried, and cant seem to get it right for some reason. I dont want t
|
| Need help with an array... | 29 Mar 2006 23:54 GMT | 21 |
There's gotta be an easier way to do this.... I have a list of location names in column A (about 2500 total locations) Column B is that location's latitude
|
| Conditional Formatting help... | 29 Mar 2006 23:09 GMT | 3 |
This is a followup question to one I posted a few days ago with the title "How to change cell color based on content". Someone had recommended I use "Conditional Formatting." So, I tried but it didn't work out the way I expected.
|
| days between dates in a column | 29 Mar 2006 22:23 GMT | 4 |
I have a column (A) of dates and want the number of days from date to date to appear in the next column (B).
|
| formula for bonus or penalty | 29 Mar 2006 21:38 GMT | 2 |
students are required to complete a designated number of homework assignment, then receive a bonus or penalty for every additional or deficient home assignment. Andrea Carrion completed 9 homeworks, rather than 12, and thus has a 6-point penalty (2 points per each missing ...
|
| Excel on Each Screen | 29 Mar 2006 21:16 GMT | 4 |
I work with multiple monitors and enjoy the feature of being able to have a copy of Word on each screen to easily analyze & compare two different documents. However, it seems that this feature is unavailable in Excel. Does anyone know how to do this in Excel
|
| locking cell references $ | 29 Mar 2006 20:46 GMT | 2 |
i need to lock all my cell references in a long list of formulas. can do this without typing in $ before each value -- charse
|
| Macro Problem | 29 Mar 2006 19:56 GMT | 1 |
I am running into a problem when I try and run a macro that copies a sheet that has a pivot table in it and moves it to another folder and then copys-past special-values the sheet. When I try and run macros that do this I get an error message when the macro finishes processing
|
| Assign a numeric value to random text for sorting | 29 Mar 2006 19:39 GMT | 3 |
Calling all gurus. I'm attempting to create a self-sorting 'Standings' table that uses a whole wack of lookup tables to sort my March Madness pool by points standings, then alphabetically if two people are tied. The problem is, how does excel know which player comes first? I've been
|