You are here:

Excel/Expert Profile

Aidan Heritage

Available

Expertise

I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards

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!

Average Ratings

Recent Reviews from Users

User	Date	K	C	T	P	Comments
Shan	11/22/09	10	10	10	10	Thanks so much for this. It helps .....
Apple Aranas	11/22/09	9	9	10	10
Joe	11/21/09	10	10	10	10	Man, Aidan, thank you very much. . I'm .....
Joe	11/21/09	10	10	10	10
Dawn	11/21/09	10	10	10	10	Thanks Aidan it works perfectly and you .....

Recent Answers from Aidan Heritage

2009-11-20 macros that automaticly calculating values through a workbook system based on values entered into a cell:

The macro sounds fairly easy- it's basically going to be a for...next loop which puts in the values and copies the results to an output array - happy to write it for you, but might need slight guidance

2009-11-20 Creating column macro (criteria based):

Not a problem - you can use a COUNTIF function to determine the first row, and a sumif to give you the value, with an IF statement to handle the rest =if(countif($A$2:$A$100,a2)-countif(a2:$A$100,a2)=1

2009-11-20 Vlookup based on several drop downs:

Not sure I have enough to go on in that at the MOMENT it doesn't sound like a lookup, simply an IF statement - but I suspect it WILL be a lookup - the easiest way at that point is to have A12NO

2009-11-20 Excel 2007 - auto-updating number:

Excellent- your formula has a SLIGHT problem in that presumably the holiday continues in January, february etc - so these would produce a negative number with the formula as it stands =[hours left]+([hours

2009-11-20 To Lookup and return values:

multiple lines is always going to be a problem as no function can program the lines, but you could seperate with commas - I have a custom function that will do this (with amendments) which you can see

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

Encyclopedia

Browse Answers: