Excel/Expert Profile

Average Ratings

• Rating N/A
• ( Expert Not Accept Rating)   

• Number of Questions (in Past 24 Hours) 1
• Max Questions to be Asked (in 24 Hour Period) 1
• Total Questions (since joining AllExperts) 2349
• Volunteer Since 2000-10-22
• Prestige Points 10562

Recent Answers from Richard Roberts

2009-11-08 count if:

Bill I am not sure that I am reading the question correctly but-- You can use data validation to create your list of criteria that go in a cell that is referenced in your count formula. Then when

2009-11-07 Fuctions Running Automatically:

Eric I am definately not a VBA expert--while I may be able to figure out an answer for you It won't e very quickly, so I suggest you reask the question of another allexperts person and I'm sure you

2009-11-06 Question:

sree You need linking formulas to bring the data over to the master book. A linking formula will look something like this =[Book1]Sheet1!$A$1 This formula can be in the master book and will bring

2009-11-04 Time:

Polo Very often the problem with time is the formatting. If I copy your formula to a spreadsheet and format the cells F1 and H1 as 24 hour format, I.E. toolbar/format/cells/time select type of 13:30

2009-11-03 re-question:

Camron Okay I think I understand better now-- I don't have the time to create the calendars for you or think thru all of the formulas that will be necessary, but here is how I would approach it.