What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

true power of MS excel. update: PowerBI

Re: MS excel formula, programming, analysis, presentation and tutorials.

ryujine017 said:
hello TS, pahelp po, sa Column A, gusto ko kunin yung mga cell na may value na "1", then kukunin ko naman sa Column B lahat ng katapat ng "1" na may value na "Complete",

kunwari po ito:
A B
1 Complete
1 Complete
1 Complete
1 Complete
1 Not Complete
2 Complete
2 Complete
2 Complete
2 Complete
2 Not Complete

so bale dyan, dapat pag nagcount yung formula, 4 dapat yung macocount nya since 4 yung Complete na katapat ng "1"



thanks po :)
Click to expand...

=countifs(A:A,1,B:B,"Complete")
 
Patulong po TS....

Good day po TS.. ito na po yong bagong file problem (with explanation kung ano ang mangyayari if mag i-input ka ng number...)
help naman po TS kung pano gawin ito...


Salamat TS
 

Attachments

  • Problem01.rar
    9.3 KB · Views: 13
Re: Patulong po TS....

kensh80 said:
Good day po TS.. ito na po yong bagong file problem (with explanation kung ano ang mangyayari if mag i-input ka ng number...)
help naman po TS kung pano gawin ito...


Salamat TS
Click to expand...

hope this may help. cheers!:p
 

Attachments

  • Problem01.rar
    17 KB · Views: 40
Re: MS excel reportings, presentations, and vba helping thre

boss salamat dito! very useful! :clap: :thumbsup:
 
Re: Patulong po TS....

kensh80 said:
patulong naman po kung pano un ginawa??? di ko po na gets kung pano ginawa yun.... :(


Salamat po! :)
Click to expand...

using some codes in vba. is it useful or else explain if I need to modify some part:dance: cheers
 
Last edited:
Re: Patulong po TS....

dmquitoriano0222 said:
using some codes in vba. is it useful or else explain if I need to modify some part:dance: cheers
Click to expand...

opo.. nakatulong nga po sa akin.. kaso di ko alam kung pano ginawa sa VBA? pwede po ba malaman kung anong structures sa VBA? send u naman po ung VBA structure kung pa ano... slamat in advance po..
 
Last edited:
Re: MS excel formula, programming, analysis, presentation and tutorials.

hi TS pano po ba yung nsa page 1 nyo po.. yong sales vs returns and cancellations dashboard po. ang ganda kasi pagkakagwa, excel ano po gamit nyo??
tas yung pangalawang dashboard po ang galing din. gusto ko po matuto kung pano po yon.

thanks TS.
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

(Problem 1)

How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)


(Problem 2) New Excell po(Same as Problem 1, but this Problem 2 have a conditional)
How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)

example: In sheet2 : I put abscde123 and the value is 50000
pero yung nasa sheet1(database/raw data) abcde123 value niya 25000 lang so kulang po, so need pa magloop hanggang sheet1 is greater than sheet1 (at yung result niya dapat in sheet3...ok lang po kahit abcd1445 masearch niya basta same sila ng first 4letters

Thank You po
(sheet3 po mailalagay yung result niya)
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

Hi Masters, quick question po. Meron po akong cell table 10x10 na may data (words). Gusto ko po kasi siya icount kung ilang beses naulit yung isang word. Brute-force po kasi ginagawa ko, nilalagay ko siya sa column, tapos remove duplicate, then countif sa original list sa column. Salamat sa makakasagot! :)
 
Last edited:
Re: MS excel formula, programming, analysis, presentation and tutorials.

frankoy27 said:
Hi Masters, quick question po. Meron po akong cell table 10x10 na may data (words). Gusto ko po kasi siya icount kung ilang beses naulit yung isang word. Brute-force po kasi ginagawa ko, nilalagay ko siya sa column, tapos remove duplicate, then countif sa original list sa column. Salamat sa makakasagot! :)
Click to expand...

here hope may help you.

simple pivot table will do the trick. cheers!:dance:
 

Attachments

  • Book1.rar
    10.2 KB · Views: 39
Re: MS excel formula, programming, analysis, presentation and tutorials.

Sir dmquitoriano0222 bat ako wala? :weep:

eto po

(Problem 1)

How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)


(Problem 2) New Excell po(Same as Problem 1, but this Problem 2 have a conditional)
How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)

example: In sheet2 : I put abscde123 and the value is 50000
pero yung nasa sheet1(database/raw data) abcde123 value niya 25000 lang so kulang po, so need pa magloop hanggang sheet1 is greater than sheet1 (at yung result niya dapat in sheet3...ok lang po kahit abcd1445 masearch niya basta same sila ng first 4letters

Thank You po
(sheet3 po mailalagay yung result niya)
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

uchihasasuke said:
Sir dmquitoriano0222 bat ako wala? :weep:

eto po

(Problem 1)

How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)


(Problem 2) New Excell po(Same as Problem 1, but this Problem 2 have a conditional)
How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)

example: In sheet2 : I put abscde123 and the value is 50000
pero yung nasa sheet1(database/raw data) abcde123 value niya 25000 lang so kulang po, so need pa magloop hanggang sheet1 is greater than sheet1 (at yung result niya dapat in sheet3...ok lang po kahit abcd1445 masearch niya basta same sila ng first 4letters

Thank You po
(sheet3 po mailalagay yung result niya)
Click to expand...

pasensya po busy sa work this past days. anyways I'll try to solve this.

cheers
 
Last edited:
Re: MS excel formula, programming, analysis, presentation and tutorials.

TY po, ill wait that sir. :)
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

uchihasasuke said:
Sir dmquitoriano0222 bat ako wala? :weep:

eto po

(Problem 1)

How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)


(Problem 2) New Excell po(Same as Problem 1, but this Problem 2 have a conditional)
How to filtering/compare yung sheet1 and sheet2 tapos yung result eh sa sheet3

ex: Sheet1 = dito yung mga raw data(database)
sheet2 = dun ko ilalagay kung ano gusto ko isearch
sheet3 = dun yung mailalagay yung sinearch ko (meaning dito po yung result na nasearch)

example: In sheet2 : I put abscde123 and the value is 50000
pero yung nasa sheet1(database/raw data) abcde123 value niya 25000 lang so kulang po, so need pa magloop hanggang sheet1 is greater than sheet1 (at yung result niya dapat in sheet3...ok lang po kahit abcd1445 masearch niya basta same sila ng first 4letters

Thank You po
(sheet3 po mailalagay yung result niya)
Click to expand...

see attached file and sample -- mejo magulong tanong mo or kulang yung info, kung may kulang sabihin mo lang.. =]

YorZxFj.gif
 

Attachments

  • Book2.rar
    7.3 KB · Views: 70
Re: MS excel formula, programming, analysis, presentation and tutorials.

Good morning guys.

im currently working as logistic associate from a supply chain.

and we are looking for another data analyst. or an excel guru or expert. with business side analysis. (Merchandizing department to be specific). its a plus but not must have. willing to work from panay avenue quezon city.

please contact me at my skype name

sysubaesa_darell
 
Last edited:
Re: MS excel formula, programming, analysis, presentation and tutorials.

Hi po mga kuya expert sa excel, maaari nyo po ba akong tulungan? pwede po bang mag formula na hindi na copy and paste yung gagawin sa pagkuha ng previous data of employee para sa susunod na payroll... Thanks in advanced

View attachment 269839
View attachment 269840
 

Attachments

  • jan 1-15.jpg
    jan 1-15.jpg
    268.1 KB · Views: 34
  • jan 16-30.jpg
    jan 16-30.jpg
    228.9 KB · Views: 28
You must log in or register to reply here.

Similar threads

R
Please Help me datagridview rearange
Replies
0
Views
355
rapsoyso09
R
&watag
Excel Visual Basic Application
Replies
4
Views
1K
walo
walo
N
Data entry to other workbook excel vba
Replies
2
Views
648
neil1188
N
God love us
For Excel VBA expert only
Replies
0
Views
606
God love us
God love us
Patch2012
Excel VBA Incrementing Code [HELP]
Replies
4
Views
606
arcajx
arcajx
Back
Top Bottom