See the below web site ..
http://www.exceluser.com/explore/sumproduct_12.htm
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Request for
*hi
*
all of these are goog_220687958array formulas
The following formulas will return the number of distinct items in the range
B2:B11. .
The following formula is the longest but most flexible. It will properly
count a list that contains a mix of numbers, text strings, and blank cells.
hi hanumant
you may find this to be useful
http://spreadsheetpage.com/index.php...a_closed_file/http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/
[image: Reply With
Quote]http://www.excelforum.com/newreply.php?do=newreplyp=2079066
Have A Nice Time
No, We cant Copy the data from Closed Workbook.. but we can get the Data by
Using Full Reference of cell .. Like
='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July
try this book
http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf
On Tue, Jul 5, 2011 at 1:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
* *
http://excelpoweruser.blogspot.com/**
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com]
Hi,
Just Try Copy Paste it will work...
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde arsfan2...@yahoo.co.inwrote:
Hi friends,
is there any way where we can copy data from closed workbook A and paste
it
into workbook B which is open?
--
Congratulation Ashish...You deserve it
Kalyan
On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal ahmed.ga...@live.com wrote:
[image:
http://tracking.technodesignip.com/?action=countprojectid=642contentid=6543referrer=-urlaction=r...]Congratulations
*Ashish*, you deserve it.[image:
Thanks a lot its working fine. :)
On Mon, Jul 4, 2011 at 4:46 PM, Venkatesan c venkat1@gmail.com wrote:
Hi
just install the software and just open that software and click Remove
Password...Before that you have to open
Locked VBA Book..
--
*Best Regards,*
*Venkat*
*
*
On Mon,
tri this
=round(a1,-3)
On Mon, Jul 4, 2011 at 9:31 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Anshul,
As per the latest scenario provided by you, attached solution may help you.
Let me know if this works :)
Regards,
DILIPandey
On 7/4/11, Anshul Gupta thatsme.a...@gmail.com wrote:
Very useful linkThanks to ALL
Kalyan
On Tue, Jul 5, 2011 at 1:30 PM, ashish koul koul.ash...@gmail.com wrote:
try this book
http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf
On Tue, Jul 5, 2011 at 1:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
Can anybody suggest a suitable formula ?
With Warm Regards,
CA. Ajay Mittal
Finance Manager
[cid:image001.jpg@01CC3B1C.C8978CC0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312
From: excel-macros@googlegroups.com
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook
On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
I have 30 to 40 excel sheets in one workbook..if i want to copy all the
excel sheet
Hi,
I have 30 to 40 excel sheets in one workbook..if i want to copy all the
excel sheet data in one sheet . it takes time..
so is thr any macros for that .
Please help me
thanks in advance.
--
--
Some important
Use this In B2
=MID(SUBSTITUTE(TRIM(A2), ,*,2),FIND(*,SUBSTITUTE(TRIM(A2),
,*,2),1)+1,11)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of MITTAL AJAY
Sent: Tuesday, July 05, 2011 2:07 PM
To: 'excel-macros@googlegroups.com'
Subject:
hi Ajay
try this
=MID(B2,FIND( ,B2,FIND( ,B2)+1),FIND( ,B2,FIND( ,B2,FIND(
,B2)+1)+2)-FIND( ,B2,FIND( ,B2)+1))
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY amit...@iocl.co.in wrote:
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
** **
Can anybody suggest a suitable formula ?
**
Try this
Sub CompileSheet()
Dim Sh As Worksheet
Sheets.Add.Name = Compile
For Each Sh In ActiveWorkbook.Sheets
If Sh.Name Compile Then
Sh.Activate
ActiveSheet.UsedRange.Select
Congrats *Ashish,*
*
*
*
*
--
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 5, 2011 at 10:59 AM, Kal xcel kalx...@gmail.com wrote:
Congratulation Ashish...You deserve it
Kalyan
On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal ahmed.ga...@live.com wrote:
[image:
Hi,
you can use this formula as well in cell B2:-
=LOOKUP(99^99,--(0MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A20123456789)),ROW(INDIRECT(1:LEN(A2))
Best,
Manoj Kumar
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY amit...@iocl.co.in wrote:
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
Thanks Dave. Excellent ..
With Warm Regards,
CA. Ajay Mittal
Finance Manager
[cid:image001.jpg@01CC3B22.459EBEA0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Dave Bonallack
Sent: Tuesday, July
Hi All,
I have excel file with 12000+ rows, and 10 column where i have used Vlookup
and sumif function in the second row, i need a macro which copy down the
function till the last row with min. time frame.
Appreciate your support in advance.
Regards
Rash
--
Hi, Please see the original post. It will be really great if I can receive
some help here.
Regards,
Ronak
99874 12342
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Thanks Rajan .
It is working fine.
With Warm Regards,
CA. Ajay Mittal
Finance Manager
[cid:image001.jpg@01CC3B23.4A34CC10]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: Tuesday,
Thanks Ashish for the Invite.. I have accepted the same...
I would like to thank you million times for making me aware of this
post
On Jul 5, 10:29 am, Kal xcel kalx...@gmail.com wrote:
Congratulation Ashish...You deserve it
Kalyan
On Mon, Jul 4, 2011 at 11:17 PM, Ahmed
Congrats Ashish, now dont fly our expectation has now increased more.
--- On Tue, 7/5/11, Vasant vasant...@gmail.com wrote:
From: Vasant vasant...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish
Koul :)
To: excel-macros@googlegroups.com
Date:
Sub Test()
Dim Rng As Range
Lrow = ActiveSheet.Range(A65536).End(xlUp).Row ' Last Row in Column A.
Set Rng = ActiveSheet.Range(B1) ' Cell where you have the vlookup formula
Rng.AutoFill Destination:=Range(B1 :B Trim(Str(Lrow))),
Type:=xlFillDefault
End Sub
On Tue, Jul 5, 2011 at 2:58 PM, Rash
Hello EveryBody
Can You tell me that , Mail Merge is possible in One Excel File to Another
Excel file , if it is possible then How?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Hi Experts,
Please find the attached file tell me the code how to select the
date value in sheet2 cell A1 in Sheet 1. After selecting the row
then all the data in sheet2 range(B2:B11) have to copy paste in
the sheet1 colomns(B:K).
Regards
Rajesh Kainikkara
--
try this
Sub test()
Dim i As Long
For i = 2 To Sheets(1).Range(a65356).End(xlUp).Row
If DateValue(Sheets(1).Cells(i, 1).Value) =
DateValue(Sheets(2).Range(a1).Value) Then
k = Sheets(2).Range(iv2).End(xlToLeft).Column + 1
For j = 2 To 11
Sheets(2).Cells(j, k).Value = Sheets(1).Cells(i, j).Value
*hi rajesh
i used formulas in sheet 1 , to get data from sheet 2
just enter your data in sheet 2, it will be displayed against the date in
sheet 1
may this may help u
find attached file
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm
can you explaint it in detail what excatly you want to do
On Tue, Jul 5, 2011 at 4:56 PM, Jai jaihumtu...@gmail.com wrote:
Hello EveryBody
Can You tell me that , Mail Merge is possible in One Excel File to Another
Excel file , if it is possible then How?
--
Hi Dear,
You can do this with the help of record macro easily.
Please forward me your sheet i will try to help you.
Thanks regards,
Vikas verma
On Tue, Jul 5, 2011 at 2:58 PM, Rash rashmiv.ni...@gmail.com wrote:
Hi All,
I have excel file with 12000+ rows, and 10 column where i have used
I think Default Fill option will take minimum time then User Define Macro.
You can fill Down your Formula By Ctrl+D
On Tue, Jul 5, 2011 at 2:58 PM, Rash rashmiv.ni...@gmail.com wrote:
Hi All,
I have excel file with 12000+ rows, and 10 column where i have used Vlookup
and sumif function in
Hi All
I have excel file which I attached I am not able to create macro because
I need to print each test no each page manually taking more time please
I need any macro and any method easy which is I can print at a time
all test number per printout separate.
Appreciate your
Hello Ashsih,
COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
THANKS,
RAKESH.
--
--
Some important links for excel users:
1. Follow us on
try this
On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help icwai.answ...@gmail.com wrote:
Hello Ashsih,
COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
THANKS,
RAKESH.
--
Search the employee name in Colomn B and get the email id and should be
updated in Colomun C if any formula
or code pelase give it to me I need to do with 1000 records even though I
will match afterwords
single single
Note there wont be propper value or text u need to search with part of
emplyee
you simply a champ
On Tue, Jul 5, 2011 at 10:42 PM, ICWAI Help icwai.answ...@gmail.com wrote:
thank you so much ashish its wrking now
On Tue, Jul 5, 2011 at 9:50 PM, ashish koul koul.ash...@gmail.comwrote:
try this
On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help icwai.answ...@gmail.comwrote:
HI,
i think solved your quetions.
otherwise revert me.
Regards
Pravesh Kumar
On 7/5/11, ICWAI Help icwai.answ...@gmail.com wrote:
Search the employee name in Colomn B and get the email id and should be
updated in Colomun C if any formula
or code pelase give it to me I need to do with 1000
Hi Ankur
Thanks for the formula, but the values in the sheet 2 will change
daily and I have to keep the data in sheet 1 permanently. that is why
I am asking for code.if any idea pls tell me how can we do the same
thing with a code.
Regards
Rajesh Kainikkara
On 7/5/11, ankur
hi,
please find your solution this attachment.
Regards
Pravesh Kumar
On 7/5/11, ICWAI Help icwai.answ...@gmail.com wrote:
Hello Ashsih,
COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
THANKS,
RAKESH.
--
USE indirect function ti will help you
On Tue, Jul 5, 2011 at 2:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Try this*
* *
* *
*Sub CompileSheet()*
*Dim Sh As Worksheet*
*Sheets.Add.Name http://sheets.add.name/ = Compile*
*For Each Sh In ActiveWorkbook.Sheets*
*
Hi,
I want to compare Colum A , B anc C
for ex.
A BMOQ
21 1 - Select - A
1 2 10 - Select - MOQ
24 1 - Select - B
Basically I want to pick most best selling column for the three taps.
If some can help me out.
Regards
SATISH
--
its Not working getting the wrong emaild id s
Hi Ashish the formula which u have provieded its working somewht but out 10
geeitn the id for 2 employees id
Thanks,
On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
HI,
i think solved your quetions.
otherwise revert
HI,
APPLY THE MAX FORMULA AT A4 AND CLICK THE FILL HANDLE AND DRAG.
=MAX(A2:C2)
DOUBTS IF ANY CONTACT.
-R.KARUNANITHI
--- On Wed, 7/6/11, satish narbhaviwithsatishku...@gmail.com wrote:
From: satish narbhaviwithsatishku...@gmail.com
Subject: $$Excel-Macros$$ Help for Excel query
To: MS
Dear Experts
i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name,
Desination, Emp code .
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
I want a marco to find common values of column A and B in column C in the
attached file. Please Help.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Friends,
Any update on this?
Thanks,
AJ
On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain abhishek@gmail.comwrote:
Dear friends,
Attached along a data wherein in some rows, quantity and amount for items
nos are both positive which is my inventory.
In other rows one of the either or
HI jAI
do you want to send this form as attachment to emp ids mentioned in sheet 2
?
r u using lotus notes or outlook.
On Wed, Jul 6, 2011 at 10:45 AM, Jai jaihumtu...@gmail.com wrote:
Dear Experts
i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name,
Desination, Emp
48 matches
Mail list logo