You are here:

Excel/Expert Profile

Isaac

U.S.

On Vacation
returns 05/30/2012

Expertise

I can answer questions regarding worksheet functions (formulas, data, etc) and I have a fairly good handle on VBA. I can help with many, though not all VBA questions to provide coding, menus, macros, and automation. To someone who does almost nothing with code, I may come across as "expert" level. However, to someone who really knows their code very well, they consider me closer to a beginner. :) What I am good at, is piecing together a lot of research to put together reasonably good, workable code. So even if I don't write it all from scratch, I can often help you. I do accept and appreciate donations...Yes, I enjoy participating in web forums where mutual help is always exchanged for free, but allexperts is a bit different, as it's answering anonymous questions from anonymous persons, often a valuable bit of code that would cost you $100 of a paid person's time, with virtually nothing in return. So I greatly appreciate a $5 or $10 here and there, if you so choose. YOU MUST TELL ME WHICH EXCEL VERSION YOU ARE ON. 2003, 2007 I enjoy providing quality answers. To me a quality answer means that as an "expert", you DON'T try to sound fancy and complicated. Rather, you provide help where the person is at, and don't suggest things so complicated they will not be able to do them or maintain them. At the same time you may nudge them to check out additional options that will broaden their knowledge a bit. When you ask me a question, you will get an honest and helpful answer. Beware that this is not the case with many "experts". Either they are so 'expert' they will phrase things in a way that doesn't get you where you need to be (impossible to figure out how to implement), or else they will only criticize your approach. If I think your approach is wrong, I may mention it - but I'll still also answer your question. If I can't answer it, I'll be prompt and honest in saying so. (rare)

Experience in the area

Years of working in Excel, Access. And years of being known for VERY creative solutions to various things, by just using Office apps to the "max"

Organizations

Change.org Terry Goddard for Governor

Publications

Thomas Jefferson School of Law, student bulletin

Education/Credentials

Bachelors in Political Science and Business, 1.5 yr of law school

Awards and Honors

Six Sigma certified GREEN BELT.

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
deekshituluchs	05/01/12	10	10	10	Thanks for your suggestion, it is perfectly .....
ABHAY	04/27/12	10	10	10	If in A-1 the number is between .....
kiki	02/24/12	10	10	10	Thank you, still not working, nothing wrong .....
Gabe	02/20/12	10	10	10
James	01/20/12	10	10	10	Thank you very much- very quick response .....

Recent Answers from Isaac

2012-04-25 if multiple formula:

* Try: =IF(AND(A1>0,A1<101),A1*3,IF(AND(A1>100,A1<301),A1*4,IF(AND(A1>300,A1<501),A1*5,IF(AND(A1>500,A1<1001),A1*6,IF(A1>1000,A1*7))))) by the way, this is about the most IF statements (from a

2012-03-29 Data Validation - return short version of item:

* No, without VBA I'm not aware of any way to format text in an excel cell to only display the first N characters in a cell. Why not just require users to enable excel programming? All users at my

2012-03-13 Automatic Cell Color Change Based on Date:

* I don't follow the first part of your question. What's your actual definition, then, of what you want for the dates? However for the color, assuming that your due date is in column B, select

2012-03-08 Formula with many variables:

* Probably you should just use vlookup's instead of IF formulas, which leads me to say you should probably use Access if you're using database type of functions. But I'm not following your question

2012-03-07 enter cell# automatic:

* Put it aside? I gave you a great answer - goodness, don't give up that easily!! Just ask and I will be happy to help - you right click any worksheet in the workbook, and go to View code. Once you're

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: