I meant to say "I have few more questions that I would ask in my next post In Sha'a Allah(if Allah wills), will wait for your response"
By the way I worked out on my original workbook but yea one thing is missing I wanted the sorted data to copied to a new worksheet sadly your formula doesn't do so... Is there any macro or vba solution you must be wondering why this guy is stressing on macros its simply I love it.
However if you could tell me how the sorted data be copied to a new worksheet would be great
As I have dragged down the formula for 1000 rows what it does it calculates dues count even if there is no value in date column is there any way to avoid it ??
Thanks
Bookmarks