Hi Satish
It would be really helpful of you if you could show the same in an excel
sheet required is that different duplicate sets should be identified by
different colors so that we can diffentiate them and find how many value are
duplicated...
Thanks a lot
Regards,
Vivek Agrawal
Skype ID -
hi Mr. Upendra
sorry for misspelling your name
i m really sorry for that
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jul 22, 2009 at 8:29 PM, Upendra
Singh wrote:
>
> Hi Ankur,
>
>
> This is what requir
Hi,
Right click on the merge field and do toggle fieldcodes and insert the
follow after the mergefield(as shown below) \#"00" u will not get any
decimal value
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Deep
Sen
hi mahesh
The requirement is still not clear...
can u please explain which values u want to compare and in what manner to
highlight
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Thu, Jul 23, 2009 at 9:20 AM, Mahesh wrote:
>
Hi Aman
Following is the code that performs your task now u can copy paste this
is the "personal" workbook and access the code while working with any other
application.
Sub save_file_on_time()
vYear = Year(Date) 'Current year
vMonth = Month(Date)
Hi All,
Need a solution here.
attached is the sheet contain data in Column B &C.
What i need is, if the data in both column are same then it will be
highlighted.
Example:-
1 12N0044 076E5920 2 12N0648 076E5920 3 12N0650 076E4039 4 12N0650
076E4039
--
With Love,
Mahesh Bisht
--~--~-
Hi Deep,
Do as Below :
1. In the word merged document, right click the merged field for which
you want to change the format.
2. Click "Toggle Field Code"
3. You will see something like { MERGEFIELD Dollar_Value} where
"Dollar_Value" is the merge Field.
4. Append \# #
Hello Everyone
Been following the group and have found many useful tips – so thank
you.
Wanted to know if anyone could help me –
I would like to create a button in Excel that saves the file
automatically with the following names in the d:\extractfiles folder
and closes the current window.
File
Hi JMR,
ow you do Control Find and data will be fetched from all Sheets.
hope this helps,
Kamal
On Wed, Jul 22, 2009 at 3:00 PM, JMR wrote:
>
> How can I configure Excel so that when I do a search it defaults to
> searching the whole workbook vs. just the sheet. It is a pain to have
> to
Hello,
I am in the process of creating some data entry forms in Excel through
visual basic. Basically I have one of the forms setup so that the
client can enter the information requested and it will automatically
be placed in a spreadsheet after clicking on a button.
I am able to allow the clie
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at htt
Hey,
I understand that you need to find out unique values, but it is very
necessary that you want to use countif ... coz this is a better way to
do it. Sort all values in column A and then use a simple if formula =IF
(A2=A3,"",1) ... to get unique values.
Please let me know if that does not serv
Hi Abhi,
Rather than paste special, you can try Insert->object command and insert
excel workbook as Object to your Presentation.
After inserting, resize object. I hope this will solve your problem.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
Vlookup Full Throttle :
1. We all know that Vlookup is very great formula to lookup a value and
pick the relevant matched value from other table.
But sometime we all have a situation where we have to pick more than one
column let's say 10 or 12.
We can do vlookup formula and then copy and pa
HI JMR
No need to do any configurations. Simply right-click any of the sheet and
select "select all". Now do a CTRL+F and you will find your search string
across all the work sheets.
--
Ashish
“If you enter this world knowing you are loved and you leave this world
knowing the same, then every
it is working i just checked.. try saving the file from the "FILES"
section of the group
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Thu, Jul 23, 2009 at 12:17 AM, kanwaljit Singh wrote:
> Hi Vivek,
>
> Where
Hello,
I come across a lot of situations where in I need to link data (A
range of
cells from Excel (2007 for Windows) or charts) into Powerpoint (2007
for
Windows) and then have them automatically updated as the information
chages
in Excel.
The problem which I always face is formatting. Once I
Hi Ankur,
This is what required.
And my name is not upender, its Upendra
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ankurcma
Sent: Wednesday, July 22, 2009 4:55 PM
T
copy pasting would not work as the cell referencing takes place... u will
need to edit the code according to the column and the row used.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 8:09 PM, Saurabh wr
this includes HD too
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 8:09 PM, Saurabh wrote:
> Exactly want the same.. Thanks..
>
> One more query...
>
> 1). I m not able to use the same formula if i copy
to get the count of "HD"/2, just edit the code accordingly and will get the
result... i hope u could figure out how the formula works
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 8:09 PM, Saurabh wrote
go the "FILES" section of the group ... try saving the file from there..
it should get saved... there is not question of not getting it...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 6:24 PM, Jayant
How can I configure Excel so that when I do a search it defaults to
searching the whole workbook vs. just the sheet. It is a pain to have
to make sure workbook is selected everytime I do a search. I have a
screen shot but do not see where to add it to this post.
--~--~-~--~~
To print a single Comment in cell:
1. Select a cell containing a Comment.
2. From the File menu, select Page Setup, and then click the Sheet
tab.
3. In the print area, insert the cell address.
4. From the Comments dropdown list, select At end of sheet and click
OK.
5. Click the Print icon
--~--~
Hi ,
Not able to open the link ... pls suggest
On 7/21/09, Vivek Agrawal wrote:
>
>
> Hello Excel Experts and Learners,
>
> I have uploaded a torrent file which contains N number of books
> related to Microsoft Office 2007. They are indeed very helpful. I have
> downloaded all of them and they
To delete empty rows between data:
1. Select all columns containing data.
2. Click the Sort icon (either Ascending or Descending).
--~--~-~--~~~---~--~~
--
Some important links for exc
Try this in C23:
=SUMPRODUCT(($C$2:$G$19="P")*($B$2:$B$19=B23))/SUMPRODUCT(($C$2:$G
$19<>"")*($B$2:$B$19=B23))
I wasn't too clear on what "non blank count of Team 1" should return,
so I took my best guess.
Angelo
On Jul 22, 6:49 am, "Saurabh" wrote:
> Hi All,
>
> I m having a trouble in attac
Thanks Vivek,
Just need more help.
Result wanted was count of P divided with count all.
Thanks,
Saurabh Patel
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of vivek agrawal
Sent: Wednesday, July 22, 2009 5:03 PM
To: excel-macros@googlegroups.c
HI GUYS
ANYONE PLEASE REPAIR THIS FILE .
THANKS IN ADVANCE
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins down
Aamir can u send me your file for working,
REHAN BAIG
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads a
i think upender singh formula is not working properly , i changed time
to 2:20 its is showing reference of time 2:30 , is it right?
On Jul 22, 3:23 pm, Dhananjay Pinjan wrote:
> Hi Friends,
>
> Hi Ruchi,
> Hope following formula helped to you.
>
> =VLOOKUP(B2,F:G,2,TRUE)
>
> I also append that f
Hi Anil,
Please use the following formula
=IF(COUNTIF($A$2:A2,A2)=1,"Unique","")
Regards,
Andy
On Wed, Jul 22, 2009 at 5:42 PM, anil panchal wrote:
> Hi Group,
>
>
> I want Unique name form countif
>
> Thanks & Regards
> Anil Kumar
> Executive - Database
> SOLUTIONS DIGITAS
> 3rd Floor, Cha
Hello Saurabh
Attached is the file with the proposed solution. Hope it helps
ALL THE BEST
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 4:19 PM, Saurabh wrote:
> Hi All,
>
> I m having a trouble in attached file.
Hello.
Use :
=SUMPRODUCT(($B$2:$B$19=$B23)*(D$2:D$19="p"))/SUMPRODUCT(($B$2:$B$19=$B23)*(
D$2:D$19<>""))
In cell D23 (have a look at the attached file).
Hope this helps.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Saurabh
Sent: me
Hi Group,
I want Unique name form countif
Thanks & Regards
Anil Kumar
Executive - Database
SOLUTIONS DIGITAS
3rd Floor, Chandra Bhawan, 67-68, Nehru Place | New Delhi - 110019 | India
Mobile: +(91) 9278256426 | Email: anilku...@solutions-intg.com
--~--~-~--~~~---~-
Hi All,
I m having a trouble in attached file. Want to have a Team Wise Count of
Status. Attaching the file for the reference.
Thanks,
Saurabh Patel
DISCLAIMER:The information contained in this electronic message and in any
attachments to this message is
confidential, legally
Hi Vivek,
Thanks for the solution, this is more than enough.
Rgds- Putta
On Wed, Jul 22, 2009 at 3:43 PM, vivek agrawal wrote:
> hi
> Attached is the solution.. Hope it is what was required.
>
>
> Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com - Saving energy-Sav
THANK U
On 7/22/09, Aindril De wrote:
>
> Hi Amresh,
>
> You can download one fromj the link below:
>
> http://www.geocities.com/accessreddy/excel/emi.htm
>
> Regards,
> Andy
>
>
> On Wed, Jul 22, 2009 at 3:43 PM, amresh kumar
> wrote:
>
>> Hi Friends,
>> If U Have EMI CALCULATOR IN EXCEL PLEAS
Here is the same in 2003 format
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 3:48 PM, Pranaya Pradhan
wrote:
> Hi Vivek
>
> Could u send it in excel 2003 format.
> plsss
>
>
> On 7/22/09, vivek agrawal w
Hi Amresh,
You can download one fromj the link below:
http://www.geocities.com/accessreddy/excel/emi.htm
Regards,
Andy
On Wed, Jul 22, 2009 at 3:43 PM, amresh kumar wrote:
> Hi Friends,
> If U Have EMI CALCULATOR IN EXCEL PLEASE SEND ME URGENT
>
> Regards
> Amresh
>
> >
>
--~--~-~--~-
Hi Friends,
Hi Ruchi,
Hope following formula helped to you.
=VLOOKUP(B2,F:G,2,TRUE)
I also append that formula in your Excel File. So, please opened attached
(by me) file for result.
Thanks & Regards,
Dhananjay Pinjan
(Mob. No. 9922255533)
On 7/22/09, Ruchi Saxena wrote:
>
> Thanks Upendr
Hi Vivek
Could u send it in excel 2003 format.
plsss
On 7/22/09, vivek agrawal wrote:
>
> Hi Amresh
>
> Here is one which i have created... Hope you'll understand the working...
> if not.. do write back
>
> All The Best
>
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
>
open excel then press Alt+F11.
then choose module from insert menu.
then paste all code wat i have noted u in the page.
then save the visual basic editor and close
the the function is =value(1234) (for the number directly)
or value(D4) (for any cell 's value.
U r welcome
On 7/21/09, Nandkumar
Hi Amresh
Here is one which i have created... Hope you'll understand the working... if
not.. do write back
All The Best
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 2:13 PM, amresh kumar wrote:
> Hi Frie
Hi All,
I want the Month name and year to be displayed next to the date as given in
the attachment.
With Regards,
Putta Madaiah
Bangalore
--~--~-~--~~~---~--~~
--
Some important links
thank u sir
i got the link ,i m downloading the books
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jul 22, 2009 at 3:13 PM, vivek agrawal wrote:
> I did not track the site from where i downloaded it
> i
Hi Friends,
If U Have EMI CALCULATOR IN EXCEL PLEASE SEND ME URGENT
Regards
Amresh
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Te
I did not track the site from where i downloaded iti cant figure out why
it is not getting saved
Well you can do one more thing.. go the "FILES" section of the group ... try
saving the file from there.. it should get saved... there is not
question of not getting it...
the text which u
Hi Ankur,
Right click on the link and click "Save Target/Link as". This would download
the torrent file which would download the ebooks.
Do write in case u face problems.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Ju
sir this link is not working properly, can u guide me how to download the file
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jul 22, 2009 at 10:48 AM, Vivek
Agrawal wrote:
>
> Hello Excel Experts and Learners,
Hi
I thought converting to numbers to text using formulas much better
than using macros because if you use macros:
1) You will need to enable macros
2) If you use an add-in, that formula doesn't work when you copy that
file to another computer where the add-in is not installed
I have prepared a
Dear Haarish,
First of all, the global variable must reside in an independent
module, where it can be accessed by the user form. Secondly, the
control can be transferred only if the worksheet activate event
resides in either the worksheet code module or an independant class
module that has been i
Thanks Upendra,
This formula has worked
Regards,
Ruchi
-- Forwarded message --
From: Upendra Singh
Date: Wed, Jul 22, 2009 at 7:46 AM
Subject: $$Excel-Macros$$ Re: Hii
To: excel-macros@googlegroups.com
Hi Ruchi,
Enter the below formula in the cell C2
=VLOOKUP(TIME(HOUR
53 matches
Mail list logo
