Hi Experts
I have excel data in column *B*. In some cells there is data *#N/A*
--> I want to Replace *#N/A* , with data in *next cell.*
--> If *#N/A* is in more than 1 cells (continuous) , then Replace them
with *next
valid data*.
--> If there is no Valid data in any next cell, then Replace
Hi Experts
I have excel data in column *B*. In some cells there is data *#N/A*
--> I want to Replace *#N/A* , with data in *next cell.*
--> If *#N/A* is in more than 1 cells (continuous) , then Replace them
with *next
valid data*.
--> If there is no Valid data in any next cell, then Replace
Hi All
I am using Excel 2010.
I have Raw Data shown in range C1:M9.
I need a vba macro to get desired output as shown in Range B14:Q20.
Pls help me here.
Take care
Amit
--
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
Hi All
I am using Excel 2010.
I have Raw Data shown in range C1:M9.
I need a vba macro to get desired output as shown in Range B14:Q20.
Pls help me here.
Take care
Amit
--
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
, Nov 10, 2014 at 4:15 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi All
I am using Excel 2010.
I have Raw Data shown in range C1:M9.
I need a vba macro to get desired output as shown in Range B14:Q20.
Pls help me here.
Take care
Amit
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Hi Vaibhav
One more thing, i use this formula to fetch output into another sheet, it
doesn't work. Pls help me here.
Regards
Amit
On 11 November 2014 11:01, Amit Gandhi silkyro...@gmail.com wrote:
Thanks Vaibhav.
Its exactly what is needed, thanks a lot.
Can we do this using Excel VBA
How it is to be used?
On Fri, May 17, 2013 at 10:27 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Use it *
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR
*Sent:* 17 May 2013 10:19
*To:* excel-macros@googlegroups.com
If anyone can help me on this.
On Fri, Mar 8, 2013 at 12:41 PM, Amit Gandhi silkyro...@gmail.com wrote:
Thanks Ashish. Good work.
But this UDF doesn't satisfy Criteria 3 i.e.
Criteria 3 -- Sorting order will be from B -- J.
(a) if you see in your solution file Row 6 7 (Name G A) has
Hi Experts
I have an excel data and I want to sort data based on below criteria using
Macro. pls help me here.
*Column B to J has data which is to be sorted as per Highlighted CELLS *
Criteria 1 -- Highlighted cells should come first.
Criteria 2 -- Row which has more highlighted cells from B to
PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I have an excel data and I want to sort data based on below criteria
using Macro. pls help me here.
*Column B to J has data which is to be sorted as per Highlighted CELLS *
Criteria 1 -- Highlighted cells should come first.
Criteria 2
Hi Experts
I want to highlight minimum value of some particular columns say columns
D,H,L in attached file through Conditional Formatting. How it can be
possible? Pls help me here.
Regards
Amit
--
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) !
Thank Viper
On Wed, Feb 13, 2013 at 5:36 PM, The Viper viper@gmail.com wrote:
pfa and check formula in conditional formating
On Wed, Feb 13, 2013 at 4:45 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I want to highlight minimum value of some particular columns say columns
D
Application.CutCopyMode = False
Range(n4).Select
End Sub
Regards
Amresh
On Wed, Jan 16, 2013 at 12:31 PM, Amit Gandhi silkyro...@gmail.com
wrote:
Hi Experts
I have some data and I have get minimum no out of that by MIN formula.
Now I
want a formula or VBA macro to do following.
1. Minimum
, Jan 16, 2013 at 4:57 PM, Amit Gandhi silkyro...@gmail.com wrote:
Thanks Anil
But i am unable to do so? Can you show this in example file.
Regards
Amit
On Wed, Jan 16, 2013 at 2:03 PM, अनिल नारायण गवली
gawlianil8...@gmail.com
wrote:
Dear Amit,
U can use conditional
.PatternTintAndShade = 0
End With
End If
n = n + 1
Next
Range(a1).Select
End Sub
On Wed, Jan 16, 2013 at 4:57 PM, Amit Gandhi silkyro...@gmail.com
wrote:
Thanks Anil
But i am unable to do so? Can you show this in example file.
Regards
Amit
On Wed, Jan 16, 2013 at 2
Hi Experts
I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.
1. Minimum of column D, H, L gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.
Pls see sample file attached.
Pls
Hi Experts
I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do following.
1. Minimum of column D, H, L gets highlighted as shown above.
2. Minimum's name is mentioned against each cell in column O.
Pls see sample file attached.
Pls
-- Forwarded message --
From: Amit Gandhi silkyro...@gmail.com
Date: Tue, Jan 15, 2013 at 1:07 PM
Subject: $$Excel-Macros$$
To: excel-macros@googlegroups.com
Hi Experts
I have some data and I have get minimum no out of that by MIN formula. Now
I want a formula or VBA macro to do
Thanks dear
Its really fast.
Regards
Amit
On Sat, Dec 22, 2012 at 6:45 PM, Excel Beginner excelbegin...@gmail.com
wrote:
Hi Amit,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi silkyro...@gmail.com wrote
Hi Experts
I am attaching an excel file, where I have applied LOOKUP/INDIRECT function
in sheet backup. But its very slow in working/opening. And when data is
large, it takes too much time for processing.
Is there any better fast way to get the same output?
Please help me here.
Regards
Amit
)*(INDIRECT(' B3
_WBQ'!$E:$E)=C$2)),INDIRECT(' B3 _WBQ'!$K:$K))
PFA file for reference, have hilighted cell in green which has correct
formula.
Regards,
Swapnil.
On Tue, Dec 18, 2012 at 12:11 PM, Amit Gandhi silkyro...@gmail.comwrote:
Hi Swapnil
I want a vba code/ or excel formula to make
Hi Experts
I need a macro which will fill-in mentioned formulas in cell C3 to K4 for
sheet backup and get the desired results.
activesheet.range(c2)= =LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*^BSESN*
_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)
i need macro to get above red highlighted values from
Hi Swapnil
I am not very good in VBA, can you please send me macro code for this.
Regards
Amit
On Mon, Dec 17, 2012 at 5:54 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi,
Try formula function of class Range
Regards
Swapnil
On Dec 17, 2012 5:16 PM, Amit Gandhi silkyro
,
As long as ever you can.” - John Wesley
*-
--
*From:* Amit Gandhi silkyro...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Mon, December 3, 2012 11:55:15 PM
*Subject:* Re: $$Excel-Macros$$ MACRO FOR LIST CHECK
Hi Experts
Pls help me on below.
Regards
Amit
On Sat, Dec 1, 2012 at 11:40 AM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Paul
This is not working. I am trying to elaborate more step by step what I
required.
Step 1. Macro will check in sheet *TT,* column A (A6 onwards) with *
TTlist
), then it fill-in the value in
cell A8, and search for next value.
To summarise, i need solution as shown in sheet SOLUTION_REQD.
Pls help me here.
Regards
Amit
On Wed, Nov 28, 2012 at 12:30 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I have created a list in Name Manager named TTlist
Hi Experts
I have created a list in Name Manager named TTlist for values shown in
LIST sheet of attached file. I used to update this TTlist with some
other macro.
I have another sheet named TT in which 1st 5 rows are constant. I sued to
fill-in data from 6th row on-wards.
I need a macro which
Hi Experts
If there is any formula which can calculate MOST REPEATED NO from a list?
Sample file attached.
Pls help me here.
Regards
Amit
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Amit Gandhi silkyro...@gmail.com
*To:* excel
))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* Amit Gandhi silkyro...@gmail.com
*Sent:* Friday, August 17, 2012 1:30 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ MOST REPEATED
Congrats Noorain
On Sun, Aug 5, 2012 at 11:41 PM, prkhan56 prkha...@gmail.com wrote:
Great Work Noorain Bhai..Keep it up
On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote:
Dear members,
Noorain Ansari has been selected as 'Most Helpful Member' for the month
of July'12. He has
= Target.Cells.Font.ColorIndex
End If
End Sub
*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jul 5, 2012 at 3:51 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I need a macro which changes the FONT COLOR of ENTIRE ROW as per font
color
Then
Target.EntireRow.Interior.ColorIndex = Target.Cells.Font.ColorIndex
End If
End Sub
*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jul 5, 2012 at 3:51 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I need a macro which changes the FONT
:38 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Noorain
Pls elaborate more.
1st Example --
I have file named File1, which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in File1 Open event, so that it can UPDATE
Hi Experts
I need a macro which changes the FONT COLOR of ENTIRE ROW as per font color
of a particular cell in that row. Sample file attached.
Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Thanks Ashish
Its perfectly working.
On Tue, Jul 3, 2012 at 7:43 PM, ashish koul koul.ash...@gmail.com wrote:
Sub sample()
Sheets(Sheet1).Range(d4:d20).FillDown
End Sub
On Tue, Jul 3, 2012 at 1:35 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I want to copy formula of cell
Thanks Prince
On Tue, Jul 3, 2012 at 10:08 PM, Prince Dubey prince141...@gmail.comwrote:
Hi Amit,
Please see the attachment.
regards
Prince Dubey.
On Tuesday, 3 July 2012 13:35:23 UTC+5:30, Mitr wrote:
Hi Experts
I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in
Hi Experts
Pls help me with VBA code for UPDATING External links in a excel file
whenever I open that file.
Pls help me with VBA code to PREVENT excel to UPDATE External links in a
excel file whenever I open that file.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
ANSARI noorain.ans...@gmail.comwrote:
Dear Amit,
Please use it..in Workbook_Open Event
Private Sub Workbook_Open()
Workbooks.Open FileNmae:=D:\VBA_Class\LinkedBook.xls,
UpdateLinks:=xlUpdateLinksAlways
End Sub
On Wed, Jul 4, 2012 at 3:48 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi
Hi Experts
I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in
attached file.
Pls help me providing this macro code.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
for the row headers. thanks
On Tue, Jun 26, 2012 at 9:54 AM, Amit Gandhi silkyro...@gmail.com wrote:
Nice Creativity Hilary
As I am new to these things, can I know how you Freezed Columns A to G
and Rows 1 to 18 (and others Column Row headers are not showing)? How you
freezed scrolling
Thanks alot Mr. Rajan
This function is Perfectly as per my requirement.
Thanks once again
Amit Gandhi
On Sat, Jun 23, 2012 at 6:45 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
HI Amit,
** **
This function can work independently, you just need to understand the
function Arguments
Hi Experts
Pls help me with a way, so that a Macro runs whenever I open a particular
excel file. (Macro is in that excel file only).
Regards
Amit
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Hi Experts
I have two Input/Lookup tables, and 1 result table. I want a formula which
can give me desired result instantly. Sample file is attached for your
ready reference.
How it will be possible? Pls help me here.
Regards
Amit
--
--
FORUM RULES (986+ members already BANNED for violation)
:
** **
How is counts Calculated in Input table 2?
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi
*Sent:* 22 June 2012 5:20
*To:* excel-macros
Hi Experts
I want to Lookup PO No. from Lookup data and return all results if there
are multiple occurrences.
How it will be possible? Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
thanks Mr Pandey
On Sat, Jun 9, 2012 at 3:03 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Amit,
See the attached file where I have used Index Match function in
combination with Row n Arrays to achieve the desired result. Thanks.
Regards,
DILIPandey
On 6/9/12, Amit Gandhi silkyro
, May 29, 2012 at 12:48 PM, Amit Gandhi silkyro...@gmail.comwrote:
Thanks Noorain
But i need something else. Let me clarify more. I am attaching revised
excel file.
I have some BL numbers in 2nd sheet BL_list and I want to enter Invoice
details (INV#, INV DATE, INV AMT) against some B/L#s. I
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 12:48 PM, Amit Gandhi silkyro...@gmail.comwrote:
Thanks Noorain
But i need something else. Let me clarify more. I am attaching revised
excel file.
I have some BL numbers in 2nd sheet BL_list and I want to enter
Invoice details
Hi Mr. Anil
This is not the solution i am looking for. I need to pick this from some
LIST for every cell.
Regards
Amit
On Tue, May 29, 2012 at 11:41 AM, Anil Gawli gawlianil8...@gmail.comwrote:
see the attached sheet
Regards
Gawli Anil
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi
),12))*
See attached sheet
Hope it will help to you.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi silkyro...@gmail.comwrote:
Hi Experts
I want to pick value in Cell C7, C8, C9 ………from List
Hi Experts
I want to pick value in Cell C7, C8, C9 ………from List given in Column
L in attached file.
How it will be possible? Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Thanks Jay, for wonderful example.
On Thu, May 24, 2012 at 6:03 PM, Jai jaihumtu...@gmail.com wrote:
please see the attachment
On Thu, May 24, 2012 at 6:01 PM, Amit Gandhi silkyro...@gmail.com wrote:
thanks sir
On Wed, May 23, 2012 at 6:00 PM, dguillett1 dguille...@gmail.com wrote
*-
--
*From:* Amit Gandhi silkyro...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Wed, May 23, 2012 7:48:26 AM
*Subject:* $$Excel-Macros$$ VLLOKUP IS NOT WORKING
Hi Experts
VLOOKUP is not working in attached file, can anyone help me
thanks
On Thu, May 24, 2012 at 4:09 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi
Try ths
=VLOOKUP(E3,Sheet1!E3:G20,3,FALSE)
On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
VLOOKUP is not working in attached file, can anyone help me why its
at 5:16 PM, Amit Gandhi silkyro...@gmail.com
wrote:
Hi Experts
VLOOKUP is not working in attached file, can anyone help me why its not
working and what will be right formula?
Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation
Thanks Mr. Haseeb
Perfect solution.
Thanks a lot.
Amit
On Tue, May 22, 2012 at 11:06 PM, Haseeb A haseeb.avarak...@gmail.comwrote:
Hello Amit,
Keep PO Bill Party Bill on different tab, so can easily update it. See
the attached.
Addition: If you use Table format, formula will
Hi Experts
VLOOKUP is not working in attached file, can anyone help me why its not
working and what will be right formula?
Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Hi Experts
VLOOKUP is not working in attached file, can anyone help me why its not
working and what will be right formula?
Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Thanks Mr. Lakshman.
On Wed, May 23, 2012 at 5:37 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
see the attached file
*From:* Amit Gandhi silkyro...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Wednesday, May 23, 2012 5:18 PM
*Subject:* $$Excel-Macros$$ VLLOKUP
www.excelmacroworld.blogspot.com
On Wed, May 23, 2012 at 5:18 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
VLOOKUP is not working in attached file, can anyone help me why its not
working and what will be right formula?
Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members
*-
--
*From:* Amit Gandhi silkyro...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Wed, May 23, 2012 7:48:26 AM
*Subject:* $$Excel-Macros$$ VLLOKUP IS NOT WORKING
Hi Experts
VLOOKUP is not working in attached file, can anyone help me why its not
working and what will be right
#
. You can look into attached Sample File for better understanding. In that
file I have shown the result what I want in column I.
Pls help me here.
Regards
Amit
On Mon, May 21, 2012 at 4:47 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I am finding some problem in excel formula, pls
On Tue, May 22, 2012 at 11:41 AM, Amit Gandhi silkyro...@gmail.comwrote:
Hi Experts
I am finding some problem in excel formula, pls help me here. I have a
excel data at two locations, 1st is Supplier's Bill details and 2nd is
Purchase order details. I need a formula that can distribute the Party
Hi Experts
I am finding some problem in excel formula, pls help me here. I have a
excel data at two locations, 1st is Supplier's Bill details and 2nd is
Purchase order details. I need a formula that can distribute the Party
Bill Amount figure proportionately to PO Amount figures based on B/L#
.
very useful sheet. thanks for sharing.
On Mon, Nov 28, 2011 at 12:20 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Thanks Ankit,
Very useful sheet you have shared with Group.
--
Thanks regards,
Noorain Ansari
)*
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi silkyro...@gmail.comwrote:
Thanks alot Noorain
It works
, 2011 at 10:33 AM, Amit Gandhi silkyro...@gmail.comwrote:
Thanks alot Noorain
It works fine.
But I also want to automate Column E i.e. it automatically retrieve Co
Name as well. If you can help me here as well.
Regards
Amit
On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI
noorain.ans
thanks.
On Sat, Sep 24, 2011 at 8:53 PM, ashish koul koul.ash...@gmail.com wrote:
try this
cell f5 = SUMPRODUCT(($A$4:$A$150=F$3)*($B$4:$B$150=$E5)*($C$4:$C$150))
and drag the formula right
On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Folks
I am
at 5:31 PM, Amit Gandhi silkyro...@gmail.comwrote:
Hi Folks
I am finding some problem in excel data. I have a excel data (attached
file) in vertical form. I want to convert it into Horizontal form using
Excel Formulas.
Pls help me here.
Regards
Amit
Hi Folks
I am finding some problem in excel data. I have a excel data (attached file)
in vertical form. I want to convert it into Horizontal form using Excel
Formulas.
Pls help me here.
Regards
Amit
--
--
Some
in the
lower
window and are selectable to jump to their location
http://www.pcreview.co.uk/forums/do-locate-merged-cells-my-excel-worksheet-t3785983.html
On Thu, Sep 15, 2011 at 1:15 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Folks
I am finding some problem in excel data. Pls help me here
Hi Folks
I am finding some problem in excel data. Pls help me here. I have a excel
data in 10 columns and 2 rows. There are some MERGED CELLS in this data.
I am applying filters and its not working due to merged data. Is there any
way in Excel to find merged cells automatically.
Pls help me
, Jun 14, 2011 at 7:30 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Amit,
Please see attached sheet..
--
Thanks regards,
Noorain Ansari
On Tue, Jun 14, 2011 at 6:38 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Folks
I am finding some problem in excel formula, pls
to Copy Paste
Kindly see attached sheet
=SUMPRODUCT(MAX(($A$6:$A$15=A6)*($C$6:$C$15)))
--
Thanks regards,
Noorain Ansari
On Wed, Jun 15, 2011 at 6:07 PM, Amit Gandhi silkyro...@gmail.com wrote:
Thanks Noorian
But there is still some problem. If I copy your formula in my
Hi Folks
I am finding some problem in excel formula, pls help me here. I have a excel
data in two columns, one is some job code and 2nd is its completion date in
different units. I need a formula that can show final completion date
against each job code. You can look into attached excel data
76 matches
Mail list logo
