Hi,
I wrote this formula for ur purpose.
=IF(RANK($A2,$A2:$D2,1)=F$1,$A$1,IF(RANK($B2,$A2:$D2,1)=F$1,$B$1,IF(RANK($C2,$A2:$D2,1)=F$1,$C$1,$D$1)))
See the attached sheet for reference.
Let me know if this helps.
On Sat, May 9, 2009 at 8:53 PM, subs subbu1...@gmail.com wrote:
ca1 ca2 ca3
Just try =A1B1 in C1.
On Tue, May 12, 2009 at 1:27 PM, jamadagnira...@gmail.com wrote:
Hello,
I have a problem in displaying AM or PM, when i try to concatenate to
cells. Below is the reference -
Column A Column B Column C
4/16/2009 9:00 AM CDT
Hi,
From your mail box, send message with attachments to
excel-macros@googlegroups.com
This way you can send your files.
Regarding using only one macro:
Turn the *Sub macro1 ... END Sub*
in your macros to *Function macro1 END Function*
Write a separate macro as
*Sub callingall3*
*'call
Hi Sharat,
Thanks for the code. I was able to run it to get the sheet unprotected.
What should I do to break VBA password.
If I run the button2_click only the sheet's passowrd is broken. But VBA is
still passowrd protected.
Can you please guide me.
Thanks in Advance!!
On Sat, Dec 19, 2009 at
*Hi,*
*Please go through the below article. It will help you on how to unprotect
only few cells using three different ways.
*
*Let me know if you find any issues.*
*Regards,*
*Excel King*
The easiest and most common way of barring people from playing with your
formulas is to protect your
Hi Vinod,
I was expecting the same output as Harmeet does.
Can you send us an example file with the problem and the output you require
in case the above doesnt help you.
On Wed, Dec 23, 2009 at 8:27 AM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi Vinod,
Attaching a sample file.
If this
Hi Karthik,
What is the data that you want to copy and into which shet you want to copy.
On Wed, Dec 23, 2009 at 12:07 PM, grlinks-karthik grli...@gmail.com wrote:
Hi
any can help me , I need to copy the data from report2.xls to paybill.xls
sheet , How to do with VBA, Could any help , ITs
Hi Vinod,
Can you try using vbnewline in .htmlbody directly instead of using it in
strbody?
On Wed, Dec 23, 2009 at 10:29 PM, Vinod N nvino...@gmail.com wrote:
Hi Excel Gurus,
In the attached file, the following string is not working
strbody = Please clarify the following: vbNewLine
Do You want to Use specific VBA coding or else You can use this formula from
Dilip directly like this in VBA:
Activecell.formula = =IF(AND(A2=abcdCust,LEN(B2)=
6),0B2,IF(AND(A2=xyzzCust,LEN(B2)=8),LEFT(B2,4)-RIGHT(B2,4),))
On Thu, Dec 24, 2009 at 12:44 AM, mike mwillia...@socal.rr.com wrote:
)
Signature
or
.HTMLBody = strbody vbNewLine RangetoHTML(rng) Signature
If not, please make the necessary changes in macro in the attachment...
Thanks in advance
Vinod N
On Thu, Dec 24, 2009 at 10:53 AM, kvc praveen kumar
pkkara...@gmail.comwrote:
Hi Vinod,
Can you try using vbnewline
need code for that, these are sample sheets, based on your code i need to
my modification , Please do the needful ASAP
Regards
grlinks
On Wed, Dec 23, 2009 at 11:30 PM, kvc praveen kumar
pkkara...@gmail.comwrote:
Hi Karthik,
What is the data that you want to copy and into which shet you
You are Welcome Mahesh!!
On Thu, Dec 24, 2009 at 8:27 PM, mahesh parab mahes...@gmail.com wrote:
Hi Praveen
Thank you so much ! it's amazing , i appreciate your knowledge help.
On Thu, Dec 24, 2009 at 11:19 AM, kvc praveen kumar pkkara...@gmail.com
wrote:
Hi Mahesh,
Use
You are welcome Karthik!!
On Fri, Dec 25, 2009 at 10:24 AM, grlinks-karthik grli...@gmail.com wrote:
Thank you praveen,
On Thu, Dec 24, 2009 at 11:19 PM, kvc praveen kumar
pkkara...@gmail.comwrote:
Hi Grlinks,
Attach this macro for Report(2) sheet and run the macro3. You should
, actuallay it will be 50 or 100 rows
kindly help me
On Thu, Dec 24, 2009 at 11:19 PM, kvc praveen kumar
pkkara...@gmail.comwrote:
Hi Grlinks,
Attach this macro for Report(2) sheet and run the macro3. You should be
able to see the desired result.
Make sure you open both the files before
No Problem Karthik!!
On Fri, Dec 25, 2009 at 3:35 PM, grlinks-karthik grli...@gmail.com wrote:
Thank you praveen
its working fine, you done greate help for me , thanks once again
On Fri, Dec 25, 2009 at 11:02 AM, kvc praveen kumar pkkara...@gmail.com
wrote:
I made a small change
Hi Rafique,
You need not worry about the autonumbers. Just keep filling your names,
After you are done select cells containing 1,2 in S# column and then double
click the fill handle. Excel will automatically genearate the sequence for
you.
Let me know if this helps!!
Regards,
Praveen KVC
On
Hi Abdul
Follow these steps:
Select your column first and then click on Data-DataValidation
Choose Custom from the drop down menu.
Enter the formula as *=IF(COUNTIF(E:E,E1)1,FALSE,TRUE)*
(I chose Column E)
This will restrict all duplicate values in your column
Let me know if this helps!!
Hi,
You can try the following code:
I wrote two macros: Mergecontents and move contents.
Mergecontents will merge teh contents into the d column of your last row of
the email pattern
movecontents can be used to move the result to the first row of your email
pattern
Execute the mergecontents
Hi Tushar,
If you do not want to select the sheet to implement your code try to prefix
the cells also with the worksheet reference like this:
Worksheets(sheet1).Cells(3, 25)
This should fix the issue probably..
Let me know if this helps!!
Regards,
Praveen
On Sun, Dec 27, 2009 at 11:39 AM,
Hi Ashish,
I have not gone thru ur issue completely. But i thought this could help you.
Did you try inserting this statement
ON ERROR RESUME NEXT in the sub procedure defintion like this:
*Sub Macro7()
On Error Resume Next*
I guess this would be sufficient.
Regards,
Praveen
On Tue, Dec 29,
Hi Doki,
Please check the attached workbook and let me know if this is what you were
expecting.
Please run macro1
Regards,
Praveen
On Mon, Jan 4, 2010 at 9:38 AM, Doki dok...@gmail.com wrote:
Im stuck with one problem..I guess togather we can solve it..
Prob is:
I want a Dropdown (may be
Hi Sajid,
As per my knowledge Countif doesnt work in 3 dimensions.
As an alternative you can try this:
*List the sheet names in H1:H5*
and then write this formula
*=SUMPRODUCT(COUNTIF(INDIRECT('H1:H5'!A1),97%))*
This will work. let me know if you have any queries.
Regards,
Praveen
On Wed, Jan
, kvc praveen kumar pkkara...@gmail.comwrote:
Hello Anish,
Please check the attached file and let me know if this is what you were
looking for.
run the macro testmulti()
You should get a true for all multibyte character strings
Regards,
Praveen
On Wed, Jan 6, 2010 at 3:57 PM, Anish
Thanks Dave!!
Just Thought Ascii values would do the trick and it worked well.
On Thu, Jan 7, 2010 at 3:23 PM, Dave Bonallack davebonall...@hotmail.comwrote:
Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty
silly when this is a macro group!
Regards - Dave.
Hello Allen,
I guess the excel from which you are getting thadates from is in 1904 date
system. and yours is in 1900 date system. All you need to do is to uncheck
the use 1904 data system in your source excel - excel options.
This is my first thought. let me know if it helps.
On Wed, Jan 13,
at 11:44 AM, kvc praveen kumar pkkara...@gmail.com
wrote:
Hello Allen,
I guess the excel from which you are getting thadates from is in 1904 date
system. and yours is in 1900 date system. All you need to do is to uncheck
the use 1904 data system in your source excel - excel options
Thanks Vinod.. Glad that it was helpful!!
On Thu, Jan 14, 2010 at 5:51 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Praveen,
Excellent!!! this was really great.
With Regards,
Vin
On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar
pkkara...@gmail.comwrote:
Hello Vinod,
PFA
sheet and the third sheet.. (sorry the idea
coming up as I think through).. but I will try it myself.. after
studying your code.
Thanks again..
Have a nice day!!!
On Jan 17, 6:17 pm, kvc praveen kumar pkkara...@gmail.com wrote:
Hello Mark,
Please find attached the result sheet
Hello dailey,
Can you share a sample workbook with your exact requirement. I went through
your code.. But was unable to get what exactly you are looking for. If you
share a workbook and explain the result you want..probably it would be easy
for this group members to respond.
Thank you!!
Hi Abhishek,
Did you try giving the complete path to the cell references directly?
like ='C:\DOCUME~1\PKARAN~1\LOCALS~1\Temp\notes327EC1\[Training
curriculum.xls]Sheet3'!$A$82
You can give the complete pathto the location of your masterfile directly.
Let me know if this works.
Regards,
Praveen
HI Ganesh,
I observed in the sheet that you have written the concatenate spelling wrong
for the function.
I hope that was the reason for #Name error. You can correct and check once.
Regards,
Praveen
On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw ganesh200...@gmail.com wrote:
hi guys,
i want to
Hello Mahesh,
Attached is the shhet with your requirement.
I used
=SUMPRODUCT(COUNTIFS(INDIRECT('D8'!E:E),$E$7,INDIRECT('D8'!C:C),C8))
to implement your reqmnt.
Let me know if you have any issues.
Regards,
Praveen
On Wed, Jan 20, 2010 at 10:59 AM, mahesh parab mahes...@gmail.com wrote:
Dear
You are welcome Mahesh!!
Have a nice day!!
Regards,
Praveen
On Thu, Jan 21, 2010 at 9:03 AM, mahesh parab mahes...@gmail.com wrote:
Hi Praveen,Ankur,Dave
thank you all of you !
On 1/20/10, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Have a look at the attached. Let me know if
Hello All,
I came to know yesterday that Excel 2003 has limitation to chart more than
32000 rows/data points.
However, this could be overcome with the creation of two separate
dataseries. I want to know if it is possibleto create an add-in for
implementing the same.
If it is possible, Can
Hi Wibur,
In Excel 2007 go to Excel options - Advanced - uncheck the After Pressing
enter move Selection.
This would suffice.
Regards,
Praveen
On Tue, Jan 26, 2010 at 5:08 AM, Wilbur Kush ocwil...@gmail.com wrote:
I have a scale that inputs data into excel via rskey, a keyboard
emulator
Check the attached file.
Praveen
On Fri, Feb 5, 2010 at 11:27 AM, ashish koul koul.ash...@gmail.com wrote:
any help
On Thu, Feb 4, 2010 at 8:46 PM, ashish koul koul.ash...@gmail.com wrote:
hi
i have a input in sheet 1 and its not limited
and want result in sheet2 like in col1
36 matches
Mail list logo