Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Yes/no statement

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Yes/no statement

Resolved · High Priority · Version 2003

Reply Thu 2 Sep 2010, 10:55Delegate Steven said...

Steven has attended:
Excel Intermediate course
Excel Advanced course

Yes/no statement

I am supposed to receive a statment from our clients every thirty days. When the statement is received I put the date recieved into a colomn. How do a create a futher column which states yes/no if a statement has been received in the last thirty days. Futhermore is it possible to automatically create a tab which pulls off all of the yes statements.

For upcoming training course dates see: Pricing & availability

Reply Fri 3 Sep 2010, 10:24Trainer Jacob said...

RE: yes/no statement

Hello Steven

Thank you for your post, yes what you are trying to do is achievable I would recommend that you check in with your trainer on this next week, also I reckon one of the units on next weeks course, v-lookups combined with conditional formatting will be the way to go.

Kind regards

Jacob

Thu 9 Sep 2010: Automatically marked as resolved.

Excel articles

· Joseph And His Chart Of Many Colours
· Make More of your Money with Excel 2007
· Tips From Excel's 'Rarely Used' File
· Excel Macros for the Non-Programmer
· Features of Microsoft Excel that assist in Analysis of Financial Data

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

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips