Break string to formula

[Marc L]

LoL !

Maybe … So the problem is between chair and monitor !
Leave computer, just a paper and a pen, often it opens mind …
​

It's not difficult to attach a .xlsx workbook with real source strings and
a column for each data expected by function !
With as many rows as possible cases …

 

[Edcronos]

I could already solve
then do not understand why the increasing discussion
if I used split or not, I think it is not relevant
if the macro was pretty, or looks like Rambo killing ants, I think the important thing is to work and be effective

explanations about the language was the biggest impediment
further to explain an idea that is not well implemented
surely your help would be extremely valuable if not for these factors

 

[Marc L]

So next time just respect forum rules and well answer to questions …


​

 

[Edcronos]

What was the rule I not respected?
the only thing I did was leave the topic open after solved
but I found where marking as resolved

if I was not used split or racked my brain to follow your tips
I do not see how this can be a forum rule

and also do not think it has gotten to offend someone
the one who should be offended, it's me
why, by my understanding, you suggested, I have the lowest qi that a child of 10 years, and this for, I could not do what I want, your way
The problem may be between the chair and the monitor, or may be linguistic differentiation

macros that you had not met me
you certainly have more experience in this area than I, then your view of the subject is much brighter than me, if I do not understand your recommendations, can really be because I am "Noob"

Qual foi a regra do que eu não respeitei?
a única coisa que eu não fiz, foi deixar o tópico aberto depois de resolvido
mas não achei onde marcar como resolvido

se foi por que não usei split, ou quebrei a cabeça para segui suas dicas
não vejo como isso pode ser uma regra do fórum

e também não acho que tenha chegado a ofender alguém
o único que deveria se sentir ofendido, sou eu
por que, pelo meu entender, você insinuou, que eu tenho o qi menor que uma criança de 10 anos, e isso por, que não consegui fazer, o que eu quero, do seu jeito.
o problema pode estar entre a cadeira e o monitor, ou pode ser a diferenciação linguística

as macros que você apresentou ,não me atenderam
você certamente tem mais experiencia nessa área do que eu, então a sua visão do assunto é muito mais claro, do que para mim, se eu não entendo as suas recomendações, realmente pode ser por que sou "Noob"

advantage and solves this topic, I can not understand what the guy wantsand
http://forum.chandoo.org/threads/in...-fields-from-another-sheet.25852/#post-154710

can expel me forum time that you want.

 

[Marc L]

• Initial post must be as clear as possible …
• In case of difficulty to explain, a workbook attachment with source data
and result is expected, as you must see in advice before to log in !
• If anybody ask you anything, answering well to him is also expected.

- I never wrote that only using Split function is the Solution.

- I never wrote about your QI, I just wrote with a paper and a pen
a way can be founded for your need with an easy logic like kids did
in a similar problem but maybe a bit more complex …
Applying this logic, it allows to use in the end Split function
which very simplifies the creation of the result array.
Of course if you don't like easy way …
As you don't post clearly source strings and expected results
neither attach a workbook, I can't check if it's the right procedure
'cause each time I posted something you changed samples …
So I just could explain their easy way !

- After your post in your native language, I was thinking you have a great
sense of humor, sorry for this misunderstanding …

The same guy wasted our time in a past thread, unclear,
changing his need at each post, …
This thread is a duplicate of his former, I won't waste my time anymore !

_____________________________________________________________
We are all very ignorant, what happens is that not all ignore the same things … (Albert Einstein)
​

 

[Edcronos]

yes, I have changed, even if the same idea,
I do not know if I was understanding what I read,
as well as I did not know if you had understood me, and still do not know

at the same time you should know that transmits an idea is not always easy
imagine when this same idea is not so clear for yourself

I rarely mess with formulas
for it may be something simple, but for me it is not

and yes, I am lost with the idea
redid the way of writing the formula often
http://forum.clubedohardware.com.br/topic/1134086-logica-intuitiva-para-filtro/

did not think it would become something so complicated,

is an infinite loop between ease of now and the future utility

I will gradually clarifying the idea and setting an easy structure, and efficient to filter data,

the formula of the structure was simple "I think"


! = Sector Example: column 1 to column 30
$ = Sheet
@ Indicates operators, and, or,>, <, <>, like,

# Indicates the column that will be tested,
without it the macro tests all speakers

% Indicates the type of test, day, month, year, week, unity, ten, Right, Left

!sector3,$sheet3,@and(@>(#1,%unit 6),@or(#2,%week,3,4))

returns all rows in the range, the column 1 the unit is more than 6
7,8,9,17,18,19,27,28,29, ... 1007,1008,1009
@And
column 2 the day of the week is 3 or 4

I'm thinking how to put other comparison in macro
I have things I want to add, and I can not think of a way to put logic in the formula and that I can make the macro filter

 

[Marc L]

As I can't visualise the utility,
as VBA text functions are very easy to experiment,
as you already have a code,
as several times we explained what is expected within a question here,
as …, I just remember Narayan's advice :
perform a web search for an Excel formula parser …
​

 

[Edcronos]

The utility is inherent in the necessity
excel cell is a kind of formula, the filters have another default, sql select other
Excel does not have something like select sql that takes the data, and can work with them independently

!B11:AE6000,$Sheet1, "formula" _ !A1, $Sheet2
take the !B11:AE6000,$Sheet1 (filter) and paste the results in _!A1, $Sheet2
Range-->>Array-->(filter)-->range

how many times someone has had to take data from a sheet filter and go elsewhere

I do not have the ability to do something as complex as the select sql, let alone create something with capacide of excel formulas,
but if I had given up, I would not even come here
maybe I can not do as I imagine, but even as it already gives great ease of filtering

Excel formula parser
I looked, some have left me more confused, others gave me any tips

 

[Marc L]

You can use SQL via ADODB ActiveX for example … Like MS-Query …

Maybe I'm wrong but your idea is a gas factory code less efficient (slowest)
'cause VBA is not a real compiled language but just interpreted.

So wait for some ninjas opinions 'cause I'm just a ronin here !

I just can try to answer to a VBA precise technical point …
​

 

[Edcronos]

vba with arrays are very efficient
of course it does not compare with other languages
at least 10,000 rows and 40 columns and a test on all columns return was instant
of course I did a simple test @and(%unit, 1,3,5)
filtering the row that has 3 data, terminated in 1 and 3 and 5

 

[Marc L]

I forgot one of most powerful & useful Excel functionality :
see and try advanced filter …

​

 

[Edcronos]

I know, but assembles the criteria is sometimes painful
usually I create a conditional formatting formula and with a focus in one column and the color filter of this column

 

[Marc L]

Less painful than your less efficient easy structure
needing to be first interpreted and translated after !

I'm over now from this thread, wait for others & some ninjas opinions …
​

 

[Edcronos]

you're wrong about that,
Conditional formatting is efficient filter is efficient, but combining the two is not
consider 10 sectors ranging from 700 rows and 10000 rows and 140 columns in total

filter rows with values and different dates, between activation of formatting acioonar the filter, pick up lines, disable filter change the formatting and turn .... it's too slow to run, especially when the data are related
making an array filtering does not take time 1/30

further prepare the formulation with ranges dynamical

I think the ninjas will act like ninjas,
will remain hidden in critical situations

usually they appear only when they know that their techniques are sufficient
joke ok

 

[Marc L]

I saw too many workbooks becoming very slow at each calculation
and finally exploded 'cause of CF ! To avoid with big data …

And I wasn't talking about arrays but on your "interpreted language" !

If others disagree, they will answer here …
​

 

[Edcronos]

apparently, they're all over the counter

I'm too,
staff spoke not to use goto, I use
the staff had spoken to not use gosub, I use
Spaghetti as a surprise spice is very good
the staff had spoken to not use public variables, I use
while work for me, if the macro is fast, and do not give problems