Exce adv

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-training · Excel/courses/london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Exce adv

Stephen has attended:
Excel Advanced course

by - delegate Stephen [1 post] (2008 May 20 Tue, 10:07) Reply

How to do duplicate I list against another using either match or vlookup?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Exce adv - VLookup and/or Match Function!!

by - trainer Rajeev gold contributer [480 posts] (2008 Jun 2 Mon, 13:26) Reply

Dear Stephen

Thank you for attending Excel Adv. course. I hope you enjoyed the course and it was beneficial to you.

I am not sure exactly what your question mean and therefore, would appreciate it if you could please elaborate your query preferably by giving some example!

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003

· Excel in the Home Office
· How to check for and reduce errors in Microsoft Excel
· Interesting Lifestyle Applications for Microsoft Excel
· Why Should I Learn Visual Basic in Excel?
· MS Excel: Excel At Making The Most Of Your Christmas

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Rate this page: