true power of MS excel. update: PowerBI

mintond · Nov 24, 2016

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

mga ser,

not sure if this has been asked on the previous posts pero ask lang po if it is possible to filter a column with more than two criteria tapos with wilcard.

with activesheet.cells(1, 1).currentregion
.AutoFilter Field:=1, Criteria1:="=Brian*", Operator:=xlOr, Criteria2:="=*John"
end with

that one works with two criteria, pero pano pag more than 2 na?

thanks!

kirby21 · Nov 24, 2016

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

mintond said:
mga ser,

not sure if this has been asked on the previous posts pero ask lang po if it is possible to filter a column with more than two criteria tapos with wilcard.

with activesheet.cells(1, 1).currentregion
.AutoFilter Field:=1, Criteria1:="=Brian*", Operator:=xlOr, Criteria2:="=*John"
end with

that one works with two criteria, pero pano pag more than 2 na?

thanks!

use advanced filter.

ganto.

View attachment 294465

must have two sheets. 1st sheet is raw data you wanted to filter. 2nd sheet another list of keyword you wanted to search

note: they must have same exact headers.

tip: you can have more columns too.

hope this helps.

mintond · Nov 24, 2016

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

Thank you sir! It helped a lot!

St Sinned · Nov 27, 2016

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

Master, ganito po kasi, meron po ako mga worksheets sa isang workbook. Plano ko po kasi maglagay mg command button naka pag pinindot mo sya, mag oopen ang certain sheet na gusto iopen. And then same button din po sana ang pipindutin para mag hide po ulit sya, kaya po ba yun? Pahingi naman po ng VBA code nya. At saka po gusto ko rin po sana gumawa ng search button para sa isang database tapos lalabas po yung mga details kapag naginput po ako ng account number...TIA

bytesize · Nov 27, 2016

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

St Sinned said:
Master, ganito po kasi, meron po ako mga worksheets sa isang workbook. Plano ko po kasi maglagay mg command button naka pag pinindot mo sya, mag oopen ang certain sheet na gusto iopen. And then same button din po sana ang pipindutin para mag hide po ulit sya, kaya po ba yun? Pahingi naman po ng VBA code nya. At saka po gusto ko rin po sana gumawa ng search button para sa isang database tapos lalabas po yung mga details kapag naginput po ako ng account number...TIA

sir kung gusto mo i-open yung sheet, click mo nalang sa baba yung sheet tab mas madali pa. para naman dun sa search with multiple occurances, hanapin mo yung post ko "search formula" http://www.symbianize.com/showthread.php?t=1132342&page=151&highlight=excel

St Sinned · Nov 27, 2016

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

bytesize said:
sir kung gusto mo i-open yung sheet, click mo nalang sa baba yung sheet tab mas madali pa. para naman dun sa search with multiple occurances, hanapin mo yung post ko "search formula" http://www.symbianize.com/showthread.php?t=1132342&page=151&highlight=excel

Hahaha...sabagay, tama ka sir...mas neat kasi tignan kapag ganun...anyway, nagawa ko rin naman po yung gusto ko. Naglagay po ako ng command button na kapag click mo sya, magoopen yung sheet na click mo. And then dun sa na-open na sheet naglagay din ako command button na kapag click mo sya, mag-hide sya... Thanks sa link, try ko po...

joperd · Nov 30, 2016

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

Mga masters Question.

Meron akong folders na puno ng excel files tas same lang naman sila ng headers.
Gusto ko sana icopy lahat ng laman ng isang buong folder sa isang excel file.
Kaya lang kasi more than 100 ung files sa isang folder.
thanks sa makakatulong.

kirby21 · Nov 30, 2016

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

joperd said:
Mga masters Question.

Meron akong folders na puno ng excel files tas same lang naman sila ng headers.
Gusto ko sana icopy lahat ng laman ng isang buong folder sa isang excel file.
Kaya lang kasi more than 100 ung files sa isang folder.
thanks sa makakatulong.

madaming ways para dyan

Code:

 Dim wbList() As String, wbCount As Integer, i As Integer
        FolderName = "C:\Foldername"
        ' create list of workbooks in foldername
        wbName = Dir(FolderName & "\" & "*.xls")
        While wbName  ""
           -- get info, per any of the links you've already been given --
        Wend

kirby21 · Dec 7, 2016

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

pa up lang mga boss

bytesize · Dec 11, 2016

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

angat lng ng konte

Sniper · Dec 16, 2016

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

Sir can you help me how to create free pick for STL 2/38 tnx in advance!

kirby21 · Dec 16, 2016

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

Sniper said:
Sir can you help me how to create free pick for STL 2/38 tnx in advance!

please we all have different fields. please explain further.

St Sinned · Dec 17, 2016

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

Master, paturo naman po. Ganito po, sa isang workbook may tatlong sheet, TEMPLATE, WILL INPUT DATA, SOURCE. Ang gusto ko po sana mangyari ay kapag naglagay po ako ng data sa "WILL INPUT DATA" tapos kapag pinundot mo ang enter mabubura yung nasa "WILL INPUT DATA" at mapupunta po sya sa designated place that will match kung ano yung nasa "TEMPLATE" at mapupunta po din sya sa "SOURCE"...Attached file is my template...TIA....

darcho · Dec 17, 2016

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

Kailangan ko to salamat po

Sniper · Dec 17, 2016

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

kirby21 said:
please we all have different fields. please explain further.

Sir ganito po yun bale ang draw nila ay 1 to 38 tapos ang tatayaan mo ay 2 digit lang halimbawa 1x38 ang lumabas. Gusto ko sana magkaroon ng free pick sa excel 2016 po gamit ko o kaya probability sa mga tumama sa loob ng isang taon para malaman ko kung ano ang malalakas na numero na pwede ko tayaan. yan po ang Small Town Lottery na pinalit ng government sa jueteng. Sana po matulungan u me salamat po ng marami.

kirby21 · Dec 19, 2016

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

Sniper said:
Sir ganito po yun bale ang draw nila ay 1 to 38 tapos ang tatayaan mo ay 2 digit lang halimbawa 1x38 ang lumabas. Gusto ko sana magkaroon ng free pick sa excel 2016 po gamit ko o kaya probability sa mga tumama sa loob ng isang taon para malaman ko kung ano ang malalakas na numero na pwede ko tayaan. yan po ang Small Town Lottery na pinalit ng government sa jueteng. Sana po matulungan u me salamat po ng marami.

you need forecasting bro. kung makapag provide ka ng history madali lang yan. kahit 1year

bytesize · Dec 20, 2016

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

sorry sir, you can't predict it. if you want to know the probability of a winning combination (any combination will have the same probability of being drawn), it's 38!/(2!(38-2)!) = 703 or 1 in 703 or 0.0014 % (a little more than a 10th of a percent) per combination. Fixed ang house edge nyan in favor of the house at walang way para ma shift sa favor mo (unless lumaki yung jackpot ng maybe 100 million). I know bad news para saiyo pero kung hindi mo maintindihan yung math sa likod nyan, i suggest huwag ka na po tumaya. If you really are into gambling, i suggest games na hindi fixed ang house edge. Sports betting (gawa kang predicitive model gaya ng sabi ni sir kirby), blackjack (card counting). Good luck.

Sniper · Dec 20, 2016

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

kirby21 said:
you need forecasting bro. kung makapag provide ka ng history madali lang yan. kahit 1year

Sorry Sir hindi po yan need ko free pick po sabi ko na pag click mag auto sya para maka bigay sayo ng kung ano pwede u tayaan....at kung di mo naman kaya ok lng..

bytesize said:
sorry sir, you can't predict it. if you want to know the probability of a winning combination (any combination will have the same probability of being drawn), it's 38!/(2!(38-2)!) = 703 or 1 in 703 or 0.0014 % (a little more than a 10th of a percent) per combination. Fixed ang house edge nyan in favor of the house at walang way para ma shift sa favor mo (unless lumaki yung jackpot ng maybe 100 million). I know bad news para saiyo pero kung hindi mo maintindihan yung math sa likod nyan, i suggest huwag ka na po tumaya. If you really are into gambling, i suggest games na hindi fixed ang house edge. Sports betting (gawa kang predicitive model gaya ng sabi ni sir kirby), blackjack (card counting). Good luck.

alam ko din po yan Sir pero ang tulong na hinahanap ko po ay yung free pick para kang tataya sa lotto na hindi kana bibigay numbers yung machine na lng bibigay sayo numbers at babayad kana lng yan din po gusto ko na mangyari naka excel version 2016 kaso sa PC lang po hindi sa lotto outlet.

may nakita na ako dati rito sa symbianize kaso di ko na mahanap....

kirby21 · Dec 21, 2016

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

Sniper said:
Sorry Sir hindi po yan need ko free pick po sabi ko na pag click mag auto sya para maka bigay sayo ng kung ano pwede u tayaan....at kung di mo naman kaya ok lng..

alam ko din po yan Sir pero ang tulong na hinahanap ko po ay yung free pick para kang tataya sa lotto na hindi kana bibigay numbers yung machine na lng bibigay sayo numbers at babayad kana lng yan din po gusto ko na mangyari naka excel version 2016 kaso sa PC lang po hindi sa lotto outlet.

may nakita na ako dati rito sa symbianize kaso di ko na mahanap....

no i am right. the algorithm behind it ay forecasting.

bytesize · Dec 21, 2016

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

Sniper said:
Sorry Sir hindi po yan need ko free pick po sabi ko na pag click mag auto sya para maka bigay sayo ng kung ano pwede u tayaan....at kung di mo naman kaya ok lng..

alam ko din po yan Sir pero ang tulong na hinahanap ko po ay yung free pick para kang tataya sa lotto na hindi kana bibigay numbers yung machine na lng bibigay sayo numbers at babayad kana lng yan din po gusto ko na mangyari naka excel version 2016 kaso sa PC lang po hindi sa lotto outlet.

may nakita na ako dati rito sa symbianize kaso di ko na mahanap....

eto sir simple lucky pick macro

code:

Private Sub CommandButton1_Click()

Dim x, lrandomnumber, lrandomnumber2 As Integer

Randomize

lrandomnumber = Int((38 - 1 + 1) * Rnd + 1)
lrandomnumber2 = Int((38 - 1 + 1) * Rnd + 1)

Do While lrandomnumber = lrandomnumber2
Randomize
lrandomnumber2 = Int((38 - 1 + 1) * Rnd + 1)
Loop

x = Application.WorksheetFunction.CountA(Sheet1.Range("a1:a200000")) + 1

Sheet1.Cells(x, 1) = lrandomnumber
Sheet1.Cells(x, 2) = lrandomnumber2

End Sub

true power of MS excel. update: PowerBI

Recruit

The Martyr

Attachments

Recruit

Proficient

Apprentice

Proficient

Apprentice

The Martyr

The Martyr

Apprentice

Proficient

The Martyr

Proficient

Attachments

Proficient

Proficient

The Martyr

Apprentice

Proficient

The Martyr

Apprentice

Attachments

Similar threads