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
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
please check the attachment
On Fri, Mar 13, 2015 at 11:58 AM, Will Sob will00...@gmail.com 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
Dear gaurav,
required some more modification. if you can check AED in question sheet is
15 then in Master sheet, search for 15 SAR. Below than that there is a AED
15, KWD 15, SAR 1.5 OMR 1.5 BHD 15 QAR 1.25,
Base currency will be AED in question sheet and in master sheet base
currency will be
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
Hello
Use in O6 cell formula = COUNTIF($D$5:$I$32;O5) and copy to right.
Regards
W dniu piątek, 13 marca 2015 07:28:20 UTC+1 użytkownik Will Sob napisał:
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
Hi
Use this array formula =SUM(IF(A3:A17A2:A16,D2:D16,0))
Cheers!!
On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
I need function to sum only closing value of particular date, pls see
attached file for example.
Regards.
Ashish Bhalara
Hi
Check cell D20 for formula..
On Fri, Mar 13, 2015 at 12:43 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Use this array formula =SUM(IF(A3:A17A2:A16,D2:D16,0))
Cheers!!
On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
I need function to
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
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 v...@vabs.in wrote:
Hi
Check cell D20 for formula..
On Fri, Mar 13, 2015 at
CHeers!!
On Fri, Mar 13, 2015 at 3:10 PM, Ashish Bhalara ashishbhalar...@gmail.com
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,
check this..
Cheers!!
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao vijayendrar...@gmail.com
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
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 table. I
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]
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 sharma@gmail.com wrote:
Dear All Excel Experts,
From a very long time, I am trying to create a pivot
PFA with #N/A handler...
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao vijayendrar...@gmail.com
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
Thank you very much
André Luiz D´Avila
2015-03-13 12:13 GMT-03:00 Vaibhav Joshi v...@vabs.in:
Check formula in col k..
Cheers!!
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila andredavila...@gmail.com
wrote:
Dear experts,
I can't figure out how to create a fórmula to this problem.
Check formula in col k..
Cheers!!
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila andredavila...@gmail.com
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
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 andredavila...@gmail.com
wrote:
Dear experts,
I can't figure out how to create a fórmula to
You can also try this non array formula..
=INDEX(C4:I4,MATCH(TRUE,INDEX((C4:I40),0),0))
Cheers!!
On Fri, Mar 13, 2015 at 8:49 PM, André D'Avila andredavila...@gmail.com
wrote:
Thank you very much
André Luiz D´Avila
2015-03-13 12:13 GMT-03:00 Vaibhav Joshi v...@vabs.in:
Check formula
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
21 matches
Mail list logo