Filtering month ends

[Kevin]

Hi One and All,

Please see my attached file.

I am trying to get all the month end reported dealing prices from this file. I'm not sure how to do it directly without deleting rows which is far too arduous & silly to do.

It's one of those days & I'd appreciate any help you could give

Thanks
KEv

 

[Faseeh]

Not all your dates are true dates!! try changing their format to general and see..

 

[Faseeh]

Please see if this is ok

 

[Kevin]

Thank you Faseeh

Really appreciate that...I'd have been months getting to that point.