Have not seen the workbook but you can modify the formula as below to
extract everything after "_POV_"
=MID(A1,FIND("_POV_",A1)+5,Len(A1)-FIND("_POV_",A1)+5)
Thanks,
Upendra Singh
+91-9910227325
On Thu, May 5, 2016 at 11:43 AM, Abhishek Jain
wrote:
> In all but
m not able to figure the way to calculate
this. The file contains almost 1 entries.
Please let me know the ways by which this can be achieved using VBA.
Thanks,
Upendra Singh
--
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 Fac
Hi Ajay,
After selecting the cells containing hyperlinks, go to vb editor by pressing
alt+f11. Then press ctrl+g and type selection.hyperlinks.delete
Press Enter and you are done...
Sent from my iPhone
On 27-Oct-2012, at 8:56 PM, ajay prasad wrote:
> DEAR All,
> please help me to remove hyper
Hi, i am upendra singh, from delhi, works for an online advertising company. I
love excel and loves to learn new tweeks and tricks.
Sent from my iPhone
On 10-Jun-2012, at 1:46 PM, Maries wrote:
> Hi all,
>
> Name : Marieswaran
>
> Age : 25
>
> Current City : Duba
Hi Noorain,
Please use below formula:
=VLOOKUP(A7,INDIRECT("'"&TEXT(B7,"dd-mmm")&"'"&"!A:B"),2,0)
Regards
Upendra Singh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN A
Hi Ayush,
This doesn't help. I've got the correct code:
"Select Distinct [Market] from [Sheet1$A1:D5000]"
or
"SELECT DISTINCT [Column Heading] FROM TableName ORDER BY [ColumnHeading];",
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´99
***
Do somebody have idea how to query excel file if i need distinct value from
a particular column.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
--
--
Some important links for exc
Hi Vebhav,
Nothing is wrong in below code but if you want to select 3rd row from
current row, you should add one line to below code:
Row(Z).select.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 20 December 2010 13:27, vebhav jain wrote:
> Hi
Hi
Im ahmed saber. these days i bought 3 iphone 4G from a website :
www.ebay365.org and i get the very great price and quality products
from them . i want to introduce it to you . when you went their
website and tell them my name ahmed saber . you will get a very great
discount . the website is ww
Hi Sumit,
Kindly mail me the PDF u've downloaded.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 9 November 2010 15:22, sumit kumar wrote:
> Hey
>
> There is no password, I opened it without password.
>
>
> Regards
> Sum
Hi Ayush,
What is the password to opent the file.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 8 November 2010 19:35, Ayush wrote:
> Dear Group Members,
>
> Good news for all of you !!
>
> Now you can download VBA macros ebook wor
power means power function...
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 22 September 2010 18:15, Upendra Singh Sengar <
upendrasinghsen...@gmail.com> wrote:
> Mathmatically if a raise to power b is c
> then
> a=C raise to power 1/B
Mathmatically if a raise to power b is c
then
a=C raise to power 1/B
b=C raise to power 1/A
but power is not working is excel properly...
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 22 September 2010 17:55, Ayush wrote:
>
> Dear Group,
>
Hi Himadri,
You should multiply new client with customer per client.
Thanks and Regards,
Upendra Singh
+91-9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Himadri Roy
Sent: Monday, October 19, 2009 9:50 PM
To: excel-macros
u Buy.
Arranged Marriage: Product is sold on an as is where is basis. Product once
sold will not be taken back!
Thanks and Regards,
Upendra Singh
+91-9910227325
--~--~-~--~~~---~--~~
--
Hi Aliahk,
This error comes when you copy non-contiguous cell and try to paste them on
non-contiguous cells.
After copying, remove filter and then paste or copy and paste on a different
sheet.
Let me know if this helps.
Thanks and Regards,
Upendra Singh
+91-9910227325
This will hyperlink all the cell from A1 to M500
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of nader
Sent: Friday, October 09, 2009 7:54 PM
To: MS EXCEL AND VBA MACROS
Subjec
speak of it in polite
conversation. Do not confuse the DATEDIF worksheet function with the DateDiff
VBA function.
Thanks and Regards,
Upendra Singh
+91-9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: Friday
Upendra Singh would like to recall the message, "$$Excel-Macros$$ Re:
Subtract dates".
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutor
Hi Paul,
Nopes. I will not format that cell/column as dd-mm-yy. It should be
formatted as number.
I never used Datediff and so was unaware that it is VBA only function but
now I know.
Thanks,
Upendra Singh
+91-9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac
Mail
Grand Total
555-
1
1
1
1
4
555-
1
1
1
3
Grand Total
1
2
2
1
1
7
Now replace 1 with Yes..
Let me know if it helps...
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros
Wkbk.Name = Filename Then
MsgBox (Filename & " is open; changes may result in errors.")
End If
Next Wkbk
End Sub
Thanks and Regards,
Upendra Singh
+91-9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of hanuma
Hi Huzaifa,
This is very much possible to subtract dates. Simply subtract as you
subtract no.s and format the cell as "yy-mm-dd".
This works fine provided you are subtracting dates and not text written as
date.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message
Hi Rohith,
Use the subtotal function as below:
If you want total for column and your column has 500 rows, write formula in
row 510 =subtotal(c1:c500,9).
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac
Hi c,
Before running macro, go to Tools->Sort and sort your data col A-Ascending,
Col G-Ascending, Col H-Ascending, Col K - Descending.
Let me know if this helps.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.
d to
your workbook after ActiveSheet.
ThisWorkbook.Sheets.Add ,After:=ActiveSheet,count:=15
Thanks and Regards,
Upendra Singh
+91-9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of sumanth kumar
Sent: Thursday, October 01, 2009 3:21 PM
Hi Kuhrty,
You have to set the value of dbs (database) first to continue
Let me know if this helps.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of kuhrty
Sent: Thursday
com/downloads/details.aspx?familyid=d9ae78d9-9dc6-4b38
-9fa6-2c745a175aed&displaylang=en> &displaylang=en
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Jac
the format of date equivalent to your
existing date format. As for your example, you should select Date->DMY and
click finish.
See you've done. Change the format of entire selection to dd-mmm- and
verify your result.
Thanks and Regards,
Upendra Singh
+91-9910227325
Below are the formulas to achieve this in excel:
Decimal
Degree
Minute
Seconds
9.73877
=INT(A2)
=INT((A2-INT(A2))*60)
=(((A2-INT(A2))*60)-INT((A2-INT(A2))*60))*60
Thanks and Regards,
Upendra Singh
+91-9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac.
Hi Sudhir,
You can open DBF files directly in Excel 2007 or you can use save as dialog
box to save a file as .dbf.
Just use the filetype in the save as dialog box.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel
Copy and paste values in the required column.
I just leave it so that you can understand the implementation.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are
Hi Iqbal,
You need password to RAR file or password remover for RAR files….
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those
Hi Manoj,
See the attached file...
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those who
don
Most one knows..(Joke.)
Simply go to Insert->Name->Define.
Select the given name and click "delete" ( if you are using excel 2003)
OR
Go to Formulas->Name Manager.
Select the given name and click "delete" (if you are using excel 2007)
Regards,
Upend
cell where you have the total time in minutes. Do not forget
the last , in the formula.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people
Hi osiso,
You need to nest match function inside your vlookup.
Send me the excel file with sample data and I'll show you how
Regards,
Upendra Singh
+91-9910227325, +91-93107
Hi Vivek,
Send me the macro as text file as my outlook had blocked "Potential unsafe
attachment .bas" please.
Regards,
Upendra Singh
+91-9910227325, +91-
Hi Vinod,
Please download from below Link..
MSPress_Step_By_Step_MS_Office_Access_2003_EBook.pdf
<http://rapidshare.com/files/248961528/MSPress_Step_By_Step_MS_Office_Access
_2003_EBook.pdf>
Regards,
Upendra Singh
+91-9910227325, +91-9310
Hi Harris,
Use the below formula in cell F20.
=INDEX($C$6:$O$11,MATCH($D20,$C$6:$C$11,0),MATCH($E20,$C$6:$O$6,0))
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi Harris,
Use the below formula in cell F20.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those
Hi Sunil,
You can link your worksheet with MS-Access and then write Queries rather
than importing data from Excel to Access.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi Martin,
You could try selecting only visible cells by pressing F5->Special->Visible
Cells Only.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 ki
Hi Anil,
Select entire sheet and then go to format->Columns->Width and enter 8 and
press Enter. You will see all columns. Columns are not hidden but their
width have made to be 0.
Regards,
Upendra Singh
+91-9910227325, +91-9310
,
Upendra Singh
+91-9910227325, +91-9310760597
On 7/24/09, Dinsdale wrote:
>
> I would like to apologize if this has been answered in another thread,
> but I could not find it in the searches I was doing. Maybe I was
> searching the wrong thing...
>
> I am a software developer
Use Index-Match
=INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1))
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people
Right click on sheet tab and select Ungroup.
You've grouped your sheets...
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Thos
eld.
4. Append \# #,##0.
5. Right Click and Click Update field and You've done.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of peo
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-9310760
27;S
heet1'!$A$1:$N$1,0)).
If you have any problem understanding or implementing Index-Match, Send me a
sample Sheet and I will explain with example.
Both the formulas works if the column heading in both the sheets are same.
Regards,
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
Hi Ruchi,
Enter the below formula in the cell C2
=VLOOKUP(TIME(HOUR(B2),CEILING(MINUTE(B2),15),0),$F$2:$G$99,2,0).
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ruchi Saxena
Sent
.),BCA
>>>>> Mobile: +91 9810929744
>>>>> dilipan...@gmail.com
>>>>> dilipan...@yahoo.com
>>>>> New Delhi - 110062
>>>>>
>>>>> On Wed, Jul 15, 2009 at 9:04 AM, Mahesh wrote:
>>>>>
>>>>
ws you need.
ActiveCell.Offset(1, 0).Activate
Loop
End Sub
_______
Regards,
Upen
Hi Prashant,
Go to Data->Pivot Table and Pivot Chart.
Then select the third option : Multiple Consolidation Ranges.
This will help if your data have exactly Same no and Name of columns.
Regards,
Upendra Singh
+91-9910227325, +91-9310760
Hi Sachin,
You have entered date which seems as date but actually are strings. You have
to write dated in the format mm/dd/yy. So your date should be 03/31/09, not
31-03-09.
This will solve your problem
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Thanks Ayush.
Indeed Singh is king
I have contributed very less to this group but learned a lot.
I will continue searching new tips and share with group.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
You can use paste Special-> values in you macro
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those who
do
.
The formula will return the number of corresponding cells that are
different. If the formula returns 0, it means that the two ranges are
identical.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
la, so input it with Ctrl-Shift-Enter) is more complex, but it will
handle a range that contains a blank cell.
=SUM(IF(COUNTIF(A1:D100,A1:D100)=0, "", 1/COUNTIF(A1:D100,A1:D100)))
Regards,
Upendra Singh
+91-9
the cities from that country.
Remember that Defined Names can't include spaces, so, to enter, Great
Britain, you would have to put it like "Great_Britain" or "GreatBr
Hi Amresh,
Use ~ before * i.e. you have to search ~*
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary
splayed in
you sheet.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who unders
Hi All,
Any Help. Please ..
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those who
don
My Contribution for This Week Tip is Below :
Understanding Relative and Absolute References...
Excel accepts cell references in what are called absolute and relative
ranges. Absolute ranges have a $ character before the column portion
of the reference and/or the row portion of the reference. Rel
WOOH.
Thanks Ayush.
Cheers
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those who
don
t3 will be activated.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary
or I'm missing any
library.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary
Hi Lohit,
Download below file from Rapishare.com
http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe
rence.pdf
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi Debashis,
Download below file from Rapishare.com
http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe
rence.pdf
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi Mahesh,
Check this if it works...
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those who
Asad/Surendra,
MS-Access Book for your reference.
MS_Office_Access_2003_EBook.pdf
<http://rapidshare.com/files/248961528/MSPress_Step_By_Step_MS_Office_Access
_2003_EBook.pdf>
Regards,
Upendra Singh
+91-9910227325, +91-9310
Hi Mahender,
If you have ASAP Utilities, You can go to ASAP Utilities->Columns->6.Insert
Between Empty Row and Column.
ASAP Utilities will ask you for Row or column to insert and no. of Row or
Column to Insert.
Regards,
Upendra Singh
+91-9910227325, +91-9310
Hi Ankur,
I've uploaded one VBA file on Rapidshare.com. Below is the link to download.
http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe
rence.pdf
Regards,
Upendra Singh
+91-9910227325, +91-93107
Hi Terrance,
You can do this without macro.
1. Create copy of Pivot Edit->Move or Copy Sheet.
2. Remove Subtotal and do Pivot Table Copy-> Paste Special-> Values.
3. Apply Advance Filter and Filter the Data.
Regards,
Upendra Singh
+91-9910227325, +91-9
the merge Field.
4. Append \# #,##0.00.
5. Right Click and Click Update field and You've done.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are
Hi Dharmendra,
You can use built in MRound Function in Excel.
If Cell A1 have value of 2723, MRound(A1,100) Would give you 2700.
Regards,
Upendra Singh
9910227325
-
There are 10
the copied data in "find what" Box.
5. In the replace box, type a single ",".
6. Press Replace all and copy the whole data back to excel.
If you are using Excel 2003, you can do this in 5 Iterations.
Regards,
Upen
the copied data in "find what" Box.
5. In the replace box, type a single ",".
6. Press Replace all and copy the whole data back to excel.
If you are using Excel 2003, you can do this in 5 Iterations.
Regards,
Upen
Hi Zaki,
ASAP utility is absolutely free. You need to purchase license only if you
need it for commercial purpose.
Regards,
Upendra Singh
9910227325
-
There are 10
Name : Upendra Singh
Tip : Left Lookup
One of the Limitation of both the VLOOKUP and HLOOKUP functions is that you
can only lookup a value to the right of the key value. For example, in the
range shown Below, you can retrieve the value "c" by using VLOOKUP to search
for a 3. Ho
Name: Upendra Singh
Tip: color Every Alternate Row in data with conditional Formatting (without
Macro)
1. Select the data you want to Format.
2. Go to Conditional Formatting.
3. In the first box, Select “Formula is” and type the formula :
=MOD(ROW()-1,1*2)+1>1.
7;ve done.
Merged
Party Name
Bill No.
Amount
=B2&C2
abc
123
500
=B3&C3
abc
456
590
=B4&C4
bcd
234
434
=B5&C5
bvd
544
3453
Regards,
Hi Vinay,
Please find enclosed sample xl Sheet. Please note that in the cell A1, I’ve
written my name but that is visible only in formula bar, not in Excel Sheet.
I Hope it helps….
Regards,
Upendra Singh
9910227325
Hi Friends,
Name : Upendra Singh
TIP : Hide Data in Cell or Worksheet from praying Eyes
ðSelect the range you want to hide.
ðGo To Format=>Number=>Custom
ðIn the type Box, type three colon (;;;) and press enter.
ðThe data where the above formatting is a
Name : Upendra Singh
Subject : Selecting More than one Value in a single Page field for Pivot Table
Tip : There are sometime situation where we need to select more than one
Value form a given Page field in Excel Pivot Table. In Excel 2003, we can
either select “All” or one Value from a
Hi,
This code is not running. Does this requires any reference library to be
included except default..
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ddadmin2009
Sent: Tuesday, May 26, 2009 11:47 AM
To
Thanks
>
>
>
>A B C D
> ------
>
> 10 A 1 =A1
>
> >
>
--
Sent from my mobile device
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`
Hi Satish,
I think you have not installed .Net Framework 3.5 and VSTO 3.0 Runtime.
I have installed these Pre-requisites and my installation completes.
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of
Hi Prashanth,
Write the below query and let me know if it is working:
Update Test1
Set Test1.Month = Month.Month
Where Test1.Weekno. = Month.Weekno
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of
setup."
Please suggest what to do...
Regards,
Upendra Singh
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ashish Jain
Sent: Tuesday, April 28, 2009 6:32 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Open X
Hi Niraj,
Please check the attached file...
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of NIRAJ KOTHARI
Sent: Saturday, April 25, 2009 12:27 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
or BCC field
(" & errcount & " errors detected.)", vbOKOnly) = vbOK
End If
End Sub
________
__
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [ma
93 matches
Mail list logo