Functions

auto populate unused rows from workbook to workbook
Please Help. I can't seem to get the data entered on one workbook to enter on another workbook without over writing. I've set up a master seed file where client data is entered and then saved as the client name. Its data entered into rows is then set to auto populate the second workbook's first row. Is there a ... 16 Mar 2010 16:17

calculating % of a monthly budget on a daily basis
I have a monthly budget figure, and I'm trying to use a formula to show what % of budget I'm at on a daily basis. For instance, my budget for the month is that I'll make 800 items, and halfway through the month if my actuals show I've made 400 items, I want the % of budget column to show 100%, not 50%. How do ... 16 Mar 2010 13:58

Looking for a Function? similar to LEFT
I have a list of org unit names that are always preceded by a 3 digit number. How can I just show the text and not the numbers? Example: 001 Org Unit Name *note* there is also always a space after the 3 digits. In this example I only want a column to display "Org Unit Name." Help? KR P.S. I looked through oth... 16 Mar 2010 15:07

If function and a range
I have the following function and it is only half working for me as my arguements seem to contradict one another as I want to see if my number falls within a specified range. Any suggestions appreciated =IF(F3<2,"Fail",IF(F3>2,"Pass",IF(F3>16,"Fail",IF(F3<16,"Pass")))) -- mrsatroy ... 16 Mar 2010 13:58

Need help with formulae comparing date-based numbers
I'm trying to write a Excel formula that enters an integer value for a cell, the value representing an age in days. To get this value, I'm comparing values in two cells. One cell may or may not have a value, but it establishes the upper limit for the integer value. The problem is this: I have tried using both th... 16 Mar 2010 12:33

Delete Rows using If and Wildcard
I'm trying to delete all rows that DO NOT contain the text "ENTER" in column F. I have tried a few different methods based upon research from this site, but I'm struggling to change them, to delete all rows that DO NOT contain the "ENTER". I need to use the wildcard as most of the cells contain additional da... 16 Mar 2010 12:33

Setting up a formula (when F2<11,000)=$25
Setting up formulas for my business on Excel 2007. I have a column for lot sizes of properties. I need to have a second column that contains a formula that will compute, if the 1st column is less than 11,000sf, then we will pay $25. For example, lets say that a property is 2,500sf. The formula would see tha... 16 Mar 2010 12:33

Help: vlookup from multiple sheets and spreadhseets
I currently have a spreadhseet which lists frauds on cards (card number, date, description etc), 1 row for each card with 12 sheets, 1 sheet for each month of the year. I have another spreadsheet called 'at risk' with another list of card numbers. What it does is checks the fraud spreadsheet to see if the card... 16 Mar 2010 16:17

delete columns in spreadsheet after data entered so it wont scroll
can i delete columns in spreadsheet after data entered so it wont scroll to the right endlessly or upto IV... thanks! ... 16 Mar 2010 11:25

Monday closest to today's date?
Hello: I am seeking a formula that would return the date of the closest Monday to today's date. The monday would have to be the first one in the future, not the past. So today, Tuesday March 16, 2010, the formula would return Monday, March 22, 2010 Thanks in advance :) ... 19 Mar 2010 16:41