Search results

Last but best solution, if this is regular query then you can ask your DBA team to create stored procedure or view (this is one time activity from DBA end) then you can run query on this with your condition and if you still want to build query thru excel /vba then you have to create multiple...

Hope you got your answers with Bosco's formula, this is simple and easy to understand.

Because your query is too large and it may be challenging to verify or validate in VBE window.

Suggestion from my side - it could be better if you can save your query somewhere in excel sheet with dynamic changes and then pull query in your vba code.

Hi Ratan, if this is static thn you can convert this querey into one line.

HI GeraldDLT, See if this help

Hi Manny, Best match on what bases?

try second formula =IF(AND(AP4="completed",IF(OR(I4="PP",I4="p"),IF(OR(M4="PP",M4="P"),IF(OR(O4="PP",O4="P"),IF(OR(Q4="PP",Q4="P"),TRUE,FALSE))))),"Pass","")

your formula, revised version =IF(AND(AP4="completed",IF(OR(I4="PP",I4="p"),IF(OR(M4="PP",M4="P"),IF(OR(O4="PP",O4="P"),IF(OR(Q4="PP",Q4="P"),TRUE,FALSE))))),"Pass","Fail")

try this simple formula - =IF(AND(AP4="completed",LEN(SUBSTITUTE(CONCATENATE(I4,M4,O4,Q4),"P",""))=0),"Pass","Fail")

Hi Jb, Please see if this is ok

Hi sasuke, This is very conman requirement, i suggest first search this on google and this forum search option (top right). see below some useful urls - http://www.ozgrid.com/forum/showthread.php?t=179124 https://www.reddit.com/r/vba/comments/3o8rub/smart_search_on_userform_combobox_dropdown/...

Hi SONJOE, You can find and replace dashes "-" with zero 0 or filter out dashes in your formula only like =AVERAGEIF(P4: P102,"<>-",P4: P102) Also, i don't thing you need to remove dashes for calculation, dashes is already filter out in formula without doing anyting

Opps!!, Hi Rethish, XL2007 does not support networkdays.intl., request you to please make changes as per below url http://www.mrexcel.com/forum/excel-questions/494270-alternate-option-networkdays-intl.html

Hahah @GeraldDLT, Chihiro trying to say, search your query on google first.

On my side both fields (dates) are same e.g. 5-Aug-2016

Hi Rethish, Have changed both (formula and conditional formatting), please check

Hi All, Have tried to built Sampling random Add-in, please review and let me know. This version, have built for more than one component (filed) or partition random values. If you want to use this for one or no partition value then just insert one column with same value (like 1 or 2) and run...

Hi Rethish, First change, conditional formatting Second change, NETWORKDAYS formula to NETWORKDAYS.INTL (NETWORKDAYS.INTL(start_date,end_date,16,holiday))

Hi Rethish Please take reference from below url http://chandoo.org/forum/threads/attendance-calendar-help.30988/#post-184476

Could you please upload sample file with desire output ?

Hi Ram, If this is the case (as mentioned in excel), you can just add 0 to get proper formate.

Hi HanSam, This is possible thru VBA. See if this is OK.

Hi , Can anyone guide me how to make Sampling stratified random sampling

Hi Sunny, This is due to the calculated filed works on all rows thats why unnecessary rows comes. There is no way to remove these unnecessary rows, you only either calculate "difference" in your raw data or filter out "0" in pivot table Thanks