Excel/Expert Profile

Stuart Resnick

On Vacation
returns 11/11/2009
Expertise

I can answer any question relating to MS Excel formulas, or to programming with vba (Visual Basic for Applications) in the Excel environment

Experience in the area

As a consultant, I've designed Excel tools since the 90s, working for the Federal Reserve Bank, AT&T, and (currently) Gap Inc.

Average Ratings

  • Knowledgeability 9.92
  • Clarity of Response 9.86
  • Timeliness 9.92
  • Politeness 9.91
  • Number of Questions (in Past 24 Hours) 0
  • Max Questions to be Asked (in 24 Hour Period) 3
  • Total Questions (since joining AllExperts) 2449
  • Volunteer Since 2006-08-04
  • Prestige Points 19760

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Althea11/02/0910101010Stuart...you are the BEST!!! Thanks so .....
Cassandra11/02/0910101010WOW. I never expected such a quick .....
Althea10/30/0910101010GREAT TURN AROUND TIME IN ANSWERING MY .....
rugian10/26/0910101010 
Ellerd10/20/0910101010Stuart Resnick, your first feedback was correct .....

Recent Answers from Stuart Resnick

2009-11-04 use data from a closed xls:

There's no simple way to do this, as the Excel INDIRECT function doesn't work for closed workbooks. There are add-ins that you can download which, when added to your Excel application, will include a new

2009-11-03 Linking A Checkbox:

Start with new worksheet. View the Control Toolbox toolbar, and use it to place a checkbox on the sheet. Right-click on the checkbox, and set the LinkedCell Property to =A1. Exit design mode, and close

2009-11-02 Accumulated Minutes into Hours & Minutes:

Since you now say your Time On and Time Off may be on different days, it's MUCH clearer to include the date in these entries. So for instance, in cell A2 enter: 11/2/09 5:00 am and in B2 enter

2009-11-02 Totaling a number of people scheduled at certain times:

New sheet, select cols A:D, Format, Cells, Number, Category: Time, Type: 1:30 PM, OK. In A1:A3, enter: 8:00 AM 9:30 AM 10:00 AM In B1:B3, enter: 6:00 PM 7:00 PM 8:00 PM Range A1:B3 now

2009-10-30 Accumulated Minutes into Hours & Minutes:

Since you don't specify, I'll assume Excel 2003. Select cols A:B and Format, Cells, Number, Category: Custom, Type: hhmm, OK. In cell A1 enter 06:19 and it will appear as 0619. Similarly, enter

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:

Ask Experts

Volunteer

©2009 About.com, a part of The New York Times Company. All rights reserved.