1. Member
Last Online
4th April 2014 @ 11:55 AM
Join Date
09 Mar 2014
Gender
Male
Posts
445
18
Thanked
24

ASSLAM O ALAIKUM

mujay excel main kafi data banana hota hai same data main filter kr k count krta hoon jis main kafi time waste hota hai koi mujay aisa formula bata sakta hai k main us data ka name likhoon aur us formula say auto pe same data ki counting ho kr likhi ja'ay????

Last Online
23rd September 2020 @ 02:49 PM
Join Date
31 Jul 2009
Location
Nowshera(KP)
Age
44
Gender
Male
Posts
841
9
Credits
287
Thanked
340
SERIOUS_BHAI said:
ASSLAM O ALAIKUM

mujay excel main kafi data banana hota hai same data main filter kr k count krta hoon jis main kafi time waste hota hai koi mujay aisa formula bata sakta hai k main us data ka name likhoon aur us formula say auto pe same data ki counting ho kr likhi ja'ay????

use COUNTIF function of Excel, or share your workbook.

regards

3. Bhai jan ap usko advance filter say hi karain,
baqi sahe wazahat say samajh nahe aya.
Ask & expert par hi rujoo karain to behtar ha.

4. Member
Last Online
4th April 2014 @ 11:55 AM
Join Date
09 Mar 2014
Gender
Male
Posts
445
18
Credits
0
Thanked
24
ok brothers

5. Member
Last Online
4th April 2014 @ 11:55 AM
Join Date
14 Mar 2014
Gender
Male
Posts
143
18
Thanked
18
mujay app k sawal ka jawab mil geya hai main share bhi kr dayta hoon

agr kisi coloum main ap daikhna chatay hain k aik khas lafaz kitni bar aya hai tu us ka forumala yeh hai

MISAAL K TOOR PE APP DAKIHNA CHATAY HAIN K "P" KITNEY DAFA LIKHA GEYA HAI TU LIKHAIN

=COUNTIF(I7:I28,"P")

FORMULA WALAY DUBAY KO GERENAL MAIN FORMATE KRNA HAI
Last edited by MUKHLAS; 1st April 2014 at 06:10 PM.

6. Member
Last Online
4th April 2014 @ 11:55 AM
Join Date
14 Mar 2014
Gender
Male
Posts
143
18
Credits
0
Thanked
18
i7 row & coloum ko show kr raha hai isi tarah i28 bhi ...

7. Member
Last Online
4th April 2014 @ 11:55 AM
Join Date
14 Mar 2014
Gender
Male
Posts
143
18
Credits
0
Thanked
18
Kisi kism ka masal ho tu rabta kr saktay hain sample sheet main upload kr raha hoon daikh saktay hain download kr k

note pehlay excel ki sheet theek say upload nahi hoi thi lihaza abb excel ki sheet update kr dee hai app excel ki sheet say daikh saktay hain
Last edited by MUKHLAS; 1st April 2014 at 06:09 PM.

8. Senior Member+
Last Online
20th April 2015 @ 09:57 PM
Join Date
11 Mar 2009
Age
36
Posts
580
38
Credits
965
Thanked
34
I think Pivot Table Report method is best for this job

9. Member
Last Online
4th April 2014 @ 11:55 AM
Join Date
14 Mar 2014
Gender
Male
Posts
143
18
Credits
0
Thanked
18
DIGITAL_PAINDU said:
I think Pivot Table Report method is best for this job

app ki baat ki samhaj nahi aaey

10. Member
Last Online
4th April 2014 @ 11:55 AM
Join Date
09 Mar 2014
Gender
Male
Posts
445
18
Credits
0
Thanked
24
mukhlas said:
mujay app k sawal ka jawab mil geya hai main share bhi kr dayta hoon

agr kisi coloum main ap daikhna chatay hain k aik khas lafaz kitni bar aya hai tu us ka forumala yeh hai

misaal k toor pe app dakihna chatay hain k "p" kitney dafa likha geya hai tu likhain

=countif(i7:i28,"p")

formula walay dubay ko gerenal main formate krna hai
mukhlas said:
i7 row & coloum ko show kr raha hai isi tarah i28 bhi ...
mukhlas said:
kisi kism ka masal ho tu rabta kr saktay hain sample sheet main upload kr raha hoon daikh saktay hain download kr k

note pehlay excel ki sheet theek say upload nahi hoi thi lihaza abb excel ki sheet update kr dee hai app excel ki sheet say daikh saktay hain
digital_paindu said:
i think pivot table report method is best for this job
mukhlas said:

app ki baat ki samhaj nahi aaey
faisal_zia said:
mujay mukhlas bhai k samjhanay ka tareeqa bohat acha laga

mujay takreeban 5 saal honay walay hain main excel use kr raha hoon mujay excel main data banana bohat hi asaan lagta hai main sooch raha hoon k main yaha excel k formulas class start kr loon daily aik formula app ko parhaoon aur us ka use bataoon agr sab bhai is say mutafiq hain to main excel fourmula class start kr layta hoon

jo app logoon k leyay bohat hi knowledgeable hoo gee

mujay zaida english tu nahi atey bas roman urdu main hi samjha sakta hoon

app sab bahioun k reply ka bohat shukereya mujay formula samhaj aa geya hai

11. mukhlas said:
mujay app k sawal ka jawab mil geya hai main share bhi kr dayta hoon

agr kisi coloum main ap daikhna chatay hain k aik khas lafaz kitni bar aya hai tu us ka forumala yeh hai

misaal k toor pe app dakihna chatay hain k "p" kitney dafa likha geya hai tu likhain

=countif(i7:i28,"p")

formula walay dubay ko gerenal main formate krna hai
thanks bhai

12. Nice

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•