i have set of date in A:A,B:B,C:C at last F:F column contains fill serial no{1,2,3,4.....}
CRM DATE In A:A column
SO In B:B column
CALL TYPE In C:C column
i have set of macro to count how many times its so gets repeats in column with LABOR ONLY & LABOR & PART in call type column C:C
but now i calculates both LABOR ONLY & LABOR & PART which are available against so' other wise it gets error
for e.g for if so DE3233334 only one time and call type LABOR ONLY i want result = "0"
if so WEE412122 repeats four time but call type LABOR & PART repeats four time i want result as per date sort from min to max 0,1,2,3.
please find the code
here getting error like this msg(runtime error 1004 no cells were found
stops at "
"
find the attachment!!!
Bookmarks