Required Excel Formula

[Qutab]

jo picture attach ki gai hy aur jis column ko highlight kya gya hy. is mein total words 6 hain. ab koi aisa formula btao k in k andar sy "a" valy minuse (-) ho jay jesy total hain 6 -a = 5 words.
kya aisa koi formula hy. agr hy to plz help me
aur next column no 2 mein dekho wahan d/n likha hy. kya koi aisa formula hy k d/n ko 2 word add kary. yeni day & night
plz help me

[syar]

Just use Find & Replace option.
Select your Column aur CTRL+F press karian aur Replace m jaha word replace karna ha yani d/n ko Pora Day and Night lekh kar replace kar dain. Aur jahan kuch nahee karna wahan bagher kuch lekhe replace kar dain.

regards,

[Qutab]

sory bhai aap meri baat samjhy nai.
total word hain 6 vahan ye formula laga hy. =counta(select range)
ab main chahta hon k word count kary lekin usmein a count na kary
ab samjhy

[jatam]

sory bhai aap meri baat samjhy nai.
total word hain 6 vahan ye formula laga hy. =counta(select range)
ab main chahta hon k word count kary lekin usmein a count na kary
ab samjhy

visit here brother Microsoft Excel Helpline @ ITD

.:~Xilisoft (latest) HD Video Converter the King of Converter~:


.:^~ YouWave for Android on Windows PC ~^:.

[syar]

Try
=countif('your range',"<>a") for example

=countif(a:a,""<>a")

regards

[mfranakar]

کل آپ کو بتا تیں ہیں تفصیل سے اپنے ایکسل ہیلپ لائن تھریڈ میں
اس کو وزٹ کریں
http://www.itdunya.com/t300546-4/#post3149243

[Qutab]

Thanks masla hall ho gya.

[Qutab]

tanks aik masla to hall ho gya hy "a" vala. lekin abhi aik masla reh gya hy. vo ye k jahan jahan d/n likha hy vahan per 2 word add hon. for example, a+b+c+d/n, ab jo aap ka formula hy vo is ka total kary ga 4 word. lekin main chahta hon k d/n ko vo 2 add kry. yeni 5 words.
kya ye momkin hy.

[syar]

Well brother I'm not clear. Kya ap apne matlooba output ka screen shot d sakte hain.
Count ya count if aap ki list m mojood word k occurance ko count karta ha yani list m kitne dafa aya ha. Lekan ap jo bat kar rahee hain wo work ko count karna ha jis k leye len ka formula istimal hota ha. Please clearify with screenshot ya upload your file.

regards

[Qutab]

screen shot mein colum no 1 mein dekho. total 6 words hain. lekin colum no 2 mein dekho d/n likha hy ab total word 7 ho gy. d mean day and n mean night. ab d/n ko 2 add karna hy. abhi bhi smjh nai aai to mujh sy poch lena.
ab colum no 2 mein d/n 2 word count kary aur a ko count nai karna.
yeni a ka matlab hy absent.
Yeni colum no 2 mein word hain 7 -a = 6

[nissa]

=count(select range)
ye formula apply karein may b ap ka masla haal ho jaye

[syar]

I assume aap ka data column B m ha Range apni sheet k mutabiq adjust kar lain.

=IF(COUNTIF(B4:B10,"d/n"),COUNTIF(B4:B10,"d/n")+COUNTIF(B4:B10,"<>a"),COUNTIF(B4:B10,"<>a"))

regards,