Excel Experts

[Rizwan Anjum]

Asslam-o-Alaykum
Dear All,
Main 1 excel ki file attach ker raha hon, us mei mujhe Item wise Qty ka total chahye, SKU wise qty ka total to ho jata ha, Pivot Table ya Sumif Function k through... Lakin item wise nehi ho raha because Same item per SKU ki tarteeb change ha. please help k item wise qty ka total ho jaye.. jese k Item ha Pintuck king charcoal. ab pintuck king charcoal jaha b likha ha us ka sum ajaye tarteeb chahye kuch b ho...

[Haseeb Alamgir]

وعلیکم السلام برادر چیک کرتے ہیں آپ کی فائل کو
باقی ایکسپرٹس کا انتظار فرمائیں
تحریر گزار بروز پیر والے دن آپ کی اس فائل کو چیک کرے گا

[amirkhan0]

bhai ap filter use kr len na.. filter me pintuck type krin search me jitne pintuck text ke sari search a jaye ge qty me sum ka formula use kr k count kr len

[amirkhan0]

dosra method find wala Ctrl+F press krin Pintuck type krin sari search a jaye ge ab usy highlight krne k replace ka option use krin. replace with k samny format per click krin or fill me koi color select krin or replace all kr len. jitne pe pintuck text hoge wo cells colored ho jaye ge ab us color ko filter kr k count kr len.

[amirkhan0]

3rd methud phr column to text wala hai. or ap ke de gai file me SKU wala column jo hai us me "Dash" hua hai text k between me to is sari text line ko ap separate columns me change kr skte hain just select the whole column and go to Data > and then click on text to column>. select option Delimited and press Next and then Others me Dash (-) type krin aur phr Next > general select kr k finish kr den. sheet me ap ko hr text ka separate column mel jaye ga ab ap ko asan hoge koi b text filter kr len and then count.

[Rizwan Anjum]

Thanks but Text to Column se sequence same nei ati

[sikanderarshad90]

Agree with Ahmed

[sajidbagi]

check the attachment