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

Yes/no statement

ResolvedVersion 2003

Thu 2 Sep 2010, 10:55 Delegate 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.

Fri 3 Sep 2010, 10:24 Trainer 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Yes/no statement

Yes/no statement

RE: yes/no statement

Excel articles

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines