Aap attached file m apna solution deekh sakte hain main ne two solution
deye hain jo aapko pasand aae istimal kar sakte hain. Quantity k liye bhe
main ne aik sat kar diya hain agar aap chahte hain tu is ko alag column main
bhee count kar sakte hain.
Lenkan apne screen shot me jo data diya hai wo app ke file k data se mukhtalif ha. Is matter ko khod deekh lejeya ga.
2nd aap apne data column ko aik jesa format karain. Agar aik entry column main text ha tu baqi entries bhe text hone chaheye warna aap ke formula error dain ge.
Umeed rakhta hon k aap ka masla hal ho jae ga.
Thanks & regards
Bookmarks