Hi Guys,
thanks a lot for your help.
regards,
Pawel
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Thursday, October 4, 2012 6:32 PM
Subject: FW: $$Excel-Macros$$ macro: delete base on table
Here is thread on this Solution , Please visit
Dear All,
I need to clean all special characters from a my data. Please suggest any
formula or macro to remove them.
Please find attached sheet.
Thanks
Karan Singh
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED f
Hi,
You can try pivot table. see below Snapshot.
Name Date ID Name1 01-10-2012 9558 02-10-2012 9565 03-10-2012 9564
04-10-2012 9563 05-10-2012 9562 06-10-2012 9561 07-10-2012 9559 Name2
01-10-2012 9559 02-10-2012 9558 03-10-2012 9565 04-10-2012 9564
05-10-2012 9563 06-10-2012 9562 0
Hello Asish,
Thanks its working. :)
On Thu, Oct 4, 2012 at 4:51 PM, ashish koul wrote:
> IF(ISERROR(B2-A2),"",B2-A2)
>
> format as [mm]
>
>
> On Thu, Oct 4, 2012 at 6:51 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> Could you please let me know how to ignore erro
Dear Viper,
Please can you solve it without erry..please help..
On Fri, Oct 5, 2012 at 11:47 AM, The Viper wrote:
> pfa
>
>
> On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar
> wrote:
>
>> Dear Expert,
>>
>>
>> Request you to kindly help me on this matter...
>> Please find the attachment..
>>
>>
pfa
On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar wrote:
> Dear Expert,
>
>
> Request you to kindly help me on this matter...
> Please find the attachment..
>
> I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show
> 9564
>
>
>
>
> Regard
> Manoj
>
> --
> Join official facebook
Dear Group,
I require the Macro in Add-in form which convert the full amount into the
million e.g. if I want to convert the figure 1,000,000 to million it will
show as 1.000.
Procedure should 1,000,000 enter as "1,000,000mm" it automatically convert
the figure as 1.000.
Regards,
Aamir Shahzad
-
Hello
My name is Radek Jurecek, I'm from Czech Republic.
I work as IT programmer (ASP.NET, C#).
I developing own a add-ins (Czech language).
One of the add-ins I try translate to English. See
http://rjurecek.cz/rjtoolsEn.htm
--
Join official facebook page of this forum @
https://www.facebo
Dear Expert,
Request you to kindly help me on this matter...
Please find the attachment..
I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show
9564
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ me
Array Formula
=IFERROR(SMALL(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g)&":"&MAX(g))),g,0)),ROW(INDIRECT(MIN(g)&":"&MAX(g))),""),ROW(INDIRECT("1:"&COUNT(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g)&":"&MAX(g))),g,0)),ROW(INDIRECT(MIN(g)&":"&MAX(g))),""),"")
g is your list name.
Rajan
On Thursday, 4 Octobe
Hello Ashsh,
I posted my query and dont see it
Did it get through.
Rashid
On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote:
> I posted this yesterday...it seems it did not get through..so posting once
> again
>
> Hello All,
>
> I am using Excel 2010. I have a List of Names in Sheet n
Here is thread on this Solution , Please visit
http://www.excelfox.com/forum/f20/delete-list-contain-matching-second-list-5
89/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 04 October 2012 9:58
To: 'excel-macros@goo
why don't u sort data after all the information is imported to sheet on the
basis of column having create date
On Thu, Oct 4, 2012 at 10:06 PM, Best Of Luck wrote:
> Prince Dubey ,
>
> Thanks for the last code update it works great. I have one other problem
> how can I modify this code where
>
Prince Dubey ,
Thanks for the last code update it works great. I have one other problem
how can I modify this code where
Range("I" & i) = f.Name is soreted so that the oldest file is displayed on
top?
thnaks in advance.
On Thursday, September 27, 2012 10:52:04 PM UTC-5, Prince Dubey wrote
Hi,
Use this Code, Just Create Two Name Ranges,
Sheet1!B2="rngRange"
Sheet2!B2 =" MapDelete"
Sub ExcludeFromList()
Dim objDicMap As Object
Dim VarArrData
Dim VarArrResult
Dim rngCell As Range
Dim lngCOunt As Long
VarArrData = Intersect
BAN
On Thu, Oct 4, 2012 at 9:51 PM, Paul Schreiner wrote:
> You probably mean "BAN"
>
> Definitions:
>
> Bane: "A source of harm or ruin"
>
> Ban: "To prohibit (especially by legal means)"
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means
You probably mean "BAN"
Definitions:
Bane: "A source of harm or ruin"
Ban: "To prohibit (especially by legal means)"
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
Sub sample_code()
Application.ScreenUpdating = False
Dim a As Range
Dim SrchRnga As Range
Dim i As Long
Set SrchRnga = Sheets(1).Range("b1: b" &
Sheets(1).Range("b65356").End(xlUp).Row)
For i = 3 To Sheets("table").Range("b65356").End(xlUp).Row
Do
Set a = SrchRnga.Find(Sheets("table").Range("b"
Hi Karthik,
Pls see the attachment.
regards
Prince.
On Thursday, October 4, 2012 7:14:56 PM UTC+5:30, karthik n wrote:
>
> Hi Team,
>
> Please help in the attachment file
>
> Regards
> karthik.N
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORU
Hi All,
I'd like to ask you for favour, can you help me with these. I have a table
"code" with codes. From this table I'd like to excclude all codes for table "to
delete" (tab table). Right now I'm using "or" function in vba, but when I want
to add something, each time I need to open VB and chan
buy power programming by john walkenbach
On Thu, Oct 4, 2012 at 6:39 PM, ram gopal yadav wrote:
> Hi all,
>
> Thanks Prince, Rajan, Ashish You guys really shared wonderful info...
>
> As of now i m start reading the book and source on net.
>
> *BUT, is there any way to learn it by seeing video
IF(ISERROR(B2-A2),"",B2-A2)
format as [mm]
On Thu, Oct 4, 2012 at 6:51 PM, Chandra Shekar wrote:
> Hi,
>
> Could you please let me know how to ignore error in the rows?
>
> Regards,
>
> Chandra Shekar B
>
> On Wed, Oct 3, 2012 at 4:59 PM, Rajan_Verma wrote:
>
>> *Date2 Must be greater than Da
IF(ISERROR(B2-A2),"",B2-A2)
format as [mm]
On Thu, Oct 4, 2012 at 6:51 PM, Chandra Shekar wrote:
> Hi,
>
> Could you please let me know how to ignore error in the rows?
>
> Regards,
>
> Chandra Shekar B
>
> On Wed, Oct 3, 2012 at 4:59 PM, Rajan_Verma wrote:
>
>> *Date2 Must be greater than
can you attach the sample file and output of pivpt table
On Thu, Oct 4, 2012 at 6:44 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> I am trying to create pivot table by using vba.
>
> While working, the following error generated -
>
> [image: Inline image 1]
>
> Please help me by providing suitable
See the attached file, its siolved
Ashish
On Thu, Oct 4, 2012 at 7:14 PM, karthik N wrote:
> Hi Team,
>
> Please help in the attachment file
>
> Regards
> karthik.N
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alre
Hi Team,
Please help in the attachment file
Regards
karthik.N
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, N
Hi,
Could you please let me know how to ignore error in the rows?
Regards,
Chandra Shekar B
On Wed, Oct 3, 2012 at 4:59 PM, Rajan_Verma wrote:
> *Date2 Must be greater than Date1*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@
Hi all,
Thanks Prince, Rajan, Ashish You guys really shared wonderful info...
As of now i m start reading the book and source on net.
*BUT, is there any way to learn it by seeing video-Tutorials and yes is
there any kind of certification xam for the same which would be useful for
my Job prosp
Ram Gopal Yadav
Research Analyst-Agri Commodities
Noida
New to VBA -- need help how to start i.e, from basic
Hope i will be learn VBA..
On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>
> Welcome to excel group,one of the largest online commun
Did try yet, can you explain what you do actually ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of mburkett
Sent: 04 October 2012 12:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Dua
Based on the pattern,
it looks like you're wanting to round UP to the next increment of 5
However, there's might be a small problem.
Are the numbers you're testing really %'s?
That is..
is 50.3 really .503 represented as 50.3%
or is it actually 50.3 and you're just CALLING it a %?
If it's reall
Yes,
Actually I apply conditional formating for A2 and then copy it to all
cells... thats y date formatting get change..
On Thu, Oct 4, 2012 at 4:19 PM, Pravin Gunjal wrote:
> *Thanks Ahmed & Swapnil*
> *
> *
> *Yes there was some date formatting went wrong in Swapnil's file.*
> *
> *
> *Ahmed
Hi neeraj ,
you can use this
=IF(HOUR(TIMEVALUE(RIGHT(A2,8)))<12,"Night","Day")
On Thursday, 4 October 2012 14:40:45 UTC+5:30, neeraj chauhan wrote:
>
> Dear Experts
>
>
>
> Kindly see the attached sheet and urgently req.
>
--
Join official facebook page of this forum @
*Thanks Ahmed & Swapnil*
*
*
*Yes there was some date formatting went wrong in Swapnil's file.*
*
*
*Ahmed : your file is absolutely fine. *
*
*
*Thanks a lot !*
*
*
*Pravin Gunjal*
On Thu, Oct 4, 2012 at 4:08 PM, Ahmed Honest wrote:
> Dear Pravin,
>
> PFA with Revised and Swapnil one solutio
Hi Mangesh
Can you send file as Excel 2003.Then I will try to solved your problem.
On 10/3/12, Mangesh Vimay wrote:
> Hi Rajan,
>
> Its sample data I have provided but the data range would remain same.
>
> Please provide solution.
> Thanks !!!
>
> On Wed, Oct 3, 2012 at 6:43 PM, Rajan_Verma
> wro
How many Sheets this workbook have ?
do you remember all worksheet name?
you can write formual to recover the contain only but not formating
='fullpathofworkbook[WorksheetName]'!A1
Drag this formula below and right
Rajan.
On Thursday, 4 October 2012 08:57:17 UTC+5:30, B Sharma wrote:
>
> Dear
Dear Pravin,
PFA with Revised and Swapnil one solution is also the same but it is
disturbing the Date Column which has been undisturbed in my file. Choose
which ever suits your requirement.
Thanks,
On Thu, Oct 4, 2012 at 1:15 PM, Ahmed Honest wrote:
> Dear Pravin.
>
> *PFA*
>
> On Thu, Oct 4,
Hi Pravin,
PFA solution excel.
Regards,
Swapnil.
On Thu, Oct 4, 2012 at 3:31 PM, Pravin Gunjal wrote:
> *Hello Friends,*
> *
> *
> *I require a help on the subject matter. The file is attached for your
> reference.*
> *
> *
> *I have used the conditional formatting as mentioned in the excel
Thanks jeet!!
On Thu, Oct 4, 2012 at 3:27 PM, jeet singh wrote:
> Dear Friend,
>
> Plz find the attached file.
>
>
>
> On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote:
>
>> Dear Experts
>>
>> ** **
>>
>> Kindly see the attached sheet and urgently req.
>>
>> --
>> Join off
Dear Pravin.
*PFA*
On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote:
> *Hello Friends,*
> *
> *
> *I require a help on the subject matter. The file is attached for your
> reference.*
> *
> *
> *I have used the conditional formatting as mentioned in the excel file.
> And I required that the
Hi,
I didn't get what exactly you want. But attached solutin file as per my
understanding.
You cannot have more than 7 nested If conditions so I have used different
formula.
Formula:
=IF(A2>50, IF(MROUND(A2, 5)wrote:
> hi Group
>
> Can u please help me out in this problem. I have an query of
*Hello Friends,*
*
*
*I require a help on the subject matter. The file is attached for your
reference.*
*
*
*I have used the conditional formatting as mentioned in the excel file.
And I required that the same formatting has to be given for the full data
i.e. from A2 to E12 cells.*
*
*
*Kindly hel
Dear Friend,
Plz find the attached file.
On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote:
> Dear Experts
>
> ** **
>
> Kindly see the attached sheet and urgently req.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM
Dear Experts
Kindly see the attached sheet and urgently req.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
44 matches
Mail list logo
