Threads Replies Last Post 837 Pages: <<  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  36  37  38  >>   Count consecutive absences with a limit I have an attendance roster for the month and want to count the number of absences. The problem I am having is that I can only count 5 consecutive absences at one time. They can have 7 consecutive absences for one period and then another set of absences for 5 days. That totals to 10 allowed absences and 2 unallowed absences. How would you run a function to do this calculation automatically. ... 7 20.09.2006 14:20:27 Count Filtered Visible Items that Match Numeric Criteria between two ranges Hi All, I'm using the Formula below to give me a static count of numeric values that fall within a specified range; say 50-75 inclusive. These ranges are housed in cell X$1. The Named Range "Data" is a dynamic 9 column range spanning many rows. Named Range "Data" is defined as =OFFSET(Sheet1!$H$15,0,0,COUNT(Sheet1!$H:$H),9) Static Count: =COUNTIF(Data,">="&LEFT(X$1,2))-COUNTIF(Data,... 5 20.09.2006 17:39:31 No change in result cell I have a figure in one cell (cell c1) which is linked to another input cell (cell c2). However when I change the cell c2, the result in c1 doesn't change. I have set the Calculations under Tools => Options as Automatic, could there be other reasons which triggered the un-performance? thanks... 2 20.09.2006 17:20:02 Unknown number format I've never had this happen before. I am using a product called Monarch to pull numbers out of a ASCII report and drop them into an excel sheet. I've been using this app for 11 years without this problem. In excel, I'm trying to use the SumIf function to add all numbers that apply to specific invoices. The problem is this: I'm getting a result in the SumIf function that looks like s... 2 20.09.2006 17:17:02 need to merge 3 worksheets into 3 pages. how? I have a file that I converted to an Adobe pdf file from Excel worksheets Now the manager wants me to take the 3 Excel worksheets and combine them into 3 pages without making 3 separate files. How do I do that? Can anyone help today? Thank you. Your help is much appreciated. ... 5 20.09.2006 17:14:01 I want to take a date 2006/02/10 & break it into separate columns ... 4 20.09.2006 17:13:07 How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? ... 4 20.09.2006 16:52:48 Cell shows formula eg ='Sheet21'!F3 instead of result I have a problem where when I insert a formula such as ='Sheet21'!F3, the cell shows the formula, instead of the result. This isn't consistent apparently. I have managed to copy the formula from another cell that works, but when I then change the cell ref (e.g F3 to F4 in the above example), the cell displays the formula again, instead of the result. Cell format is "Text". Is this a cell... 2 20.09.2006 16:27:52 Feeds from one sheet to another Hi, My goal is to have an excelsheet summarizing the activities over time of all departments in my company. The sheet would work as follow. On a "detail" sheet, users would input details of projects like: start date, subject, end date, person responsible...This information should directly feed another sheet called "Overview". This sheet would visually show all entries in the "detail" ... 2 20.09.2006 15:24:51 In excel missing macro "excelprecedents"? I am trying to use the Formula Auditing and get the error msg listed above.... please help... 1 20.09.2006 15:18:02 compare two columns within a worksheet, then highlight duplicates ... 2 20.09.2006 14:47:31 changing cell background color How do you set up an excel spreadsheet so where data is changed in a cell the color of the background changes?... 2 20.09.2006 14:28:01 How do I write formula to conditional format using =if(and(or) I need to compare the values in two cells, A1 and B1, I wish to put the conditional formating on cell b1. I need to determine if A1<0 and B1>0 or if A1>0 and B1<0. If either of these two conditions occur, I need the cell of b1 to turn yellow. I have tried using =if(and(a1<0,b1>0), =if(or(and(a1>0,b1<0), ??????? Any assistance would be appreciated. Thanks! ... 5 20.09.2006 13:57:02 Function to calculate based on a portions of a number How would I write a formula to produce various results in differant cells based on a portion of a number in another cell. Excel 2003 Cell A contains a variable number. Cell B also containes a variable number. I need to calculate: Cell C results need to be based on 1/3rd of Cell A x Cell B, if Cell A is evenly divided by 3. This part is not a problem (B/(A/3). If Cell A can't be evenly... 7 20.09.2006 13:56:02 Can I add a percentage formula to an IF statement? I would like to me able to add percentages to an IF formaule allow for a margin of error, say 10%. If anyone knows a way round it be much obliged. the cell reads "=if(H2<=10%, "TRUE", if(h2=h3, "true", if(h2>10%, "false"))) Thanks Abs... 5 20.09.2006 13:48:02 cut and paste macro I have 30 rows of numbers the range is: d6:g35, j6:m35 (with h6:i35 blank). Each week I copy and paste one row of numbers to c59. Can you provide a macro that will copy and paste the one row only for one week. Then, when I run the macro again the next week it will copy the next row down and paste it to cell c59. Thanks. Wallyb ... 6 20.09.2006 13:15:03 Fiscal quarters for two years... Here is what I am trying to do: I have a sheet where I need to reference a date and determine what fiscal quarter it is. Here is what is causing me a problem: I need to include fiscal year 2008 and our fiscal year starts in April. I had been using the formula (="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{4,1,2,3}) &"07") to break dates down into quarters but that of course will not work when I rol... 3 20.09.2006 13:08:09 Active range/selection? Hi, I would like to have a macro which picks up my selected range in a workbook, similair to the activecell. So when I select a range in my workbook, it will be set as range in my macro. I've tried active.range but this doens't work (something like this: Set dd = Active.Range). I can't find it in the list properties/methods in vba. Could somebody help me? Thanks in advance. ... 10 20.09.2006 12:35:27 finding differences between 2 worksheets I have a worksheet consisting of various information, including invoice numbers. I receive this worksheet weekly and each week, some invoices will have been paid so they won't appear on the next copy of the worksheet. what is the easiest way of asking Excel to show those invoices which no longer appear, which means they have been paid? Any urgent help would be appreciated. Thank yo... 3 20.09.2006 12:14:02 Help w/formula to add 1 year to cell (date done) date due? Can someone help me with a formula that would allow me to put today's date in one cell (date done) and then add one year so that the next cell would come up with the date one or two years from now (date due)? Thanks GregJ... 4 20.09.2006 12:05:01 Can anyone help, with a formla Hi, I have a code, obviously! anyway i am trying to run it but i keep coming back with compile error sub or functions not defined. Here is the code Sub Start() abort_op = False 'Sheets(1).Activate Application.StatusBar = "" UserForm2.Show Application.Wait Now + TimeValue("00:00:02") Sheets(1).Select With Application .Calculation = xlCalculationManual .ScreenUpdatin... 2 20.09.2006 11:02:35 Sorting data into different format.... http://www.neilcarden.co.uk/example.xls Please see above file... I have a sheet (import) which is tha raw report from an application, I want to sort it in a similar way to LOOKUPs where it looks for the agents name, and returns the data as in sheet 2 (Formatted). How easy is this to do? as some days not all the codes will be used so the raw data will not always be in the same format regardi... 2 20.09.2006 10:57:01 TimeValue formula Hello, I have a TimeValue formula that works well for hh:mm, but I also need to expand this to hh:mm:ss, and I've tried several times to get this right, but can't seem to come up with the proper combination. Here's the one that works: =IF(F4="","",IF(F4<1000,TIMEVALUE(LEFT(F4,1)&":"&RIGHT(F4,2)),TIMEVALUE(LEFT(F4,2)&":"&RIGHT(F4,2)))) With the above formula in F5, if I enter 1234 i... 3 20.09.2006 09:27:12 Data from two sheets make up real time list in the new sheet?? Dear all and JBM I posted my problem two days ago, but I didn't have chance to check the answer until now. In the mean while the topic is already on the 3-4 page. Therefore I copied it once again at the end of this post. JBM answered me, but this is not exactly what I need. First of all, I would need to copy data in order to put it in the new sheet and I would like to have a “real tim... 8 20.09.2006 07:22:02 how to randomly select a name in a list and then the select the ne -- brightstar... 2 20.09.2006 07:09:01 837 Pages: <<  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  36  37  38  >>