formula chahey

[Ghayyasg]

IT Dunya me ye meri doosri post hai, ek question k sath hazir-e-khidmat hoon,
ye ek sample file hai, mujhay aisa formula chahey jis se mai ek list tayyar kar sakoon,
ye list auto matic tareeqa se create ho, side pe ek smple sale sheet hai, jo list auto creat karna chahta hoon, us me mai tarteeb se tamam items ko lena chahta hoon, ta k ek item ki total kitni entries hain yeh bhi judge kia ja sakay,
jo result chata hoon usay neechay show kar dia hai,
ap sab k reply ka muntazir hoon,

[syar]

IT Dunya me ye meri doosri post hai, ek question k sath hazir-e-khidmat hoon,
ye ek sample file hai, mujhay aisa formula chahey jis se mai ek list tayyar kar sakoon,
ye list auto matic tareeqa se create ho, side pe ek smple sale sheet hai, jo list auto creat karna chahta hoon, us me mai tarteeb se tamam items ko lena chahta hoon, ta k ek item ki total kitni entries hain yeh bhi judge kia ja sakay,
jo result chata hoon usay neechay show kar dia hai,
ap sab k reply ka muntazir hoon,

Please go through the attached sheet. Remember Formula in C15 is an Array formula, so confirm with "CTRL+SHIFT+ENTER"
Change ranges/references accordingly.

regards

[Ghayyasg]

thanks ,

pehle bhi kehna chaaha magar post hi nnahi kar pa rHa tha,

[Sahil_Jaan]

thanks ,

pehle bhi kehna chaaha magar post hi nnahi kar pa rHa tha,