Excel/Expert Profile


Ask A Question

Aidan Heritage

Available

Follow me on:
      

Expertise

I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards. I'm based in the UK, so please allow for time differences when asking me questions from other parts of the world!

Experience in the area

My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

Education/Credentials

I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!


This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Malcolm09/22/16101010Thanks Aidan for youur quick and clear .....
Prashant S Akerkar 09/03/16101010Dear Aidan Thanks. Prashant
hari06/21/16101010 
Stuart04/16/16101010Worked like a charm, many thanks Aidan .....
Moshe04/07/16101010 

Recent Answers from Aidan Heritage

2016-09-27 Excel:

I'd probably do this with a lookup table due to the number of possibles, but the rules aren't quite clear as you've shown what appears to be 4 hours 25 minutes and 40 seconds as being less than 2 hours

2016-09-21 SUMIFS Problem:

I tend to use Pivot Tables to sum such data, but excel has no problem with a SumIfs with a date - it's jus that you have to remember that a date is simply a number - so    =SUMIFS(D2:D21,A2:A21,"Bill"

2016-09-05 Lookup table and return value:

a little messy I'm afraid    =OFFSET(OFFSET($A$2,0,MATCH(Sheet1!C7,$B$2:$E$2,0)),MATCH(VLOOKUP(Sheet1!E7,OFFSET($A$2:$A$9,0,MATCH(Sheet1!C7,$B$2:$E$2,0)),1,TRUE),OFFSET($A$2:$A$9,0,MATCH(Sheet1!C7,$B$2:$E$2

2016-08-19 Periodic table data in Excel software.:

This is a very subjective question I imagine - I'm not a scientist, so having the periodic table available would be of no use to me - but possibly to others it would be of use - should you need one,  http://www

2016-07-29 lookup at aggregated sum level:

At a simplistic level, https://1drv.ms/x/s!AhG5Rd-eb4P3v0Roxw09IKFcSDmr would give you what you need - I've NOT used the region at the moment, but you can probably get the idea of how this works.  To work

 

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

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2016 About.com. All rights reserved.