Functions
in [Excel]
|
validation hi, I have a workbook with 2 sheets. In one sheet I have a calender and other sheet just list of names. what i want to do is: In the calender sheet if i have a name under a date and when i enter that date beside that name in the sheet of name list, i want to have a message saying that he/she is on vacation. ... 5 May 2010 16:03
How to freeze one column vertically, one horizontal in same sp That was what I took her question to mean she wanted. Sorry if she didn't want this. "Billns" wrote: On 5/4/2010 3:08 PM, Nadine wrote: What cell is below the row you want frozen and to the right of the column you want frozen. Find that intersection cell and place your cursor in it. Then go ... 5 May 2010 16:03
Calculate next workday after adding calendar days to date in cell I want to add 100 calendar days to a date in a cell and when that date falls on a weekend or holiday the formula will return the next workday vs. returning a weekend date. I tried the workday function but it counted 100 workdays not calendar days. Thanks in advance ... 5 May 2010 17:10
Convert text entered as minutes/seconds to minutes I have several entries (formatted as text) for example, :31, 1:04, 4:53, 23:34. These numbers indicate minutes and seconds (31 seconds, 1 hour 4 seconds, etc). What formula can I use to convert these entries into seconds? ... 6 May 2010 00:56
how to remove #n/a error in excel vlookup b/c value is not fou Thank you- this was great!! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders" <B. Franklin Saunders(a)discu... 5 May 2010 14:55
Linking data from one worksheet to another... I have two worksheets in different workbooks, one as a master list, and the other as a sub list, with candidates names and information (I'm in Human Resources). I'd like to link them so that whatever changes I make to one worksheet, is automatically updated in the other. Is this possible? If so, how can it be d... 5 May 2010 20:31
hr worksheet counting days missed I currently track employee time for the purpose of tracking vacation time. Now my bosses would like to add a function that will alert if an employee is absent more than three times in 180 days. I am trying to figure out how to start. The data is in the workbook (each employee on a seperate sheet) and i curre... 5 May 2010 16:03
How do I set up a botton on Excel 2003 to go to the next sheet? I want to create a "Next Page Button" on an Excel 2003 spreadsheet to go to the next sheet. When entries are complete a person can just click the "button" and go to the next steps (next sheet) in the spreadsheet. Thanks, Bruce ... 5 May 2010 16:03
vlook on different tabs based on value good day, i have the following so far in my macro: .... supcode = Range("B4").Value .... If supcode = "CLI" Then ActiveCell.Offset(0, 4) = "=VLOOKUP(RC[-4], '[Order Generator.xlsm]CLI'!C2:C4,2,FALSE)" .... right now i have this code repeated several times for each supcode that may exist... 5 May 2010 14:55
VLOOKUP I am using VLOOKUP as I have many times in the past. The formula I am using is: =VLOOKUP($A3,Raw,2,FALSE) It returns a "0" presumeably becasue it thinks the value in column 2 is "0". It returns the same thing regardless of the column, with one exception, column 1. It returns that value appropriately. The... 5 May 2010 13:48 |