ok, I'm glad to have helped, is attached, other filter options with SQL
syntax.
Regards.
Abx.
Basole.
Em segunda-feira, 7 de dezembro de 2015 08:40:33 UTC-2, luciano de souza
escreveu:
>
> Hello all,
>
> This is my first message to the group and I am glad to participate in
> a so rich sp
It's exactly what I want! Thank you!
Regarding the complexity of formulas I have been using there, this
code is much simpler!
Another advantage is that update only occurs by demand. So I don't
have performance problems due to the constant updates.
Very good!
2015-12-07 11:45 GMT-02:00, Basole :
Luciano is attached a SQL synthesis of example that gets the data from
another tab, but can be adjusted to retrieve data from another workbook
regards.
Abraço.
Basole.
Em segunda-feira, 7 de dezembro de 2015 08:40:33 UTC-2, luciano de souza
escreveu:
>
> Hello all,
>
> This is my first m
Dear Mandeep thank for reply,can you give me this sheet after adjust this
code in one module
On Mon, Dec 7, 2015 at 5:38 PM, Mandeep Baluja
wrote:
> Hi Amar,
>
> There are many ways to do it, it depends on you what you're looking for
> ,This can be achieved with the help of Helper Column, with F
I am not sure if I understood your message as a whole, but the reason
I want it is to make reports.
Nowadays, I build reports selecting data from an input sheet by means
of formulas. However, formulas rapidly become very complex and the
maintainability is very bad. Moreover, the performance does d
Sorry , I am bit confused are you willing to run a query of SQL from
Excel, Thant's needs a connection, Or you're trying to work in Excel as
same as you do in SQL by Getting Data as per your requirement from Sheet1
to Output sheet with the help of Macros/VBA Codes.
Regards,
Mandeep baluja
Hi Amar,
There are many ways to do it, it depends on you what you're looking for
,This can be achieved with the help of Helper Column, with Filter,advance
filter require a range to refer as far as i know, apply this formula in
helper column and put this criteria true for positive false for nega
Hi Luciano,
You want to filter sheet1 and return those results to another sheet? Not
sure if SQL can be used for that in Excel, but I use Power query to extract
specific data from a sheet that contains all data by using power query. I
can already select the columns I wish to use and also filter the
Dear Mandeep sir
I required output is same as you send exact i want. I say you there are
need k sheet for criteria(more & less than 0)? if we give this criteria in
code then it is ok or not?
Regards
amar
On Mon, Dec 7, 2015 at 3:45 PM, Mandeep Baluja
wrote:
> Find the attachment and let me know
Hello all,
This is my first message to the group and I am glad to participate in
a so rich space.
My first question is about the use of a sheet as a database. Suppose I
have a sheet with these columns:
Colunm 1: ID
Colunm 2: Project
Colunm 3: Activity
Colunm 4: Task
Colunm 5: Opened
Colunm 6: Re
>
> Find the attachment and let me know !!
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Exactly ,continuous positive growth means all arrows should move upwards
after click Positive Button & same for negative.
On Mon, Dec 7, 2015 at 2:24 PM, Mandeep Baluja
wrote:
> How to judge the negative trend, I can't see any value which is negative
>> here, What pattern needs to follow,
>> con
>
> How to judge the negative trend, I can't see any value which is negative
> here, What pattern needs to follow,
> continuous positive growth means all arrows should move upwards? Please
> put comments on your data for some random entries so that we can understand
> your requirement.
Rega
13 matches
Mail list logo
