PDA

View Full Version : Getting a feel for excel functions



rcbricker
01-26-2007, 08:51 AM
Ok I am trying to learn some stuff to help me solve my many excel problems. So I don't bother you all so much.

I am trying to learn when to use and how to use the different functions in excel. I have a pretty good grasp of IF and VLOOKUP. I have some idea of OR and AND. I can use SUM pretty well. That is the extent of my comfort zone.

So I am looking to learn how to use the rest of the stuff in Excel. How do I go about learning this things?

Example:

Like if I had a range of data in Column A and I had some data that I needed to find in that range. There is no other data next to column A. What I would like to do is import the data that needs to be verified into a column and have a function run that will find the data in column A and bring back the cell address (like A14). WHat function will do this?

mdmackillop
01-26-2007, 10:06 AM
Here's one site. Check out our resources page for others.
http://www.bettersolutions.com/excel/EDH113/NO911818331.htm

rcbricker
01-26-2007, 11:27 AM
Thnks MD

Dave
01-27-2007, 12:25 AM
Just remember functions are "fun" and that's why they call them that. It seems like you want to learn about VBA User Defined Functions aka UDF's ... or are you looking for worksheet solutions? Also, what you are looking to do is probably fairly easy do with some VBA. Dave
edit: advanced info: have both VBA and WS. See Joe's post here...
http://www.mrexcel.com/board2/viewtopic.php?t=105078

Bob Phillips
01-27-2007, 06:18 AM
Whilst you can do a lot with VBA, it should ALWAYS be last recourse IMO. If you can do it in Excel, do so.