Excel Formula Help

[angela.dean68]

Help! I have a hundreds of rows of data.
Column A = names (can be duplications, can appear only once)
Column B = Date (all different)
Column C shows dates e.g.

Joe Bloggs 03/09/2015 1st Date
Joe Bloggs 18/09/2015 2nd Date
Sue Smith 19/09/2015 1st Date
Frank Jones 17/09/2015 1st Date
Frank Jones 15/10/2015 2nd Date
Frank Jones 25/10/2015 3rd Date

We have target dates to make 1st Call by 18/09/2015; 2nd Call by 18/10/2015 & 3rd Call by 30/10/2015. How can I show if these targets are being met?

I am pulling my hair out. Can you help?
Angela

[Jacc]

If you post a workbook with some data and examples of what you want it will be much easier to help you. If you have sensitive data, create some mockup data instead.

[angela.dean68]

Hi Jacc, I can do that - but not sure how! Any guidance would be welcome

[ChemistB]

Here are 2 examples of what you can do.
1. Use conditional formatting to highlight those that are out. We have different date formats so not sure it will work but Sue Smith, row 3 should be highlighted in red and Frank Jones Row 7 in brown. Look at Conditional Formatting > Manage rules to see how the formulas are set up.

2. Set up a table with due dates enfraction in E1:E3 and Due dates in F1:F3, In G1 copied across and down, this ARRAY formula

=IFERROR(INDEX($A$1:$A$7, SMALL(IF($C$1:$C$7=$E1, IF($B$1:$B$7>$F1, ROW($A$1:$A$7))), COLUMNS($A$1:A$1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

To submit a workbook example, Go Advanced>Manage Attachments

[Jacc]

Angela, this is how you post a workbook:

How to post workbook.PNG

Choose file -> Upload -> Close window

[Pepe Le Mokko]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)