Dear André Luiz D´Avila,
Thanks for giving your valuable time for giving reply on my post. But what
you replied is very simple and known to be but not useful as because: -
1. The examplese (i.e. columns) in both purchase & sale sheet will be more
than 50 per sheets. and that too different from e
You can also try this non array formula..
=INDEX(C4:I4,MATCH(TRUE,INDEX((C4:I4<>0),0),0))
Cheers!!
On Fri, Mar 13, 2015 at 8:49 PM, André D'Avila
wrote:
> Thank you very much
>
> André Luiz D´Avila
>
> 2015-03-13 12:13 GMT-03:00 Vaibhav Joshi :
>
> Check formula in col k..
>>
>> Cheers!!
>
Hi André D'Avila,
Please try this formula "=INDEX(C2:I2,MATCH(1,INDEX(ISNUMBER(C2:I2)+0,0),0))"
in cell J2 and also find the attached file.
Regards,
MV
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
wrote:
> Dear experts,
>
> I can't figure out how to create a fórmula to this problem.
>
> In t
Thank you very much
André Luiz D´Avila
2015-03-13 12:13 GMT-03:00 Vaibhav Joshi :
> Check formula in col k..
>
> Cheers!!
>
> On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
> wrote:
>
>> Dear experts,
>>
>> I can't figure out how to create a fórmula to this problem.
>>
>> In the first hand
Check formula in col k..
Cheers!!
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
wrote:
> Dear experts,
>
> I can't figure out how to create a fórmula to this problem.
>
> In the first hand seems simples, but i couldn't sove without creating a
> excel macro.
>
> Is it possible to create a fórmu
PFA with #N/A handler...
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> A
Refer below link
https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5
On 13-Mar-2015 7:12 pm, "B Sharma" wrote:
> Dear All Excel Experts,
> From a very long time, I am trying to create a pivot table using two or
>
Dear experts,
I can't figure out how to create a fórmula to this problem.
In the first hand seems simples, but i couldn't sove without creating a
excel macro.
Is it possible to create a fórmula to the challenge bellow?
I attached the file too.
Thx.
André Luiz D´Avila
[image: Imagem inline 1]
Hello,
You have a excel sheet with table "purchase" and other one with "Sales".
In order to combine both of them, the fast way is to create a 3 sheet.
In that third one, create another table. Paste de "purchase table" and
below paste the Sales table.
After that create a Pivot using this new tabl
Dear All Excel Experts,
>From a very long time, I am trying to create a pivot table using two or
more tables, but not getting appropriate results.
Please help me , if anybody has ever done so.
For e.g. in one table there are purchase details and in another column
there are sale details..
I wan
CHeers!!
On Fri, Mar 13, 2015 at 3:10 PM, Ashish Bhalara
wrote:
> Thank you Mr.Vaibhav:)
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
> On Fri, Mar 13, 2015 at 1:28 PM, Vaibhav Joshi w
Dear experts,
I need help in coding of automatic email from data base. Kindly see
attached file in which 'Data' sheet contain database and 'Mail' sheet
contain data to mail.
As per codding I have to manually filter pivot table and send mail one by
one.
I require loop in my coding to automatic filt
Thank you Mr.Vaibhav:)
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Fri, Mar 13, 2015 at 1:28 PM, Vaibhav Joshi wrote:
> Hi
>
> Check cell D20 for formula..
>
> On Fri, Mar 13, 2015 at 12:43 PM, V
check this..
Cheers!!
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> Ar
Hi
Check cell D20 for formula..
On Fri, Mar 13, 2015 at 12:43 PM, Vaibhav Joshi wrote:
> Hi
>
> Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0))
>
> Cheers!!
>
> On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara > wrote:
>
>> Dear experts,
>>
>> I need function to sum only closing value
Dear Experts,
Can you please help me to put vlookup or any other formula for the the
second row. Attached is the my file and request you to help on the same.
Regards,
Vijayendra
94491 67631
--
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
please check the attachment
On Fri, Mar 13, 2015 at 11:58 AM, Will Sob wrote:
>
> Hi,
> Please I need help with the attached file. I want a that calculates how
> many times 10, 13, 17 has appeared within the range D5:I32
>
>
>
>
>
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan
Hi
Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0))
Cheers!!
On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I need function to sum only closing value of particular date, pls see
> attached file for example.
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Plea
18 matches
Mail list logo