heet, the given excel
sheet displays all the hidden & unhidden columns
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
peat steps 2) and 3)
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
--
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 Faceb
performed this using a formula. But it is of nature of circular
reference.
Can I have improvised version of the excel formula to take care of this ?
Let me know if my query is clear for understanding.
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valua
Hi
Please note that I have 3 worksheets in a workbook with the same number of
columns and would like to create dynamic graph in each worksheet at the
same time.
Column X along X-axis and
Column Y and MeanY along Y-axis
The Data excel is enclosed.
Thanks & regards,
*Sandeep Kumar Baranwal*
under Axis option category. You will get a break chart in
excel.
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
On Sat, Jun 10, 2017 at 9:46 AM, amar takale <amartak...@gmail.com> wrote:
: Simplex LP
Click : Solve
Hope you get the answer.
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
On Wed, Jun 7, 2017 at 7:44 AM, GENIUS <izharra...@gmail.com> wrote:
> OH
Variable Non-Negative
Select a Solving Method : Simplex LP
Click : Solve
Hope you get the answer.
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
On Tue, Jun 6, 2017 at 11:15 AM, Sandeep K
.
.
.
.
$I$13=$A$13
$I$14=$A$14
$I$15=$A$15
Check (Tick Mark) - Make Unconstrained Variable Non-Negative
Select a Solving Method : Simplex LP
Click : Solve
Hope you get the answer.
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitt
, as required.
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
On Sat, May 13, 2017 at 11:34 AM, Izhar <izharra...@gmail.com> wrote:
> look at the attachment when we click on GOAL SE
take time. The excel seems to be working slow.
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
On Sun, Jun 4, 2017 at 3:59 PM, <paramdeepwa...@gmail.com> wrote:
> why excel is
Hi
Thanks for the concern.
Please find the details in spreadsheet attached.
Please note that the match operation need to be performed basis
the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should
be populated using "Sheet2".
Thanks
Hi
Kindly note that the match operation is to be performed basis the variable
"dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated
using "Sheet2".
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation an
FirstNameLastName Variable_sheet2
abc_xyz abc xyz rpm_xyz
rpm_xyz rpm xyz abc_xyz
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-858880
is to be defined for selection $D$1:$E$10
Another name range is to be defined for selection $G$1:$H$10
And so on
Thanks & regards,
*Sandeep Kumar Baranwal*
Lead Solution Advisor
Model validation and Valuation, Deloitte US India
Gurgaon
India
Mob:-+91-8588802543
--
Are you =EXP(
Hi
Could anyone help me with the VBA code to convert multi-pages PDF file to
multiple sheets Excel spreadsheet ?
Thanks regards,
*Sandeep Kumar Baranwal*
Assistant Manager
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Kumar Baranwal*
Assistant Manager
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
--
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
Hi Basole
I am glad you understood my requirement.
Kindly share the models that use excel to ms access with tables and indexes
at your convenience.
Looking forward to your generous help once again.
Thanks regards,
*Sandeep Kumar Baranwal*
Assistant Manager
Credit Risk Methodology Wholesale
?
Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
Baranwal escreveu:
Hi
Kindly note that sql.request is functional in MS Excel 2007 but not in MS
Excel 2010. Could you please let me know any VBA code that would be a
substitute for sql.request.
If yes, Please let me know
on the same
requirement for importing data from MS Access to MS Excel using querytables
?
The version that you helped me with, uses recordset. I want to use
querytables instead.
Thanks regards,
*Sandeep Kumar Baranwal*
Assistant Manager
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
that would
enhance my ability to optimize my skills at VBA excel ?
It would be really great of you if you allow me to grow with VBA excel
under your guidance.
Thanks regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
Access. The problem now faced ,
is related to cx.connectar.
Could you resolve this ?
Thanks regards,
*Sandeep Kumar Baranwal*
Assistant Manager
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
On Fri, Jul 19, 2013 at 8:17 PM, Basole ricardo...@gmail.com wrote
sheet.
Thanks regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
On Thu, Jul 18, 2013 at 9:08 AM, Sandeep Kumar Baranwal
sandeepkumarbaran...@gmail.com wrote:
Hi
I am not able to access the ImportAccess.zip
the dropdown box in MS Excel, I have data (23,34,45) imported from MS
access to MS Excel. Similarly if I choose 2 from dropdown box , I have
(67,34) imported from MS Access to MS Excel.
Thanks regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology Wholesale Basel,Genpact
in version
2007
Thanks regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
--
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
Hi
I am not able to access the ImportAccess.zip folder that you have send
across. Please look into the issue.
Thanks regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
On Wed, Jul 17, 2013 at 8:59 PM, Basole
) year (along x-axis) versus salary (along y-axis (secondary axis))
and the chart must incorporate every new set of values that are appended
below the given list in sheet 1 of the attached excel sheet.
*Sandeep Kumar Baranwal*
Credit Risk Methodology Wholesale Basel
Gurgaon
Mob:-08588802543
On Sat
every new set of values that are appended
below the given list in sheet 1 of the attached excel sheet.
*Sandeep Kumar Baranwal*
Credit Risk Methodology Wholesale Basel
Gurgaon
Mob:-08588802543
On Fri, Jul 6, 2012 at 6:23 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Use
Respected Rajan Sir
I am not able to locate the related VBA code in the attached excel sheet.
Will you please provide the VBA code.
*Sandeep Kumar Baranwal*
Credit Risk Methodology Wholesale Basel
Gurgaon
Mob:-08588802543
On Fri, Jul 6, 2012 at 9:02 PM, Rajan_Verma rajanverma1
Hi Sir
Thanks for introducing me the use of dynamic range assignment.
thanks a lot for you help.
can there be VBA code as an alternative to using dynamic range for drawing
the chart? If yes, will you please introduce me to that as well?
*Sandeep Kumar Baranwal*
Credit Risk Methodology
.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
*Sandeep Kumar Baranwal*
Credit Risk Methodology Wholesale Basel
Gurgaon
Mob:-08588802543
--
FORUM RULES (986
30 matches
Mail list logo