IFERROR copying row data for selected values

[Danimarie]

Hi there,

Any assistance with this would be great, I have already had a wonderful user get me this far, but he's offline

What i need is in this workbook for the data to only show for the month it's related to, so for the entries already existing in February 2012 only show the entries for February, So whatever column has February dates in it just show data in that column, I want this to happen for Placements Claimed SO Column E from PPS Tracking and also 26 Weeks Claimed Column L.

What I have so far is perfect and I am happy with how this works, but if for the first client I can just show the dates for the Claims made in February it will be perfect.

is this possible and if so please help.......... It's giving me a headache trying to work it out

[zbor]

Forum Rules
Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should 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 the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

[zbor]

Here, try this:

=IFERROR(IF(MONTH(INDEX('PPS Monitoring'!E$2:E$521,SMALL(POS,ROW(E1))))=MONTH($I$1),INDEX('PPS Monitoring'!E$2:E$521,SMALL(POS,ROW(E1))),""),"")

[Danimarie]

Here, try this:

=IFERROR(IF(MONTH(INDEX('PPS Monitoring'!E$2:E$521,SMALL(POS,ROW(E1))))=MONTH($I$1),INDEX('PPS Monitoring'!E$2:E$521,SMALL(POS,ROW(E1))),""),"")

Hi & thanks for your feedback

I tried this but it cleared all of my data, I'm fairly new at this and any extra info would be fantastic.... My sheet is attached a little higher if you could look at that to see if you can make it work..