Threads Replies Last Post 1263 Pages: <<  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  31  32  33  34  35  >>   simple subtraction For each row of data, I want to display the difference between the value in cell C of the current row, and C in the next row. eg where "x" is the current row: =SUM (C(x+1), -Cx) How do I create this formula ?... 8 12/14/2008 3:12:56 PM find duplicates looking for a way to check for duplicates in a range and say column is list of unique phone numbers is there are function that would display in a corsiponding cell to let the data entry know if there is the phone number is bring duplicated don't care about highlighting anything ... 6 12/14/2008 3:00:34 PM Setting up "Progressive" Formulas between worksheets/files Please bare with me as I try to explain what it is I am trying to do, if you understand my intention you'll understand how you're asving me HOURS, so for that, Thanks ! I have 2 workbooks, lets call them addons2 and addons3 :) I am trying to input data in to one workbook and have formulas calculate averages. Another quick explanation: I am calculating sales for my employees in 4 catagor... 3 12/14/2008 8:01:12 AM Counting occurrences of products in a master list I want to count the number of occurrences of a small list of products that appear in a large (2,000+) inventory list. I used the countif function but there's a specific situation where my formula fails. Here's the example of the product numbers in the small list: R6AA RM8B RN7A RN7AA RN7A/5 RN7AB The product numbers in the master inventory list may be 3 to 12 characters in lengt... 8 12/14/2008 6:17:34 AM how to search vertically then count horizontally in excel Hi I'm trying to work out how to FIND an instance of a name on the vertical axis, then count any iinstances of a particular text on the horizontal. i.e. Joe bloggs is in cell A1 on sheet 1 then on sheet 2 he is in cell A10. Sheet 1 shows what days Joe worked and was on holiday, as does sheet 2. Sheet 3 "the holiday planner" counts each holiday for joe using the formula countif. which re... 3 12/14/2008 4:19:01 AM Does anyone have an example data to base a Pivot Table on? I am trying to practice creating a Pivotal Table but do not have any multiple sheet data.... 2 12/14/2008 1:16:28 AM Resizing an activex checkbox control We had placed an Activex Check Box control on our worksheet. However, the actual check box is a tiny little thing. We need to enlarge the size of the actual check box (not the text, not the object border). We have other worksheets we have designed with larger checkboxes. However, we cannot remember how we got the larger "Box". Changing the font size doesn't seem to affect the box si... 3 12/13/2008 10:29:33 PM sumproduct() help Hi Greetings of the day to you. any help this work good, =SUMPRODUCT(--(THREED(Sheet2:Sheet3!C6:C23)=C6),--THREED(Sheet2:Sheet3!D6:D23)) but unfortunately, the sheets have different ranges for summing. like (sheet2!d3:d550)+(sheet3!d3:d750) instead of --THREED(Sheet2:Sheet3!D6:D23) and look range as THREED(Sheet2:Sheet3!C6:C750)=C6 ... 2 12/13/2008 7:30:01 PM Pivot Table Hiding Totals = Zero Hello all: I have a pivot table that sum the sales of every seller during a period of time as you can see below, I´d like to know how to achieve the pivot table doesn´t show the sales people when the total sum of sales is cero (automatically) Sales Men Total Sales Man 1 25 Sales Man 2 7 Sales Man 3Sales Man 4 12 Total general 44 I´m using Excel 2003 Thanks in advance. ... 1 12/13/2008 5:05:44 PM Excel Drop Down Lists Help I'm attempting to make a drop down list that selects one particular item and will sort the excel spreadsheet by the selection. For example: If my list includes Fruit, Vegetables and Other, when I select 'Other' the only entries that show are 'Other'. Any suggestions? I've scoured the Microsoft Excel help pages without any luck.... 2 12/13/2008 4:54:36 PM Save As Macro Office Basic 2003 - XP - Excel I need a macro that will bring up the "Save As" window when button is selected and to also insert a particular cell value in name field of "Save As" window, then if possible to also save and exit all with this one macro. I am a novice at this so a little extra explanation with it would be great. I've been trying to use this macro that was posted but hav... 3 12/13/2008 4:35:58 PM COUNTA Function I have the following list. Column A has the below formula and column B contains a list of Names ColumnA Column B 1 ABCD 2 EFGH 3 IJKL 4 MNOP "" MNOP 5 XYZ I am using the following in Column A =If(B1="","",counta(B$1:$B1)). This is copied all the way... 5 12/13/2008 4:01:01 PM VLookup that returns two separate cells instead of only one Hello, I have a table of 76 items (A2:D77). I want to key the item code into cell F2 (of the same worksheet) and have Excel populate two pieces of data to the right of F2 (this would be G2 and H2), that corresponds to the item code typed in cell F2. The original data is contained in A2:D77 so I have no problem doing this when I use Vlookup but the formula only returns to data in the... 4 12/13/2008 2:26:04 PM Value Axis Adjustment I created a Gnatt Chart with 8 activities. The times on the values axis are listed as 3:50 AM, 4:19 AM, 5:16 AM, 6:14 AM, 6:43 AM, 7:12 AM, 7:40 AM, 8:09 AM, 8:38 AM, however since my activities take place between 5:30 AM and 8:15 AM, I wanted to decrease the time that is displayed on the chart dramatically. For example, I would like to see the time on the values axis displayed in 5, 1... 2 12/13/2008 11:32:49 AM Can’t_get_column_to_format Hi all. Need your expertise as I am pulling my hair out. I am exporting information into an excel sheet but it will not allow me to change the date value that comes over so I can sort the information. I have tried formatting, copying and paste special with values only, paste special with multiplying by one from a cell that was formatted as number and nothing. I looked for any conditional... 5 12/13/2008 2:17:06 PM Concatenation and delimitter In building a string based on THREE (or FOUR maybe in the future) columns using CONCATENATE I am putting a "+" between each columns values. Problem is that sometimes a value is blank, and therefore I don't want extra "+" in the result. Please help me get "I Want" string results without a hideous nested if statement. It is acceptable to add columns which store interim values to help bu... 6 12/13/2008 4:14:00 PM I need a difficult function I need help. Im trying to put my jobs production incentive pay on a spreadsheet. I need a funtion for this: 10000 or higher = 65% of $160 which is $104 9000-9999 = 50% of $160 which is $80 8000-8999 = 35% of $160 which is $56 7000-7999 = 20% of $160 which is $32 6000-6999 = 10% of $160 which is $16 0-5999 = 0% of $160 which is $0 Please help!!... 5 12/13/2008 4:28:02 PM Changing GPA to Ltr Grade I have this spreadsheet that merges onto a Transcript in Word….We have Student Names, Class Dates, Grades for Classes per Terms, etc.….They have been manually figuring the GPA,,,,I set up some formulas that has helped, but need help on the more difficult ones….someone helped me last week with the following formula (finding and matching the Grade to return a GPA. THANKS…….Now I... 10 12/13/2008 4:43:11 PM Here's one for the techies unless a macro will do it. I have a workbook on a network drive that more than 1 person uses. If the workbook is open to more than 1 person at the same time, how can it be updated in real-time so that each can see what has been input? Also how can I get round having to save it under a different name? If one exits excel then the prompt is to save, but when you do, it requests that it is saved with a different name. ... 9 12/13/2008 5:36:23 PM Forgot I'm using Excel 2007.... 5 12/13/2008 9:09:00 PM Count Text Across Multiple Columns I am trying to count text and number in in column example-I need a function that will count across two columns If the training hours =8 and Taining Type =CT3 or CT4 Results Would be =1 If the training hours =10 and Taining Type =CT3 or CT4 Results Would be =2 Column-1 Column-2 Training Hours Training Type 8 CT3 10 CT4 8 ... 9 12/13/2008 9:35:03 PM dynamic summary report i have a detail 20 salespersons' total sales volume on 100 products for Jan to Nov 2008. How do I create a dynamic summary report to sum up the total sales volume per sales person for a particular month? I.e. if i specify January in cell B2, the report will show the sales person in row under first column and their respective January total sales volume in second column of the report.If i chang... 12 12/14/2008 2:45:48 AM Count Unique Values Greetings, I am really stuck would really appreciate some help. I want to count the number of unique values in column B, but only if column A contains a value. A B x abc abc x def x x ghi Column B must also contain a value (not blank). So that means there are three unique values in column B in the above table. I was expecting to find a "count unique" funct... 5 12/14/2008 6:16:24 AM Sorting by Frequency? Is there any way to sort a list based on frequency? I have a large spreadsheet that has a alpha code in one column. I would like to sort the list so that the most frequent entry is at the top. Any suggestions on how to accomplish a sort other than alphabetically? Thanks Irie... 5 12/14/2008 8:34:51 AM trying to add to a if statement I have this statement in B3; =IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3) I need to add; if C3 >0 then B3 = C3 can this be done along with the first "if" Thanks in advance...David D... 4 12/14/2008 1:55:00 PM 1263 Pages: <<  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  31  32  33  34  35  >>