true power of MS excel. update: PowerBI

[hehe13]

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

pa post ng sheet.. use d-h.st or http://www.datafilehost.com/

pero tingin ko yang issue mo pwedeng ma solve using find duplicates under conditional formatting..

 

[lovely14]

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

Hi mga boss! Patulong naman po. Ganito po kasi. May isang value po ako na naka batch (maraming laman na amount). Then, meron po ako na yung per amount lang. May way po ba na mas mapabilis kung mamatch yung per amount ko na value dun sa batch value (kasi marami batch, so kelangan maidentify ko kung san batch yung per amount ko na value kasama)? Salamat po ng marami!

actually hindi ko po nagets hehe, pero hmm hindi ba kayang vlookup function? or index and match function? pwede ba screenshot ?

Thanks

 

[ampipi]

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

actually hindi ko po nagets hehe, pero hmm hindi ba kayang vlookup function? or index and match function? pwede ba screenshot ?

Thanks

Hi po! Thanks po sa pgsagot. Nag-attach po ako ng sample. Yung same color. Yun po yung magkakamatch. May formula po ba or macro na makakapagpabilis po dun sa paghanap ko ng magkamatch. Kasi trial and error lang po ako. (Yung ginagawa ko po kasi umaabot minsan sa 100 yung mga values na kelangan ko i-match kaya po matagal po bago ko matapos). Salamat po ulit!!

 

[heleina]

Re: MS excel reportings, presentations, and vba helping thre

ok po yung thread nyo.

 

[ampipi]

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

pa post ng sheet.. use d-h.st or http://www.datafilehost.com/

pero tingin ko yang issue mo pwedeng ma solve using find duplicates under conditional formatting..

Hi boss. Nag attach po ako ng sample image. Bale yung magkakaparehas po ng color yung magkamatch. May way po ba para mapabilis pagmamatch ko. Trial and error po kasi ginagawa ko ngayon. Salamat po!!

 

[hehe13]

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

Highlight both Column > Conditional formatting > Highlight Cell Rules > Duplicate Values.

Using Formula > =MATCH(B1,A:A,0)

 

[ampipi]

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

Highlight both Column > Conditional formatting > Highlight Cell Rules > Duplicate Values.

http://i.imgur.com/8BbbFCo.gif

Using Formula > =MATCH(B1,A:A,0)

http://i.imgur.com/wTA9Z1c.gif

Hi po! Salamat po sa pagsagot kaya lang po di ko magets. May inupload po ako na excel file dun sa link na binigay nyo. Pacheck po kung pano nyo po mamatch yung mga values. Maraming salamat po!

Eto po download link: http://www.datafilehost.com/d/58fcff1b

 

[lovely14]

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

Hi po! Thanks po sa pgsagot. Nag-attach po ako ng sample. Yung same color. Yun po yung magkakamatch. May formula po ba or macro na makakapagpabilis po dun sa paghanap ko ng magkamatch. Kasi trial and error lang po ako. (Yung ginagawa ko po kasi umaabot minsan sa 100 yung mga values na kelangan ko i-match kaya po matagal po bago ko matapos). Salamat po ulit!!

actually parang impossible to kung walang ibang helper column man lang ,pero kayang gawin pero matagal i think, kasi napansin ko dto isusum yung nasa per amount ,tapos yung sum ng per amount is imamatch dun sa batch value ,tama ba?...

https://drive.google.com/file/d/0B_gWAZ4O0Nh8Q04tRVRSNEtOQTQ/view?usp=sharing

eto lang yung nagawa ko, kaso dto, kung ano lang yung meron sa per amount na column imamatch nya dun sa batch value na column, (i.e., hndi nya isusum yung per amount column)



View attachment 245687

Please see attached image, Sample ko po ng may helper column

 

[angelkanz]

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

nice thanks sir

 

[tilawiko]

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

paano poh mag deploy ng system poh sir? ung system po na gawa lng lng sa ms access poh...

 

[lovely14]

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

paano poh mag deploy ng system poh sir? ung system po na gawa lng lng sa ms access poh...

pano pong system? hmm from vb6 po ba to pero ginamitan ng microsoft access para sa database?

 

[hehe13]

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

Hi po! Salamat po sa pagsagot kaya lang po di ko magets. May inupload po ako na excel file dun sa link na binigay nyo. Pacheck po kung pano nyo po mamatch yung mga values. Maraming salamat po!

Eto po download link: http://www.datafilehost.com/d/58fcff1b

Hmm mali pag kakaintindi ko..

So parang yung nasa right ay sum nung nasa left column. At gusto mong mkuha yung yung addends from the left column. (?)

 

[RestyPalacay]

Re: MS excel reportings, presentations, and vba helping thre

pa bm po ts

- - - Updated - - -

pa save po muna

 

[lovely14]

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

Hmm mali pag kakaintindi ko..

So parang yung nasa right ay sum nung nasa left column. At gusto mong mkuha yung yung addends from the left column. (?)

Yeah ganun ata sir hehe13

 

[ampipi]

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

Hmm mali pag kakaintindi ko..

So parang yung nasa right ay sum nung nasa left column. At gusto mong mkuha yung yung addends from the left column. (?)

Yes Sir. Ganun nga po. Thanks po!

 

[lovely14]

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

Yes Sir. Ganun nga po. Thanks po!

Can i see the entire excel workbook? .may google drive ka ba, pwede mo run iupload tapos share mo na lang

kasi need ko makita baka pwede natn gawan ng ibang paraan,

pero kung confidential, sige wag na po haha

 

[nradexuz]

Re: MS excel reportings, presentations, and vba helping thre

tnx dito TS! pa-subs ako!

 

[tilawiko]

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

pano pong system? hmm from vb6 po ba to pero ginamitan ng microsoft access para sa database?

my ginawa po kz akong system...sa access lng poh talaga xa,ni link q po ung excel po na file dun para lang maprint q lang po ung isang data ng isang tao lng poh..

 

[lovely14]

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

my ginawa po kz akong system...sa access lng poh talaga xa,ni link q po ung excel po na file dun para lang maprint q lang po ung isang data ng isang tao lng poh..

you mean sa "system" nakaprogram as vba pero ms access?, bale ano po ba exactly ang problem? thanks

 

[jerryxon]

Re: MS excel reportings, presentations, and vba helping thre

thank you dito master pa download