Threads Replies Last Post 837 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Sorting Numerically Pleas help. I have a spreadsheet that was e-mailed to me and it is not sorting the data properly. I am trying to sort by decending order and this is what happens: 828 827 824 8,903 8,581 -8 791 786 773 758 75 746 738 732 726 719 7,964 How can I get it to sort with 8,903 being the first value and -8 being the last?? ... 2 28.09.2006 03:26:58 Eliminating Duplicate GROUPS of Styles Dear MVPs and fellow Excel Enthusiasts: I have a conundrum that I'm sure I could eventually figure out on my own, but you guys and gals are the best, and I need to get this done ASAP, so I figured I'd see if anyone had a macro or idea that I could implement right away instead of wasting company time educating myself (at least this time). Here's the problem. We manufacture athletic uni... 5 28.09.2006 03:04:54 Excel should let me unhide all sheets at once. As a frequent user of the Hide Sheet function in Excel with Excel files generally exceeding ten sheets, the ability to unhide more than 1 hidden sheet at a time would add tremendous time saving while using the Excel application. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the... 3 28.09.2006 02:38:27 XIRR 0.00% Return with Small First Deposit I need to be able to calculate a rate of return on deposits/withdrawals at uneven intervals, and keep running into a problem with XIRR when first deposit is small. Simplified example: -$100 1Mar98 -$1000 1Apr98 -$500 20Dec99 -$500 03Mar04 (+$X) 01Dec05 (Final Withdrawal) If final withdrawal (X) is larger than $1,901.00, then XIRR works well. If, however, final withdrawal is $1,90... 2 28.09.2006 02:00:05 Help with Excel Function Hello, I work for a small nonprofit who has a fee for service with our local Division of Rehabilitation Services providing Assistive Technology and Computer Access services. We generally provide services in one of the following categories: Evaluations Training Setup Technical Support I am trying to create a spreadsheet that will help us track our client services for these clients... 2 28.09.2006 01:48:02 Need Help Editing this Function... I got the function below to work in my spreadsheet. I'm now wondering if I can add something in here to enter the words "No Policy" if one of the rows does not exist under a given customer's data. If possible, would that go in the VBS code or the formula? note: See original post at bottom for explanation of what I'm doing. Thanks. ___________________________ try this function. bu... 1 27.09.2006 23:44:51 How do I round time I would like to know how to round five minutes to an hour and five minutes after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00) Thanks, Ana... 3 27.09.2006 23:44:01 "MAXIF" Equivalent function in Excel At work, base on several parameters, we assign risks (1=Low Risk, 2=Medium Risk and 3=High Risk) to each account. Customers may have 1 or more accounts. We have decided that the risk to assign to each customer will be the same risk of the account having the highest risk. That is, if a customer has 3 accounts (2 of them are rated 1 and one is rated 3), we will consider the customer having... 6 27.09.2006 22:56:59 Concantenate Social Security numbers currently parsed out I have about 10000 social security numbers currently parsed out in the following manner: Column 1 000 Column 2 00 Column 3 0000 I have tried to use CONCANTENATE to move them back over into one column, but the resulting number ignores all leading zeros currently in place. I need to have them set up into one column to use VLOOKUP. Can anyone help? Thanks! ~Mikki ... 4 27.09.2006 22:54:34 Excel 2003 Linest Function Bug The Linest Function has severe errors when curve fitting my data as follows: X Y 2499.89 -0.240420 4499.83 -0.432740 6499.77 -0.625070 8999.69 -0.865580 11499.83 -1.106090 13499.91 -1.298610 15999.74 -1.539220 18499.93 -1.779800 20500.05 -1.972495 21999.93 -2.116850 2499.89 -0.240400 4499.83 -0.432740 6499.77 -0.625070 8999.69 -0.865535 11499.83 -1.1... 12 27.09.2006 22:19:02 I would like to find the last day of a month Hi, Someone has suggested using the analysis toolpak. Is it possible to do this withouth the toolpak and do it using date functions. thanks suzie ... 4 27.09.2006 22:10:02 how do I format data from access to work in excel calculations? I am wanting to import data from a table in Access, which I've done, but need the numbers to work in Excel formulae. The numbers are importing fine, but the calculations are not happening, unless I go in to the Excel worksheet and retype the numbers...then the formula will work...but this is redundant any ideas how to format the data? or to prepare the data prior to importation? I need t... 5 27.09.2006 22:04:02 Conditional use of formulas Here is what I want to do (for example): If A1 > A2 then use the formula in B1 If A1 < A2 then use the formula in B2 Two different formulas that use the same variables. In the above example, one formula will always return a bad value so I can't just do both every time. Thanks!... 3 27.09.2006 22:00:38 Time Differential Error??? I am working on a timesheet in Excel and seem to have come upon a strange quirk/error. The timesheet is supposed to take two times, find the difference and then display it in decimal format. For example: A1 = 09:00 A2 = 09:30 A3 = 0.5 The formula I have in cell A3 for making this computation is: ROUNDUP((A2-A1)*1440/60,1) The idea of the roundup is so that as soon as you work mo... 5 27.09.2006 21:58:02 To delete rows when more than one cell is blank Since it took me a while to fine tune this macro, I thought I'd post it in case anyone else can use it. This macro selects 3 consecutive cells at a time and looks in those cells for values. If all 3 cells are blank, that row is deleted. If any cell in the selection contains a value, the row is left in tact. Sub DeleteRowsWithSomeBlankCells() Dim B As Long Dim X As Variant Dim Y As Lo... 5 27.09.2006 21:49:45 complex excel situation I need excel to take the date in column B and the percentage in column L and add the percentages for each month and separate the sum by month. I then need to create a line chart to reflect the data.... 5 27.09.2006 21:43:02 Need to sum "last 5" red cells I'm playing with some color vba from cpearson.com but can't seem to automate the process of summing the last x number of y colored cells. I'm having to change ranges every time I copy the formula over. Using the info on this page, http://www.cpearson.com/excel/colors.htm, or their own imagination, can anyone come up with a script for the above? My ultimate goal is to keep a running avera... 6 27.09.2006 21:27:02 Reminder in Excel? Hi All, Is it possible for excel to remind me with a pop up that i have to update a cell? Like i updated cell A1 rite now. Now i'll have to update the cell B1 after 1 hour. The sheet will always be active (minimized). Thanks in advance for any help. Gary ... 3 27.09.2006 21:26:05 Select End of list in formula? Is there a way to have a formula dynamically select the end of a list. For example I have a list in Col A that can range from 10 - 5000 entries. I want to dynamically sum this (without always just selecting the max size because there is information below the list). I also want to use a formula instead of a list or pivot table. In visual basic the selection would be something like: SUM ... 3 27.09.2006 21:24:10 excel conditional formuals I need help creating a formula for the following, if cell K12 is not divisible by 12 then return "OK" if its not divisible by 12 then return "not ok" Thanks for your help!!!... 2 27.09.2006 21:21:01 What is the keyboard shortcut 2 bring up the excel sheet tab menu? Is there a keyboard shortcut to bring up the excel sheet tab menu (Insert, Delete, Rename etc.) without right clicking the mouse over a tab? ... 4 27.09.2006 21:14:48 RE: Need big help with look up....is this possible I got the function below to work in my spreadsheet. I'm now wondering if I can add something in here to enter the words "No Policy" if one of the rows does not exist under a given customer's data. If possible, would that go in the VBS code or the formula? Thanks. ___________________________ try this function. but it depend on that ur custumernames are in column A and the cell jus... 1 27.09.2006 21:03:33 SET UP AUTOFILL! Pleae HELP!! Job # Job Name Company Bid Amount Origin Date Status 123 1st floor ABC Co. $5,000.00 09/22/2006 J The above are columns on a spreadsheet. If a cell in the "Status" column is "J", I need the information in that row to automatically copy to other worksheets. When the information does copy, I need it to go to the next available row. ... 1 27.09.2006 20:54:01 Urgently need help with a formula!!! Hello, I'm badly in need of some help with an excel formula. Essentially I need to check to see if the value of C7 is "Y" and if so for the formula then to look at D7 through to J7 and look for a value of "Yes". the total amount of "Yes" boxes should then be multiplied by J5 and the result shown in L7. It is for the purpose of a timesheet, I'm trying to calculate fuel allowances The Val... 7 27.09.2006 20:50:01 copying worksheets in a workbook limit? I have routine that updates previous workbooks by copying sheets within the new workbook and getting the old sheet information. Everything works great, but for some reason after more than 45 sheets are copied it errors out. Some of my workbooks contain over 100 sheets. Is this a memory thing or limit thing?... 2 27.09.2006 20:41:02 837 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>