w to use it..
please help.
[cid:image001.png@01D28185.9A2A90C0]
Best Regards,
Amit Desai
Contact: - 09867232534
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addre
Please add me on group. My number is 9867232534.
Best Regards,
Amit Desai
Contact: - 09867232534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajeev Ranjan
Sent: 08 August 2016 21:43
To: MS EXCEL AND VBA MACROS
Cc: excelvba...@googlegroups.com
Subject
Can someone please help? Please let me know the procedure to install & activate
Power Pivot in Excel 2013?
Best Regards,
Amit Desai
Contact: 9867232534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: Wednesday, October 14, 20
Dear Friends,
Can you please let me know the procedure to install & activate Power Pivot in
Excel 2013?
Best Regards,
Amit Desai
Contact: 9867232534
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This mes
st to attach pdf file in all the mails in draft folder?
Best Regards,
Amit Desai
Contact: 9867232534
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you ar
ise data graphically something like below..
Height
Width
Largest:
2.45
3.9
Second:
1.90
3.02
Third:
1.55
2.47
[Description: cid:image001.png@01D096F9.D910E2D0]
Best Regards,
Amit Desai
Contact - 09867232534
Disclaimer: This message and its attachments contain confidential information
and
Dear Prabhu,
Thanks a lot.. this will fit in my data sets.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prabhu Pinky
Sent: Friday, March 27, 2015 9:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find Second Highest value from data
11:29 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find Second Highest value from data
Hi Amit,
Find below formula for result second highest value.
=max(renge,2)
thanks
satendra
On Fri, Mar 27, 2015 at 11:08 AM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>>
Dear Mandeep,
Oh wow…Thanks a lot.. It worked as needed.
Best Regards,
Amit
From: Mandeep Baluja [mailto:rockerna...@gmail.com]
Sent: Friday, March 27, 2015 11:24 AM
To: excel-macros@googlegroups.com
Cc: Amit Desai (MERU)
Subject: Re: Find Second Highest value from data
you can use large
Dear Friends,
Please let me know if I want to find second highest value from a data range how
shall I do that?
[cid:image001.png@01D0687E.4102B990]
Please let me know what formula can be used to get 66,000.
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain
Dear Friends,
Please help me getting the data in a cell move to relevant columns. I have
Attached sample file for the same.
Best regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is inten
Dear Ashish,
Thanks a lot for your efforts. However, I need the output in the same way as in
my file...only difference is, the current file is not able to process text in
cell with special characters.
Regards,
Amit Desai – MIS Manager
M: +91 9867232534
[Description:
cid:image005.jpg
Dear Friends,
I have few files in a folder & from each file there is a specific sheet. I need
data from each of that specific sheet & compile them at one place.
Is there any solution?
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential informat
Dear Ashish,
Thanks a lot for your help...however request you to please explain me how you
did this?
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ashish Kumar
Sent: Wednesday, September 24, 2014 8:11 PM
To: excel-macros
ates.com/how-to-make-a-better-excel-sales-pipeline-or-sales-funnel-chart/
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ashish Kumar
Sent: Wednesday, September 24, 2014 7:08 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-M
0
C
1200
1550
1400
Please guide me how to draw a chart.
Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you are not the addres
Please see if this helps..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Nur Hossain
Sent: Monday, July 28, 2014 10:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Required data separation by formula
Dear all, I need data separation by
Thanks for the help friend.
Regards,
Amit Desai – MIS Manager
M: +91 9867232534
[Description: C:\Users\Krushna.garkhede\Desktop\Sig
1p.jpg]<http://www.merucabs.com/mobile/>
[Description: C:\Users\Krushna.garkhede\Desktop\Sig
2p.jpg][Description: C:\Users\Krushna.garkhede\Desktop\Sig
Dear Friends,
Although this is not a Question related to Excel, I need help if someone knows
the answer.
I have created a survey form using Google Doc. Once done I have closed the
Google Doc application page. Now although the survey is working, but I am not
getting the file/spreadsheet where m
Hi
Does this also work on column containing Non-Numeric data?
Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Vaibhav Joshi
Sent: 05-Mon-2014 19:43
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ PivotTable_Calculated Field
H
Dear Abhishek,
This worked perfectly fine. Thanks a lot.
I just check how Left & Address formula works! Could you please explain me how
does the formula works?
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Abhishek Jain
Sent
here any method to get this done in Excel?
Regards,
Amit Desai - MIS Manager
M: +91 9867232534
[Description: C:\Users\Krushna.garkhede\Desktop\Sig
1p.jpg]<http://www.merucabs.com/mobile/>
[Description: C:\Users\Krushna.garkhede\Desktop\Sig
2p.jpg][Description: C:\Users\Krushna.garkhede\D
p 10 Requestors.
once i put date in master file the second sheet will be update with latest top
10 Requestors automatically with each company and chart will update accordingly
.
Regards,
Prafull Jadhav
9920553518
On Wed, Dec 18, 2013 at 3:40 PM, Amit Desai (MERU)
mailto:amit.de...@merucabs
In Macro use conditional Formatting..use Top 10 option..
Regards,
Amit Desai - MIS Manager
M: +91 9867232534
[cid:image001.jpg@01CEFC07.8BEB7E40]<http://www.merucabs.com/mobile/>
[cid:image002.jpg@01CEFC07.8BEB7E40][cid:image003.jpg@01CEFC07.8BEB7E40]
From: excel-macros@googlegrou
Dear Renuka,
Please try “ASAP utilities” its free ADDIN for 90 days..
Regards,
Amit Desai – MIS Manager
M: +91 9867232534
[cid:image001.jpg@01CEF0D4.ECA4F650]<http://www.merucabs.com/mobile/>
[cid:image002.jpg@01CEF0D4.ECA4F650][cid:image003.jpg@01CEF0D4.ECA4F650]
From: excel-
ot;), in
D2 it should be =if(sheet1!D2>0,"YES","NO").
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ravinder
Sent: 28 November 2013 10:55
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Co
Can someone please help?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 27 November 2013 16:14
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column Reference to change when we move to next row
Hi Group,
I have a
Hi Group,
I have a formula in which I have reference of column "A". when I go down I want
to change the formula to refer column "B". is there any way to do this? As of
now I need to change the same manully.
Regards,
Amit Desai - MIS Manager
M: +91 986723253
xlYes
Range("D4").Select
Selection.Delete Shift:=xlUp
Range("C4").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Range("$E$3:$E$2028").RemoveDuplicates Columns:=1, Header:= _
xlYes
Range("E4").Select
Dear Friends,
Please help.
I am trying to arrive at a pivoted solution from a data. What I need is a count
of cabs with Defects from the list QC report.
Please see the details report & "Pivoted data sheet". Kindly suggest how shall
I formulate the same. Do I need to add any helper column?
Reg
Thanks, will check the same & do the needful.
Regards,
Amit Desai - MIS Manager
M: +91 9867232534
[cid:image001.jpg@01CED3DA.DC1D6BD0]<http://www.merucabs.com/mobile/>
[cid:image002.jpg@01CED3DA.DC1D6BD0][cid:image003.jpg@01CED3DA.DC1D6BD0]
From: excel-macros@googlegroups.com [ma
Dear Friends,
I would like to install power pivot addin in excel. I have excel 2010 installed
on my home PC. I have downloaded required .net file & 1 power pivot related
file.
Pls help with further steps to follow so that I can install adding.
Best Regards,
Amit
Disclaimer: This message and its
plain on mail that how is this formula working.
Sorry, But evaluate formula can explain. try it.
Regards,
Waseem Saifi
On Fri, Oct 11, 2013 at 8:51 PM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
Thanks a lot..
Can you please also explain me how this works?s
From
Thanks a lot..
Can you please also explain me how this works?s
Regards,
Amit Desai - MIS Manager
M: +91 9867232534
[cid:image001.jpg@01CEC6C3.A9D00DF0]<http://www.merucabs.com/mobile/>
[cid:image002.jpg@01CEC6C3.A9D00DF0][cid:image003.jpg@01CEC6C3.A9D00DF0]
From: excel-macros@googlegrou
Dear Friends,
Please help me with the conditional count formula. Conditions needs to be
applied on both Columns & Raws...Please see attached sample file.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may al
Do we also have any specific macro for hiding few selected columns?
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: 28 September 2013 13:04
To: excel-macros
Subject: Re: $$Excel-Macros$$ how to unhide multiple sheets
Very short & Cute formula... Thanks a lot for sharing this with group.
Can you please explain how it is calculating.
I have tried to check each piece of formula but could not got a clue only
"=COUNTIF(A2:A595,A2:A595)" is giving me "0" as result! -:)
Also if you can share other uses of "SUM
?
5) Any Study material if someone has?
6) Any Question pattern if someone has...
Best Regards,
Amit Desai
Mobile:- +91 98672 32534
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privil
9. You can have up to 255 data series in one chart
10. You can highlight 32,767 cells per worksheet
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This
Dear De Premor,
Thanks a lot..
Best Regards,
Amit Desai
Mobile:- +91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of De Premor
Sent: 28 July 2013 16:14
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Linking Pages from PPT
Dear Friends,
I am trying to prepare a Presentation & wants to link one sheet of an excel
file. Once done I want a reverse link to that slide.
I am able to link the files but not to particular sheet & slide...
Please Assist.
Best Regards,
Am
Thanks a lot...
Best Regards,
Amit Desai
Mobile:- +91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of P.VIJAYKUMAR
Sent: 20 July 2013 17:12
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Deleting Blank Rows
Respected Amit
Dear Vijay,
Thanks a lot for your help.
How shall I add the addin is the file extension correct?
Best Regards,
Amit Desai
Mobile:- +91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of P.VIJAYKUMAR
Sent: 20 July 2013 13:20
To: excel-macros
2013 11:15
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob
getting error as excel cannot complete this task with available resources.
choose less data or close other applications
On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU)
mailto:amit.de...@me
to solve this prob
Thank you, i will follow your step, but is any other solution for this? plz
tell me, y this prob occurs, so i can take precautions in any other files.
On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
In this case, you should d
9:14 AM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
In this case, you should do as follows;
In case if you wants to delete all the contents of raw, select all the cells of
that raw from first to last till the column heads are there, right click with
mouse, select on Dele
In this case, you should do as follows;
In case if you wants to delete all the contents of raw, select all the cells of
that raw from first to last till the column heads are there, right click with
mouse, select on Delete, on asking where to shift the below cells select "shift
cells up". You wi
from.Hope that the above will help you upto
some extent.
Regards,
VIJAYKUMAR
On Tue, Jun 11, 2013 at 10:50 PM, ravinder negi
mailto:ravi_colw...@yahoo.com>> wrote:
here u go dear
http://www.w3schools.com/SQl/default.asp
--- On Tue, 6/11/13, Amit Desai (MERU)
mailto:amit.de...@merucabs.co
Tue, Jun 11, 2013 at 3:55 PM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
Hello Friends,
Does anyone have training material on SQL? Could you please share.
In case if anyone knows about any good site for the same please share link.
Best Regards,
Amit
Hello Friends,
Does anyone have training material on SQL? Could you please share.
In case if anyone knows about any good site for the same please share link.
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
If rng.Value < 0.8 Then
rng = .80
End If
Next
End Sub
.
Enjoy
Team XLS
On Thu, Jun 6, 2013 at 11:18 AM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
Dear Friends,
Do we have any functionality to do conditional search
Dear Friends,
Do we have any functionality to do conditional search & replace...
For example what if I wants to search for values less than 80% & replace them
by 80% in selected range! Do we have any features...
Best Regards,
Amit Desai
Disclaim
I have multiple Pivots in which I need to change the data table range all
together..
Is there any shorter way to do that all at a time?
[cid:image001.jpg@01CE5DE9.FD77C0D0]
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain
formula,if it helps
=ABS(IF(IF(AND(H2="yes",G3="no"),AND(H2="yes",G4="yes"))=TRUE,D2-D4,0)-IF(AND(H2="yes",G3="yes"),D2-D3,0))
On Sat, May 25, 2013 at 3:24 PM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
No its not that easy.
From: Vabz [mailto:v...@vabs.in]
Sent: 25 May 2013 15:51
To: excel-macros@googlegroups.com
Cc: Amit Desai (MERU)
Subject: Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula
PFA
Just Drag & Drop first formula!!
Cheers!!
On Saturday, May 25, 2013 3:24:08 PM UTC+
Please share the main sheet.. I will convert it & send it...
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Chaya
Sent: 14 May 2013 16:24
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ P
Do Copy & then do Alt E S V E.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Chaya
Sent: 14 May 2013 16:12
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Paste Vertically
Dear experts,
I
Dear Anil,
This one is perfectly working. Can you please help me how shall I put this in
my main file?
Best Regards,
Amit Desai
+91 98672 32534
From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
Sent: 10 May 2013 15:23
To: excel-macros@googlegroups.com; Amit Desai (MERU)
Subject: Re
I am okay to have a macro too.. but in that case it should provide me solution
to select row number & column heads in that row numbers.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of David Grugeon
Sent: 10
e
sample file.
Best Regards,
Amit Desai
+91 98672 32534
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you are not
Is there any alternative other than array formala?
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of priti verma
Sent: 06 May 2013 14:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Help
In Simple I suggest to do borders in a blank cell & then copy the format. This
way you will get the only border (you do not have anything in cell so only
border will get copied.).
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups
Dear Paul,
Thanks. But since the file is huge & having many columns I am not able to move
entire sheet in transposed form...infact this sheet is fetching data from other
sheets.
I am trying to search something on line.. let me see if I can get.
Best Regards,
Amit Desai
From: excel-ma
You are right.
Can you please suggest some macro for that?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: 26 April 2013 17:17
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Filter based on
Can someone please answer?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 22 April 2013 18:15
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Filter based on coulmns
Dear Friends,
In general
Dear Friends,
In general we filter data based on the contents in rows. I would like to know
if we have any options to filter data columns.
Could you please help.
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential
p; so on...
Best Regards,
Amit Desai
+91 98672 32534
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you are not the a
.
3) Now short them with column B first & then C (High to Low) -you will get
the maximum numbers on the first row of each series..
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Lalit Mohan Pandey
Sent: 11 A
Dear Friends,
I wants to develop a excel training ppt for company.
Could you please suggest, what topics should be covered in Basic Excel Training
& Advanced Excel Training.
Best Regards,
Amit Desai
Disclaimer: This message and its attachments con
Is it possible to have a macro that will first give list of all the sheet names
& then gives 2 option hide or unhide?
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prince
Sent: 03 February 2013 22:05
To: e
Dear All,
Do you have a macro, which will split a sheet based on a column. Example one of
the column is "city" & there are 4 cities listed in a file. So once we run the
macro, it should populate 4 work sheet with the name of city.
Best Regards,
Amit Desai
+
Okay thanks.
Best Regards,
Amit Desai
+91 98672 32534
From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
Sent: 01 February 2013 14:03
To: excel-macros@googlegroups.com; Amit Desai (MERU)
Subject: Re: $$Excel-Macros$$ Successfully passed the microsoft digital
certification course.
its free
Please provide more details of the certification;
1) From where did you gave exam;
2) What books/materials have you referred,
3) How much is the cost?
4) How much time does it take to complete the certification.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros
Will this take care of excluding before Shift Start time (9:00 AM) & after
ending shift hours (18:00)?
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of xlstime
Sent: 28 January 2013 12:55
To: excel-ma
Dear Friends,
Please help.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 25 January 2013 13:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Calculate Net TAT / time Gap
End Time
Shift Start Time
Shift End Time
Time Gap
Net TAT
Remark
1
25-01-2013 17:00
27-01-2013 11:00
09:00
18:00
42:00:00
3:00:00
Need 3 Hours as formula netoff Holiday per list
Best Regards,
Amit Desai
+91 98672 32534
Disclaimer: This message and
nged for this logic change!
Best Regards,
Amit Desai
+91 98672 32534
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you
Dear Friends,
I need your help
Refer attached file,
1) "Detail" sheet contains handover details of cabs in Nov/Dec. Column AI
shows working for Gross TAT & AJ shows working for Net working hours.
2) "Holiday list", needs to be updated as applicable for NAL. This need
not cover Sunda
Yes, I want to exclude Sunday & time beyond 18:00 to 09:00.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of rajan verma
Sent: 23 January 2013 14:37
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Ma
How shall I remove the non office hours...
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of rajan verma
Sent: 23 January 2013 14:02
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formaula to
,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you are not the addressee indicated in this
message (or
Dear All,
I have multiple sheets say per location in a file
I wants to do a pivot from multiple sheet however I need to get the pivot next
to each other...
Is there any shortcut or macro?
Best Regards,
Amit
Disclaimer: This message and its attachments contain
Dear Prince,
Please explain how to use this.. also do you have a solution for how to split a
sheet in different sheets based on a column.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prince
Sent: 23 December 2012 11:38
To: excel-mac
Dear Friends,
I would like to learn the concept of INDEX, MATCH, DIRECT,INDIRECT functions.
Please provide me some write-ups with examples.
Thanks in Advance.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and
Could you please explain the formula used?
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of >>Excel Beginner<<
Sent: 22 December 2012 18:45
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ lookup values with 2 conditions
H
Thanks this would be helpful..
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prince
Sent: 18 December 2012 11:14
To: excel-macros@googlegroups.com
Cc: Amit Desai (MERU); Amit Desai (MERU)
Subject: $$Excel-Macros$$ Re: How to develop
://www.ozgrid.com/VBA/excel-add-in-create.htm
http://www.rondebruin.nl/qat.htm
http://www.rondebruin.nl/contextmenu.htm
http://www.rondebruin.nl/qat2.htm
On Mon, Dec 17, 2012 at 6:27 PM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
Dear Friends,
Could you please help me understand
Dear Friends,
Could you please help me understand how to write or develop Addin in Excel
2007? Do we have a training material or some write ups for hint?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may a
Sure... thanks a lot.
Best Regards,
Amit
From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com]
Sent: 08 November 2012 16:47
To: Amit Desai (MERU)
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
I am still committed on my words.
But I need some more
Dear Noorain,
Could you please share the Vlookup book if it is prepared at your end?
Best Regards,
Amit
From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
Sent: 02 November 2012 16:46
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Vlookup Book
Dear Noorain
com>
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel
____
From:
October 2012 17:07
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
Currently i am out of station. Will share it shortly
Sent from BlackBerry(r) on Airtel
____
From: "Amit Desai
. Will share it shortly
Sent from BlackBerry(r) on Airtel
From: "Amit Desai (MERU)"
mailto:amit.de...@merucabs.com>>
Sender: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Date: Mon, 29 Oct 2012 14:25:27 +0530
T
Dear Noorain,
Few days back you were referring a book to be written on vlookup.
If you have completed, could you please share the same with the Group?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also
try,
=SUMPRODUCT(($A$3:$A$8=$E5)*($B$3:$B$8))
see attached sheet for more clarity
On Tue, Oct 23, 2012 at 1:06 PM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
Please find attached sample data file... I need Vlookup solution & not the
Pivoting pls...
Best Regards,
Amit
SUMPRODUCT will better than Vlookup.
Pls share sample sheet for better clarity
On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
Dear All,
I have an excel file for which, there is Incentive worked out based on 2-3
parameters for the same Technician.
I want
Please find attached sample data file... I need Vlookup solution & not the
Pivoting pls...
Best Regards,
Amit
From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
Sent: 23 October 2012 12:59
To: excel-macros@googlegroups.com; Amit Desai (MERU)
Subject: Re: $$Excel-Macros$$ Vlookup with t
Dear All,
I have an excel file for which, there is Incentive worked out based on 2-3
parameters for the same Technician.
I want to do a vlookup with the total amount (of 2-3 amounts) against that
person. Please help me with a formula.
Best Regards,
Amit
Discl
Dear Noorain/Rajan,
This too was really nice
Can you or someone create a Meditation Chakra? That could be use for Meditation
on Full screen!
I am this will not be difficult for you masters...Also please share how did you
prepared this Owe some creative graphics..
Best Regards,
Amit
From:
: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hiii
Excellent Creativity Amit.
On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
To all my dear friends,
Nice Excel filewith ABCD on Friendship...
Please see the attachme
1 - 100 of 229 matches
Mail list logo
