true power of MS excel. update: PowerBI

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

Tanung lang po, panu po ba ang formula ng date difference ng dalawang date without sundays?
Example
A1
3/2/2015
A2
3/9/2015
A3
6

Pahelp naman po. Thanks in advance!

ganto po.

=networkdays.intl(a1,a2,11,)-1

take note excel 2010 pataas po dapat gamit nyo.

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir eto n lng po pa help po gusto ko po makuha ung Column Result sa Column F8 ang nasa Column C8

sample

range ko po ng start at end nsa screen shot
tapos ung gusto ko lng ma display na date sa column F8 ay ung C8
lang po na 4/7/2015

pede po makahingi ng code pano siya gawin?

 

[xplore]

Re: MS excel we give solutions. formula, codes and tutorials.

ayos to.. pasubscribe ts.... pag aralan ko ton g mga to

 

[jocno1212]

Re: MS excel we give solutions. formula, codes and tutorials.

ganto po.

=networkdays.intl(a1,a2,11,)-1

take note excel 2010 pataas po dapat gamit nyo.

Wala pu bang pang 2007??? hai. hehe. Thanks!

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

Wala pu bang pang 2007??? hai. hehe. Thanks!

gawa ka ng worksheet ilagay mo lahat ng sunday dun. let's say 03/08/2015,03/15/2015,03/22/2015,03/29/2015.
kuyari nasa sheet2 a1 nagstart ang mga sundays mo pababa

ang formula mo is

=networkdays(a1,a2,sheet2!a1:a4)

- - - Updated - - -

Sir eto n lng po pa help po gusto ko po makuha ung Column Result sa Column F8 ang nasa Column C8

sample

range ko po ng start at end nsa screen shot
tapos ung gusto ko lng ma display na date sa column F8 ay ung C8
lang po na 4/7/2015

pede po makahingi ng code pano siya gawin?

based sa input mo. bakit 04/07/2015 ang gusto mo makuha? kailangan ko yung basis mo kasi for math thing or calculations eh. hehehe

 

[ohj_17]

Re: MS excel we give solutions. formula, codes and tutorials.

Active pa ba ito, bka meron kyo way para matangal ung password ng excel file,. nakalimutan kasi eh.. thanks po sa makakatugon

 

[jocno1212]

Re: MS excel we give solutions. formula, codes and tutorials.

gawa ka ng worksheet ilagay mo lahat ng sunday dun. let's say 03/08/2015,03/15/2015,03/22/2015,03/29/2015.
kuyari nasa sheet2 a1 nagstart ang mga sundays mo pababa

ang formula mo is

=networkdays(a1,a2,sheet2!a1:a4)

- - - Updated - - -
based sa input mo. bakit 04/07/2015 ang gusto mo makuha? kailangan ko yung basis mo kasi for math thing or calculations eh. hehehe

Ok na boss, nagawan ko na ng woraround via VBA code. TIA

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

Active pa ba ito, bka meron kyo way para matangal ung password ng excel file,. nakalimutan kasi eh.. thanks po sa makakatugon

anong nakalocked? worksheet o workbook?

 

[pinkblack888]

Re: MS excel we give solutions. formula, codes and tutorials.

Pa-BM muna TS. Salamat, malaking tulong to sa lahat.

 

[cruxito]

Re: MS excel we give solutions. formula, codes and tutorials.

pa subscribe ako fave ko ang excel kaso wala ako alam na formula

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

Boss bka pde pong makahinge ng graphic control tutorial or step by step pano nyo po ginawa magagamit ko po kase sia sa report na hinihingi ng boss ko please boss advance thank you boss paki mail n lng po or post nyo po sa threads nyo po..

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

Boss bka pde pong makahinge ng graphic control tutorial or step by step pano nyo po ginawa magagamit ko po kase sia sa report na hinihingi ng boss ko please boss advance thank you boss paki mail n lng po or post nyo po sa threads nyo po..

nasa first page yung graphs with controls.

pili k nlng dun. may tutorials din.

- - - Updated - - -

pa subscribe ako fave ko ang excel kaso wala ako alam na formula

ano po ba gusto mo matutunan?

- - - Updated - - -

Pa-BM muna TS. Salamat, malaking tulong to sa lahat.

balik ka lang po.

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

opo nakita ko po un sa first page pero wla po ung tutorial po kase pic lang po sia
d ko lam pano nyo gnawa sa list view po na nag babago ung graphic sa baba

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

opo nakita ko po un sa first page pero wla po ung tutorial po kase pic lang po sia
d ko lam pano nyo gnawa sa list view po na nag babago ung graphic sa baba

pacheck nito boss.

 

[th3j3st3r]

Re: MS excel we give solutions. formula, codes and tutorials.

TS patulong sa problem kung ito.

Attached sa photo is a simple spreadsheet sa file na gusto kung gawan ng functions.

On the status column, meron 3 choices namely: Issued, Cancelled, Uncollected. Ang gusto kung mangyari is when i select issued, i want the current date and time which uses (NOW()) to be automatically inputed in the column of issued date&time. Same goes if I select cancelled, then the current date and time will be automatically appear in the column of cancelled date&time.

Papaano kaya to TS, may possibility ba na magawa to?

Sana may makatulong. thanks in advance

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

Sir pa help nmn po need na need ko ung sagot nito wla tlga akong makitang solution sa net

Eto po ung ask ko
hindi nya po na count ung same date of start date and end date po pano po ba sia nakakasama sa result

angnabibilang nya lng po eh ung 3/3-3/5 po dapat pati ung 3/2 nakakasama

ang nagiging result po kase
=is 1.5
dapat po 1.75

eto po ung code ko

=IF(SUMIFS('Applicants Tracking_2015'!BS:BS,'Applicants Tracking_2015'!I:I,$C$2,'Applicants Tracking_2015'!K:K,$D$2,'Applicants Tracking_2015'!G:G,"( Audit ) Secretary",'Applicants Tracking_2015'!J:J,"Passed")>0,SUMIFS('Applicants Tracking_2015'!BS:BS,'Applicants Tracking_2015'!I:I,$C$2,'Applicants Tracking_2015'!K:K,$D$2,'Applicants Tracking_2015'!G:G,"( Audit ) Secretary",'Applicants Tracking_2015'!J:J,"Passed")/COUNTIFS('Applicants Tracking_2015'!I:I,$C$2,'Applicants Tracking_2015'!K:K,$D$2,'Applicants Tracking_2015'!G:G,"( Audit ) Secretary",'Applicants Tracking_2015'!J:J,"Passed"),"0")

eto po ung data koView attachment 207149




Boss dito na lng po ako magpapasalamat regarding sa graphic control po na tutorial big help po sa akin
hindi ako makapag post eh d ko alam kung bakit nag error dun sa ask ng system kpag sinasagot ko laging mali daw

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

TS patulong sa problem kung ito.

Attached sa photo is a simple spreadsheet sa file na gusto kung gawan ng functions.

On the status column, meron 3 choices namely: Issued, Cancelled, Uncollected. Ang gusto kung mangyari is when i select issued, i want the current date and time which uses (NOW()) to be automatically inputed in the column of issued date&time. Same goes if I select cancelled, then the current date and time will be automatically appear in the column of cancelled date&time.

Papaano kaya to TS, may possibility ba na magawa to?

Sana may makatulong. thanks in advance

kailangan natin macro boss. ok lang ba?

 

[Leonidas]

Re: MS excel we give solutions. formula, codes and tutorials.

Thank you! Sir. Helpful na thread. Pa-BM.

 

[acelleb]

Re: MS excel we give solutions. formula, codes and tutorials.

TS patulong sa problem kung ito.

Attached sa photo is a simple spreadsheet sa file na gusto kung gawan ng functions.

On the status column, meron 3 choices namely: Issued, Cancelled, Uncollected. Ang gusto kung mangyari is when i select issued, i want the current date and time which uses (NOW()) to be automatically inputed in the column of issued date&time. Same goes if I select cancelled, then the current date and time will be automatically appear in the column of cancelled date&time.

Papaano kaya to TS, may possibility ba na magawa to?

Sana may makatulong. thanks in advance

Gamit ka lng if else formula ng column issued datetime at cancelled datetime.
Check mo ung attachment.

 

[th3j3st3r]

Re: MS excel we give solutions. formula, codes and tutorials.

kailangan natin macro boss. ok lang ba?

okay lang sir kirby21, mas maganda na din kung naka macro sya. salamat in advance.

Gamit ka lng if else formula ng column issued datetime at cancelled datetime.
Check mo ung attachment.

seen this, one follow up question sir. paano ko sya e timestamp on that specific cell, since every choice that i make ay ilalagay sa specific cell.