Excel main duplicate data alag karna

[pearlsublime]

پلیز بتائیں کہ ایکسل فائل میں ڈپلیکیٹ ڈیٹا کو کیسے فلٹر کیا جا سکتا ہے

[syar]

1. Data--->Filter--->advance filter

Jab advance filter k window open ho tu

2. Copy to another location select karain (optional) Agar dosri jagha par nahee chahte tu inplace select karain.

3. List range m apna data select karain
4. copy to k box m apni new jagha select karin sirf one cell.
5. unique records only ko bhee select karian.
6. Ok

AAp k unique record copy dosri location par ho gae ga. Agar aap ne inplcae select kia ho tu same place par filter ho gae ga.

Is k elawa bhe formula/function se bhee ho sakte hain. If your problem not solved then please submit your sample data.

may be this will help you.
regards.



aur ok