Hi Neeraj,
You can use the Consolidate function of Excel to achieve the same. Please
follow the link below for the steps:
http://support.microsoft.com/kb/214270
Cheers,
Andy
On Tue, Nov 15, 2011 at 4:00 PM, Neeraj Chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
How can I make
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help Required
Hi Neeraj,
You can use the Consolidate function of Excel to achieve the same. Please
follow the link below for the steps:
http://support.microsoft.com/kb/214270
Cheers,
Andy
On Tue, Nov 15, 2011 at 4:00 PM, Neeraj Chauhan
Hi Vijayajith,
Data validations can be created from one workbook to another
workbook.
Example:
Attached are the two workbook
1. Source_Book.xlsx
2. My_Book.xlsx
My list is available in Source_Book - sheet1 -
range(A1:A5)
and my validation is in workbook - My_Book.xlsx - Sheet1 -
Hi Neeraj,
This can be achieved with the use of Pivots.
Attached is the Solution.
Please let me know if you need any clarification.
Cheers,
Andy
On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
** **
Kindly find the attached sheet.
Dear Neeraj,
Please try through below formula, See attached sheet..
=OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),),COUNTIF($I$2:$I2,$I2))-1,0)
Press ctrl+shift+enter
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Good one Noorain..
Can you help how this array works please..
Cheers,
Andy
On Fri, Nov 11, 2011 at 3:34 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Neeraj,
Please try through below formula, See attached sheet..
In this particular sample you can simply filter by date. However, that may not
be what you need in all cases??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, November 11, 2011 4:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
--
*From: * vijayajith VA vijayajith...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Thu, 10 Nov 2011 19:41:37 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ help me
hi
I have
: * excel-macros@googlegroups.com
*Date: *Thu, 10 Nov 2011 07:25:57 -0600
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* vijayajith VA
...@gmail.com
*From:* NOORAIN ANSARI noorain.ans...@gmail.com
*Sent:* Friday, November 11, 2011 4:04 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help Required.xlsx
Dear Neeraj,
Please try through below formula, See attached sheet..
=OFFSET($D$1,SMALL(IF($B$2:$B
Hello Noorie Sam;
Good ones, but as you know, If a site has LARGE date more than 1 (*not sure
does the OP have this situation or not*), this wouldn't work as
expected. I think the attached would work.
__
HTH
Haseeb
--
FORUM RULES (934+ members already BANNED for violation)
1)
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 6:11 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help me
HI
I have some datas in tab with coloumns(code and name)
in one more tab with same datas but
@googlegroups.com
Date: Thu, 10 Nov 2011 07:25:57
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 6:11 AM
To: excel-macros
Please Copy in a filter mode the desired data. Then select all (alt d f s) and
in desired column use paste special (alt e s v ) and select skip blank option
there.
Hope fully it will solve ur queries.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From:
: *Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* vijayajith VA vijayajith...@gmail.com
*Sent:* Thursday, November 10, 2011 6:11 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ help me
HI
I have some datas
Copy values to an UN filtered destination.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 8:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me
hi
I have tried using pastespecial but its working
its
--
*From: * dguillett1 dguille...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Thu, 10 Nov 2011 07:25:57 -0600
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
, 10 Nov 2011 19:41:37
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me
hi
I have tried using pastespecial but its working
its copying only two cells
can you help me ?
Pleas find the attachment
Thank you
On Thu, Nov 10, 2011 at 7
You need to post your file or a least your code
How does a jew workbook differ from a gentile workbook?
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Clinton James
Sent: Tuesday, November 08, 2011 7:55 PM
To: MS EXCEL AND VBA MACROS
Subject:
Hehe, Don, I'm sure he meant 'new'
Clinton,
Is there any sheet movements in your macro? Maybe worth posting your VBA
code.
Regards,
Sam Mathai Chacko
On Wed, Nov 9, 2011 at 6:36 PM, dguillett1 dguille...@gmail.com wrote:
You need to post your file or a least your code
How does a jew
Hehe!
I knew that
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Wednesday, November 09, 2011 9:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help: excel changes macro assignment
Hehe, Don, I'm sure he meant 'new'
Clinton
-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help me
Hi
Thank you Very much for your help.
If i run this macros.Some error is showing like VA_book1.xls is not found
error 1004
i have saved correctly in my folder i run the macros but its not working
Please help me
On Sun, Nov 6
Sent: Monday, November 07, 2011 9:35 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me
Hi Don Guillett,
Once again thank you very much .
I those two excelbooks saved one folder and named as VA_book1.xls - (one file
-blank file)
and one more file saved as VA_book2.xls .i
Software
dguille...@gmail.com
*From:* Mahreen Ellahi mahreen.acc...@gmail.com
*Sent:* Thursday, November 03, 2011 10:33 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
I ve to add points scored in each table. When the points are NA, total
is not possible. Plz see
I ve to add points scored in each table. When the points are NA, total is
not possible. Plz see attached file.
Mahreen
On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Mahreen,
If you have multiple ratio values define a name for them each, like
Table1,
What do you want when one or the other is NA and how is the cell populated with
NA
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mahreen Ellahi
Sent: Thursday, November 03, 2011 10:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
I ve to add points
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
I ve to add points scored in each table. When the points are NA, total is
not possible. Plz see attached file.
Mahreen
On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Mahreen
Guillett
SalesAid Software
dguille...@gmail.com
*From:* Mahreen Ellahi mahreen.acc...@gmail.com
*Sent:* Thursday, November 03, 2011 10:33 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
I ve to add points scored in each table. When the points are NA, total
*Subject:* Re: $$Excel-Macros$$ Help
I ve to add points scored in each table. When the points are NA, total is
not possible. Plz see attached file.
Mahreen
On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Mahreen,
If you have multiple ratio values define
Mahreen, I am getting 1 and -2 as answers, and after looking at the
formula, I don't think there's anything wrong with the result. I am also
able to select NA, or the Scores. Are you facing some other problem? If
yes, please explain.
Regards,
Sam Mathai Chacko
On Wed, Nov 2, 2011 at 7:29 PM,
Mahreen,
If you have multiple ratio values define a name for them each, like Table1,
Table2 choose which table to use.
See the attached.
HTH
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Here's how you do it Mahreen.
Create a named range using the formula you already have. And in validation,
use List, and type NA,=NmRnge
where NmRnge is your named range
Check attached.
Sam
On Tue, Nov 1, 2011 at 9:53 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote:
Guys
I have some
Hey thanks, but one more prob, wen i sum up all such scores with few
numbers and text NA, i cant derive the total score. Ofcourse its a text
thatsy but is there any possibility i can show the result ignoring the NA
On Tue, Nov 1, 2011 at 10:23 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Why don't you use something like this
=SUMIF(A1:A10,NA)
Regards,
Sam
On Tue, Nov 1, 2011 at 10:58 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote:
Hey thanks, but one more prob, wen i sum up all such scores with few
numbers and text NA, i cant derive the total score. Ofcourse its a text
Hello Sam;
A nice solution with Validation.
Hello Mahreen;
If you use 3, 2, 1 (number inside ) this will return the number as
text. When you do calculation excel is considering these as text. Use it
without or you can simplify the formula to;
Perhaps you can attach a file(s)
1. can be solved with a loop where the file names are listed in a2:a22
Cash Disbursement Schedule.xls
etc
sub openfilesinlist()
mymonth=OCTOBER 'or an inputbox asking for the month or in a cell...
for each myfile in range(a2:a22)
Workbooks.Open Filename:= _
\
--
*From:* Aamir Shahzad aamirshahza...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Sunday, 23 October 2011 4:28 PM
*Subject:* Re: $$Excel-Macros$$ HELP REQUIRED
Can you please brief how to use apply the codes in excel.
Aamir Shahzad
On Fri, Oct 21, 2011 at 1:30 AM, hanumant
happy to help.
Note: in place of your path give \ at the end of the path. i.e.
C:\Documents and Settings\
--
*From:* Aamir Shahzad aamirshahza...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Sunday, 23 October 2011 4:28 PM
*Subject:* Re: $$Excel-Macros
of the path. i.e.
C:\Documents and Settings\
--
*From:* Aamir Shahzad aamirshahza...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Sunday, 23 October 2011 4:28 PM
*Subject:* Re: $$Excel-Macros$$ HELP REQUIRED
Can you please brief how to use apply
to help.
Note: in place of your path give \ at the end of the path. i.e.
C:\Documents and Settings\
--
*From:* Aamir Shahzad aamirshahza...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Sunday, 23 October 2011 4:28 PM
*Subject:* Re: $$Excel-Macros$$ HELP
For book #s starting at 1001 and changing every 10 rows;
Put in cell A2:
=IFERROR(OFFSET(A2,-10,0)+1,1001)
In case of Excel version prior to 2003, which doesn't support IFERROR, use:
=IF(ROW(A2)11,OFFSET(A2,-10,0)+1,1001)
Change default book # in formula as desired. Copy down.
So what exactly do you want? Your attachment isn't clear as to what formula
you require.
From what I understood, have made a sheet with sequence of receipt leaflets,
depending on the number of leaves and starting number.
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 24, 2011 at 7:04 PM, sriram
Maybe???
=IF(COUNTIF(A:A,D4)=10,No,)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: sriram ji
Sent: Monday, October 24, 2011 8:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed..?
Dear All,
Kindly find the attached file, and provide
AM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Help needed..?
For book #s starting at 1001 and changing every 10 rows;
Put in cell A2:
=IFERROR(OFFSET(A2,-10,0)+1,1001)
In case of Excel version prior to 2003, which doesn't support IFERROR, use:
=IF(ROW(A2)11
Rossoff
Sent: Monday, October 24, 2011 8:16 AM
To: 'Asa Rossoff'; excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help needed..?
I agree with Sam that your requirement isn't 100% clear. He gave a solution
for one interpretation.
I'll flesh out mine.
=IFERROR(OFFSET(A2,-10,0
Hi Sriram,
Please find attached solved sheet.
Thanks
Mukesh
- Original Message -
From: sriram ji
To: excel-macros@googlegroups.com
Sent: Monday, October 24, 2011 7:04 PM
Subject: $$Excel-Macros$$ Help needed..?
Dear All,
Kindly find the attached file, and provide
Can you please brief how to use apply the codes in excel.
Aamir Shahzad
On Fri, Oct 21, 2011 at 1:30 AM, hanumant shinde arsfan2...@yahoo.co.inwrote:
yes very much possible with hardly 5 lines of code (if u want it for time
being).
send us the file or use the below code in the file if u
Contact Noorian Ansari NOORAIN ANSARI noorain.ans...@gmail.com,
On Sun, Oct 23, 2011 at 11:11 AM, ram gopal yadav er.rgya...@gmail.comwrote:
Hi all,
Kindly tell me that from where i can learn advanced excel in
noida(U.P).
please tell me the best institute/faculty in noida from where i can
Noor is the best teacher . you can contact him. he has great skills in excel
.
On Sun, Oct 23, 2011 at 10:10 PM, ashish koul koul.ash...@gmail.com wrote:
Contact Noorian Ansari NOORAIN ANSARI noorain.ans...@gmail.com,
On Sun, Oct 23, 2011 at 11:11 AM, ram gopal yadav
. i.e. C:\Documents
and Settings\
From: Aamir Shahzad aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sunday, 23 October 2011 4:28 PM
Subject: Re: $$Excel-Macros$$ HELP REQUIRED
Can you please brief how to use apply the codes in excel.
Aamir
yes very much possible with hardly 5 lines of code (if u want it for time
being).
send us the file or use the below code in the file if u can.
Sub Macro1()
ChDir Your Path
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
wrksht.Copy
Dear Surya,
Please see attached sheet
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.bv
Hi Noorain,
Could you plz make me understand how has it been done?
Thanks
Regards,
Ankit
On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Surya,
Please see attached sheet
--
Thanks regards,
Noorain Ansari
Dear Ankit,
Please see attached sheet with explain
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Oct 17, 2011 at 7:06 PM, Ankit Agrawal
Here's an accurate list.
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 17, 2011 at 8:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Ankit,
Please see attached sheet with explain
Thanks regards,
Noorain Ansari
Hello Surya;
If your data is sorted by Country in Ascending order, use the file
sorted_by_Country. The other one will work with sorted or unsorted data.
Also used dynamic range.
HTH
Haseeb
--
--
Some important
Kindly send text file..
On Sat, Oct 15, 2011 at 5:55 PM, santhu santhosh.qat...@gmail.com wrote:
Hi,
How to extract a text file data to an excel sheet.
Ex: Sl.no FirstName MiddleName LastName Place
1 ABC abc India
2 DEF
can you attach the sample file
On Sat, Oct 15, 2011 at 5:55 PM, santhu santhosh.qat...@gmail.com wrote:
Hi,
How to extract a text file data to an excel sheet.
Ex: Sl.no FirstName MiddleName LastName Place
1 ABC abc India
2 DEF
Try importing data from external file Text file. When you import, you'll
get an option to use a delimiter. Normally, text files are delimited using
tab, or space.
Regards,
Sam Mathai Chacko (GL)
On Sat, Oct 15, 2011 at 6:25 PM, XLS S xlst...@gmail.com wrote:
Kindly send text file..
On
Send sample file
On 15 Oct 2011 21:51, santhu santhosh.qat...@gmail.com wrote:
Hi,
How to extract a text file data to an excel sheet.
Ex: Sl.no FirstName MiddleName LastName Place
1 ABC abc India
2 DEF def
Should do it. Or just use AUTOFILTER on the original to get one at a time to
view.
Option Explicit
Sub GetCountryData_SAS()
'fire while at Tes sheet
Dim lr As Long
Dim i As Long
Columns(I).Delete
lr = Cells(Rows.Count, 1).End(xlUp).Row
'get unique list
Range(h1:h lr).AdvancedFilter
.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: Tuesday, October 04, 2011 6:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row
Thanks Rajan I need
Try this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim lngValueAs Long
Dim intICounter As Integer
Dim strMsg As String
Dim lngValue2 As Long
lngValue = Target.Value
lngValue2 = Target.Offset(0, -1).Value
If
excellent solution, launching the message showing the repeat value
thank you very much for your time and attention Rajan
Chilexcel
2011/10/5 rajan verma rajanverma1...@gmail.com
Try this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim lngValue
Jai
another excellent solution provided by Rajan Berma
Try this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim lngValueAs Long
Dim intICounter As Integer
Dim strMsg As String
Dim lngValue2 As Long
lngValue = Target.Value
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *ChilExcel
*Sent:* Tuesday, October 04, 2011 6:33 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in
row
** **
Thanks Rajan I need is to columns B and C (together
!
All the best,
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: Wednesday, October 05, 2011 5:32 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row
Thanks Asa
I need also this VB Code
On Mon, Oct 3, 2011 at 4:41 AM, ChilExcel chilexcel...@gmail.com wrote:
Urgent !!
i Need VB lines codes for
2011/10/1 ChilExcel chilexcel...@gmail.com
hi
i Need VB lines codes for
Alert MsgBox Pair duplicate entry in row
Column D function account and
Try this Code :
this Code enable you to check the duplicate entry at the time of Data Entry
..
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngValueAs Long
Dim intICounter As Integer
Dim strMsg As String
lngValue = Target.Value
If Intersect(Target,
Thanks Rajan I need is to columns B and C (together)
containing the mirrored pair in same row
good solution you propose, but only in column B duplicate
Thanks Rajan
2011/10/4 rajan verma rajanverma1...@gmail.com
Try this Code :
this Code enable you to check the duplicate entry at the time
Please see Mathai solution proposed by Sam Chacko
Excellent!
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngCount As Long
Dim lngLoop As Long
Dim strMsg As String
lngCount =
Evaluate(=SUMPRODUCT((Hoja1!$B$2:$B$57Hoja1!$C$2:$C$57)*(Hoja1!$B$2:$B$57=Hoja1!B
Chil,
Paste this code in the sheet code module of the respective sheet. Now once
any entry is made in any row of B C, it will check and display a message
if any duplicate is found.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngCount As Long
Dim lngLoop As Long
Dim
Excellent, exactly what I needed thank you very much Sam !!!
2011/10/3 Sam Mathai Chacko samde...@gmail.com
Chil,
Paste this code in the sheet code module of the respective sheet. Now once
any entry is made in any row of B C, it will check and display a message
if any duplicate is
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: Monday, October 03, 2011 12:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row
Chil,
Paste this code in the sheet code
Hi Amit,
Follow steps carefully in sequence
Add 3 named ranges as below
Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT(z,20),LOG!$E$2:$E$1,1))
EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1))
Data=IF((EntryDate=Sheet2!$A1)*(EntryDate=Sheet2!$B1)=1,Vehicle,)
for appreciating Meru's service
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sam Mathai Chacko
Sent: 02 October 2011 21:28
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help needed to find total Unique count from
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help needed to find total Unique count
from a range of moving dates
** **
Hi Amit,
Follow steps carefully in sequence
Add 3 named ranges as below
Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT(z,20),LOG!$E$2:$E
Urgent !!
i Need VB lines codes for
2011/10/1 ChilExcel chilexcel...@gmail.com
hi
i Need VB lines codes for
Alert MsgBox Pair duplicate entry in row
Column D function account and duplicates alerts (NO Problem!)
Attach File , thank you all
--
Visita ;
HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.com wrote:
HI group,
This is a Great amazing group in learning excel vba..
*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma rajanverma1...@gmail.comwrote:
HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.com wrote:
HI group,
This is a Great
Please VIsit this Page..
http://www.cpearson.com/excel/Events.aspx
On Sat, Oct 1, 2011 at 12:09 PM, XLS S xlst...@gmail.com wrote:
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma rajanverma1...@gmail.comwrote:
HI,
Please visit this Page to know more about
Thanks rajan babu, for that link.Can anybody quote some more examples in
detail.I just got a little understanding of the function with arguments.But
to enhance my knowledge i would like to study more examples...Pls provide me
with any other examples.
On Sat, Oct 1, 2011 at 12:18 PM, rajan
Here is one I like to use for setting variables (Options) in a file
that is used by other Macros.
Using the Macro below; I can toggle between True and False on the
Options and Colors for specific cells.
Available Options
Star Font Size =16
Label
Hidden Column Names
http://www.excelvbamacros.com/2011/09/find-hidden-column-names-in-sheet.html
Hidden Row Numbers
http://www.excelvbamacros.com/2011/09/find-hidden-row-number-in-worksheet.html
On Sat, Sep 24, 2011 at 4:41 PM, naanu v naanu2...@gmail.com wrote:
Kindly let me know how to
Dear naanu,
you can also try
*Prepare-Inspect Document-Check Hidden Rows and Columns-Press Inspect Button
*
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
Dear Vijay,
Please check below link
https://www.odesk.com/.../*Global*-*Reporting*
-Analyst-with-strong-backgroundhttps://www.odesk.com/.../Global-Reporting-Analyst-with-strong-background
--
Thanks regards,
Noorain Ansari
Thank you Daniel
On Fri, Sep 9, 2011 at 2:56 PM, Daniel dcolarde...@free.fr wrote:
Hi,
** **
See attached file.
** **
Regards.
** **
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* Kal xcel
*Envoyé :*
result by IF function
regards,
Pawel
From: anu gomathi anugomathi.d...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, September 6, 2011 9:00 PM
Subject: $$Excel-Macros$$ Help in IF Function
Hi All,
Please help me to put the IF function for the
I would adise you to do the following:
1. Concatenate the three cells I.e., region, province and barangay in both
the Sheets.
2. Now use index and match.
Let me know if this clear.
Regards,
Joe
On Tuesday, September 6, 2011, John Alliage Tinio Morales
alliage.mora...@gmail.com wrote:
Hi, I am
Thanks a lot pawel
Regards
Anu
On Wed, Sep 7, 2011 at 12:41 AM, pawel lupinski lupins...@yahoo.com wrote:
result by IF function
regards,
Pawel
--
*From:* anu gomathi anugomathi.d...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, September
: $$Excel-Macros$$ Help to create summary table count
unique
Dear ChilExcel,
For Unique Count...
Use below function..with Ctrl+shift+Enter..
*=SUM(1/COUNTIF(I1:I28,I1:I28))*
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*http://noorain
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help to create summary table count unique
I have solved my problem Thank www.contextures.com everything I need in
a PivotTable without using macros
www.contextures.com excellent!! thanks
2011/8/26 ChilExcel chilexcel...@gmail.com
--
*From: * ChilExcel chilexcel...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Sun, 4 Sep 2011 12:36:39 -0400
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique
I have
Hi vijay,
Please send some sample data...for your requirement..
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
i have four words and i need to combine using trim and proper functions.
Please can you provide me
Use Concatenate
=Concatenate(Proper(Trim(YourWord)), Proper(Trim(YourWord))
Or Sign
Proper(Trim(YourWord)) Proper(Trim(YourWord))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Tuesday, August 30, 2011 7:27 PM
Dear Vijay,
if your Word in one cell you can use...
=PROPER(Trim(SUBSTITUTE(D4, ,)))
On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
i have four words and i need to combine using trim and proper functions.
Please can you provide me formula
Thank
: *NOORAIN ANSARI noorain.ans...@gmail.com
*Sender: *excel-macros@googlegroups.com
*Date: *Fri, 26 Aug 2011 10:49:39 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: *excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique
Dear ChilExcel,
For Unique
*To: *excel-macros@googlegroups.com
*ReplyTo: *excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Help to create summary table count
unique
Dear ChilExcel,
For Unique Count...
Use below function..with Ctrl+shift+Enter..
*=SUM(1/COUNTIF(I1:I28,I1:I28))*
--
Thanks regards
Dear ChilExcel,
For Unique Count...
Use below function..with Ctrl+shift+Enter..
*=SUM(1/COUNTIF(I1:I28,I1:I28))*
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel
-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help to create summary table count unique
Dear ChilExcel,
For Unique Count...
Use below function..with Ctrl+shift+Enter..
*=SUM(1/COUNTIF(I1:I28,I1:I28))*
--
Thanks regards,
Noorain Ansari
*http://noorain
601 - 700 of 1211 matches
Mail list logo
