Functions

HOW DO I CALCULATE WEEKLY PAYMENTS THAT VARY BY LENGTH OFTHE MONT
I make weekly payments for my son's school, every week is the same amount but the total per month may be different since some months have more weeks than others...How do i put that in a formula?? ... 1 Apr 2010 15:47

VBA to sidestep popups...
Hi All As part of a macro , I use this command : ActiveWindow.SelectedSheets.Delete On each occasion I run it , I get a popup which ask me if I really want to delete the relevant sheet. This brings the whole macro to a halt. Is there a command I can use to avoid the popup , and have the macro perform ... 1 Apr 2010 15:47

Absoute Cell Ref Changes When Inserting New Row in Referenced Shee
I have an application where I need to update cell B5 in Sheet 1 with a cell value from a specific cell (C4) on Sheet 2. The issue is that in this instance, I need to be able to select Row 4 in Sheet 2 and insert a new row each month, so that I can record new data in Row 4 for the current month. I thought that b... 1 Apr 2010 14:39

I want to show only the first three columns
I want to see only the first three columns and nothing else, no other columns. ... 1 Apr 2010 14:39

Conditional
Can someone help with this formula, or perhaps come up with a simpler version? =IF(E2="Startup","Yes",IF(E2="Enrollment Open","Yes",IF(E2="Enrollment Closed","Yes",IF(E2="Treatment","Yes",IF(E2="Startup","Yes",IF(E2="On Hold","Yes",IF(E2="Terminated,"Yes",""))))) ... 1 Apr 2010 14:39

Dup check 2 columns - need it to delete correct one
Using Excel 2007, I have a two column list with over 100,000 rows. Example: Jane Doe U Jane Doe John Doe John Doe U John Doe Jack Doe Jack Doe I want to run a dup check to make sure there is only one Jane, Jack or John Doe, but the copy I want to stay is the one with a U beh... 1 Apr 2010 18:01

How do I make first row sort in table
I am trying to sort a spread sheet and the first two rows won't. ... 1 Apr 2010 13:32

rearranging_names
hi all! i am having thousands of names in col A the problem is the initials are before the names..! for example as A.K.PRAVEEN C.GUPTA G.K.S.RICHARD M.PRAVEEN L.M.DAS and so on..! how can i convert the data with initials after the name in each cell like... PRAVEEN.A.K. GUPTA.C. RICHARD.G.K.S... 1 Apr 2010 15:47

how do I sort by picked-up date in Excel
I am a novice working in Excel. I am trying to start a new sheet and transferring information from the previous month. I only need the information on the equipment that has not been picked-up without having to redo a whole new document. ... 1 Apr 2010 12:24

Sorting in Excel
I have a list of various numbers and text that I want to sort numerically. Here is an example: T300 D9745 P50 565 007 0245 052 Problems: 1.Getting leading zeros to show AND be recognized. 2. Sorting--when I try to sort, it will sort like 7,52, 245, 565, P50, T300, D9745. I want it to sort numerical... 1 Apr 2010 12:24