DUPLICATE VALUE COPY TO OTHER CELL

[sohail1966]

Sir, mujhay aik aisa formula chaye jo ke excel duplicate value jo count ho rhi hoo do dfa se zyada in ko next kisi coloumn me show karday.
Maslan mein ne jo file share ki hay is mein duplicate value 04 dafa arhi hay wo next coulmn mein 04 dafa aik sath ajye essi tarah hi mzeed duplicate values
Bohat Bohat shukria..

[syar]

Aap ko power query ka batay tha aap ne full use naee keya.

1. DATA k tab m ja kar get data k sath he from table/range ka option ho ga.us par click karain.
2. data jab load ho jay tu aap ko keep columns/Rows and Remove Rows/Column ka option aay ga.
3. Keep rows k option m jain, us par Keep duplicate ka option ho ga.
4. us par click karain, jab duplicate data ajay tu aap ki marzi ha k sides columns jis m aap k s.no aur duplicate count ha usko delte krna chahty hain tu thk naee tu rahny dain.
5. usky bad close and load k option m "Close and Load to" ka option select krain
6. new aany waly option m sa "existing worksheet aur phir cell ka reference de dain jahan aap sary duplicate chahty hain.
7. press ok. aap ka sara duplicate data usi cell sa start ho kar ajay ga.
---

Agli dafa aap ko fees deni ho gi kisi bhe masly ka solution k leye

[Haseeb Alamgir]

Sir, mujhay aik aisa formula chaye jo ke excel duplicate value jo count ho rhi hoo do dfa se zyada in ko next kisi coloumn me show karday.
Maslan mein ne jo file share ki hay is mein duplicate value 04 dafa arhi hay wo next coulmn mein 04 dafa aik sath ajye essi tarah hi mzeed duplicate values
Bohat Bohat shukria..

جی برادر
اپنے پچھلے تھریڈ کا وزٹ کریں
اور
برادر کے بتائے ہوتے طریقے کو اپنائیں
ان شاء اللہ آپ کا مسلہ حل ہو جائےگا
اگر
پھر بھی کوئی مسلہ درپیش آئے تو اسکرین شارٹ شئیر کریں آپ کی رہنمائی کی جائے گی

[sohail1966]

Sir, bohat bohat shukria mein try karta hoo.
Ap ne mujhay guid kia hay to as trarah ap meray ustaad hay,
Ap fees to btain Insh'allah ada krain gay.

[sohail1966]

Sir, meine try kia hay, file load ow ja ti hay or usi tarah keep rows ke baad duplicate select kia tha us ke baad load to ke option mei usi work book mei us se alga coloumn ka address dia tha e,g, d2 lekin kuch show nhi ho ta aur right side window mein empty table1 a rha hay.
screen shorts share kye hay mzeed rahnumai ke zroorat hay.

[syar]

Aap ne power query k window main s. No k column ko select keya ha. Uski jaga aap apni list k column ko select karain. Phir baqi procedure apply karain. Q k s. No k column m koi duplicate naee is leye empty araha ha.
Aur ho saky tu s. No aur formula waly column ko power query m delete kar dain.
Q k jab aap isko delete keye bagher apply krain tu 3no column aap ki batay hoi jaga p ajaingy. Is leye sirf wohi column rahny dain jo aap ko chahye

[sohail1966]

Bohat bohat shukria Sir,
It is working very well.
Screen shot is attached:-

:

[syar]

Bohat bohat shukria Sir,
It is working very well.
Screen shot is attached:-

:

Good.
Next time fees pahly agar zarorat hoi tu

[sohail1966]

Sir,
Aik aur sawal hay ke yeh jo duplicate values do dafa ya char dafa aye hain kia yeh duplicate value jo do dafa hain wo do dafa aur jo is se ziada dafa hain wo respetively aik hi jaga akhti ho jye.
e,g, cell c1 to c4 pehli char duplicate values
cell c5 to cell c6 us se agali do ya teen ya char ya us se ziada duplicate values ajey.
Apki help ka bohat bohat shukria..

[syar]

Aap ne jis column m formula lagaya ha, us colum ko base bana kar descending order m sort kar lain. Aap ka masla hal ho jay ga

[sohail1966]

Sir, meine sort kia hay aur us ka screen short bhi dai rha hoon, is mein sab se bra 8 hay jha say count down shroo huwa hay,
ab 8 se 5 tak to aik hi duplicate value arhi hay lekin 4 se neechay milay julay cell arhe hain.
Lekin mera swal yeh hay ke aik jesy duplicate value aik hi jaga akhathi kesay krain gay chaye wo 8 ho 5 ho 3 ho
Bohat Bohat shukria.

[syar]

Sir, meine sort kia hay aur us ka screen short bhi dai rha hoon, is mein sab se bra 8 hay jha say count down shroo huwa hay,
ab 8 se 5 tak to aik hi duplicate value arhi hay lekin 4 se neechay milay julay cell arhe hain.
Lekin mera swal yeh hay ke aik jesy duplicate value aik hi jaga akhathi kesay krain gay chaye wo 8 ho 5 ho 3 ho
Bohat Bohat shukria.

aap ne "countif" k formula theek naee lagaya i guess. isko theek kar lain tu aap ka masla hal ho jay ga. Countfi jis range/cell sa start ho raha ha usko absolute kar lain. formula m aap ne shayad ranged dynamic chor di hain. jis waja sa ya masla ha. ranges absolute krne k bad sor krain, aap ka matloba result ajay ga