microsoft excel training in london - Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Michael has attended:
Excel Advanced course

by - delegate Michael [1 post] (2007 Mar 14 Wed, 09:42) Reply

what formula would you put in if you wanted to check if two different cells of data was the same

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Formulas

by - trainer Richard platinum contributer [785 posts] (2007 Mar 14 Wed, 11:50) Reply

Michael

Try using the DELTA (for numbers) or EXACT (for text strings).

DELTA returns a 0 (No) or 1 (YES) value. You could tack an IF statement into the formula to make it reply YES or NO if you wanted to.

Richard

· Prepare for your MOS Certification with MS Excel Courses
· Excel Macros for the Non-Programmer
· Benefits of learning about Excel charts
· Tools From Advanced Excel Courses: Goal Seek and Solver
· How to Create Better Excel Spreadsheets: Part One

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips