| Recent Answers from Edward H. Mori |
 |
2008-03-19 Pivot Table Dates: Here's the table I got Count of SSN Date Name 5/15/2005 5/31/2005 6/15/2005 12/31/2005 1/15/2006 1/31/2006 2/15/2006 Grand Total John 1 1 1 1 4 Tim 1 1 1 3 Grand Total 1 1 1 1 1 1...
|
2008-03-17 excel questions: 1. That would be a format. In the Format pull down menu select Format Cell. There are a variety of time formats you can chose. 2. To separate data in a cell you Text to Columns located in the Data...
|
2008-03-14 Multiple Selections from Pull down Menus: Glad that worked. I have done that for some forms I use here. If it says Unfreeze panes Freeze is already on. Click Unfreeze. Place your cursor where you want to freeze the column & row then go back...
|
2008-03-14 Multiple Selections from Pull down Menus: OK Example You drop down is in A1. You select value A. In B1 the VLOOKUP would return the value you want for the value of A in A1. If you select B for A1, B1 will change to return the value you want...
|
2008-03-12 Vacation time formula: The easiest way is in Column A have the start date then add the number of days to that to calc the date when the employee is eligible for X days of vacation example If an employee was hired today...
|
| More Answers for "Excel" |