Ye kis tarha ke formula hote hai-

[Nadeem Ahmed Kh]

Dosto mai ye janna chahata hu ke nichay likha gaya formula kis tarha likha jata hai, matlab ye ke jab mai es ko update karta hu to N/A aa jata hai ?? jese - LX!$B$3:$B$104 es mai agar mai row no 104 ki jagah 115 ye 120 yani ke mai es ko 104 se badhana chahu to ye nahi ho pata.

any expert of Excel can tell me ye kis tarha hota hai yani ke es formula ko kis tarha likha jata hai.

ye shayad array formula hota hai magar kis tarha execute hota hai please koi ye bataye mahar
hogi bhai ki.

pura formula es tarha hai -

={IF(ROWS($B$3:B10)<=$B$1,INDEX(LX!$B$3:$B$104,SMA LL(IF(FREQUENCY(IF(LX!$B$3:$B$104<>"",MATCH("~"&LX !$B$3:$B$104&"",LX!$B$3:$B$104&"",0)),revc),revc), ROWS($B$3:B10))),"")}

[Namreen]

Ap k Formula me error hay jo k mene remove kia hay mager ap ka maksad kya hay is formula likhne ka ap kya achieve kerna chah rahe ho, XL k nam ki aik or worksheet ap ne formula me mention ki hay, kin values pe kam ker rahay ho aik example do takay sahe se me apki query ko resolve ker sakon.
Let me know

[IT.BOY]

ap apney formuley ki sheet yahan share karey is tarha ap ki problem solve nahi ho sakti kiun key kuch data excel ki dosri sheet sey bhi telly kia jata hai....OK

[Nadeem Ahmed Kh]

Ap k Formula me error hay jo k mene remove kia hay mager ap ka maksad kya hay is formula likhne ka ap kya achieve kerna chah rahe ho, XL k nam ki aik or worksheet ap ne formula me mention ki hay, kin values pe kam ker rahay ho aik example do takay sahe se me apki query ko resolve ker sakon.
Let me know

ap apney formuley ki sheet yahan share karey is tarha ap ki problem solve nahi ho sakti kiun key kuch data excel ki dosri sheet sey bhi telly kia jata hai....OK

Yaha mai reference ke liye ak excel ki workbook atached kar raha hu, es mai do sheet hai ek LX or dusri sheet 1 ke nam se LX mai do period ka kam likha hai ek row 1 se 53 tak dusra 1 se 52 tak pahla kam 1 se 15 tarikh tak hai or dusra 16 se month ke end tak ka, jo work hai wo dono period mai same hi rahta hai, magar kabhi kabhi koi naya head bhi a jata hai ya phir ghat bhi jata hai.

ab mai ye chahata hu ke ye jo work hai ek dosri sheet mai step by step ya fir Randomly ek ke bad ek a jaye or un ka amount bhi sum ho jaye jese ke

B column ma 3rd row mai work hai - "Store helper" or es ka amount hai 1680 (1 se 15 tak (date) or B column mai hi row no 56 mai bhi "Store helper" hai or ab uska amount hai 1800, to mai ye chahata hu ke kisi dusri sheet mai ye store helper sirf ek bar likha aaye or es ke age ke column mai es ka dono amount sum ho jaye jese ke ye ho jaye ga 3480,,, es ke liye ye formula lagaya gaya hai, or ye tamam data 107 rows mai simat ata hai - Lekin agar kabhi LX mai row bad kar ye 111 ya fir esse kahi jiyada ho jaye to jab ham sheet 1 mai row ko update karte hai to ye N/A a jata hai why???

formula ye hai - =IF(ROWS($B$3:B3)<=$B$1,INDEX(LX!$B$3:$B$107,SMALL (IF(FREQUENCY(IF(LX!$B$3:$B$107<>"",MATCH("~"&LX!$ B$3:$B$107&"",LX!$B$3:$B$107&"",0)),revc),revc),RO WS($B$3:B3))),"")

[sayhellotoit]

Wassalam,

Jab bhi aap Sheet1 kay column B kay formula ko change karain, tu Ctrl Shift Enter Press karain. Agar khali Enter press karain gay tu kam nahi karay ga.

[Nadeem Ahmed Kh]

Wassalam,

Jab bhi aap Sheet1 kay column B kay formula ko change karain, tu Ctrl Shift Enter Press karain. Agar khali Enter press karain gay tu kam nahi karay ga.

Dost wahi to nahi ho raha hai, ap agar ap manle ke sheet LX mai 107 nos rows ki jagah 120 rows mai mera data hai manle - to ap mai agar sheet 1 me es ko formula ko update karta hu Ctrl+Shift ke sath enter kar ke to ye update nahi hota dost nahi hota,

mai ye kah raha hu ke agar LX mai agar kabhi mera data 107 se bad ka jiyada ho jaye to mai kis tarha se sheet 1 ko update karu ?????

[sayhellotoit]

Abhi iss liyay nahi ho raha kion keh LX wali sheet pay row 109 column B pay date likhi hoi hay. Aap date ko remove ker dain tu ho jayay ga.

[syar]

salam::

m ne aap ke formula thode se change kardeye hain. see the attached asheet.

aap apni "xl" ki sheet me new entry karain aur sheet 1 k column a m sirf serial no lekhain agar tu xl ki sheet m hone wale entry unique howe tu wo sheet 1 pa aa gae gi leekan agar wo unique na howe tu sheet 1 me #na k error aaey ga. jo k us soorat m aata ha jab match function ko value nahee melte ha.tu aap serial no delete kar dain baqi field k formula rahee ga.


see the attached file and feedback.

regards

[Nadeem Ahmed Kh]

Yes mai yaho to chahata tha dost, thanks a lot, dost thanks

[IT.BOY]