Sir,
main nay aik file attach ki hai jis main rate list hai main main is main detail bhi likhi hai ziada kuch nahin ker bus in main formula thora change kerna hai .kindly sir juld say juld mayri is prob ko solve ker dain.
Sir,
main nay aik file attach ki hai jis main rate list hai main main is main detail bhi likhi hai ziada kuch nahin ker bus in main formula thora change kerna hai .kindly sir juld say juld mayri is prob ko solve ker dain.
yar bas range mai galti hai ap range n22 ki njye n24 tak karo kio k jo range ap ny define ki hai 22nd row tak hai jab k apka data 23rd r 24rth row mai b hai.
nahin horaha yeh problem nahin hai.yeh tonnage ko daikhtay huye nahin rate laga raha sirf catagory or station ko daikh raha hai main chahta hun .k yeh tenno ko daik k rate laaye
mayri aik problem jo ms excell k hawalay say hai ab to koi bhi solve nahin ker saka aap wo problem attach file main daikh saktay hain.
http://www.itdunya.com/showthread.ph...15#post1089915
bhai ap dcount dsum or daverage ka formula use karain
CITY OF ANGELS AND ME
Agar Aap Set Kerdain To Ap Ki Maherbani Hogi
Koi To Help Kereay It Dunya Say Mughay Yeh Umeed Nahin Thi
i am still waiting for the solution
plz plz plz plz solve my problem
koi excel expert aya tu app ko bata dega
Kindly change your signature's image size.
Team ITDunya
salam::
main ne apke rage ko absolute kar diya ha aap is ko apni zaroorat k mutabik adjust kar lain ge. formula ye hai leekan ye array formula ha jis ki wajha se aap ko "control+shift+enter" aik sath dabana ho ga.
=INDEX($K$10:$N$22,MATCH(1,IF($I$10:$I$24=F11,IF($ J$10:$J$24=E11,1)),0),MATCH(D11,$K$9:$N$9,0))
main ne rages absolue kar de han ta ke formula neeche copy karte howe aap ko error na mile.
dosri baat aap ne sample data main "tonnage" k leye 0 enter kiya tha jo k table m mension nahee ha.Take care of this issue your self or clarify what you need to return if you enter "0" in the field.
I hope this will work for you.
best regards
Regards,
Bookmarks