please add the my number 9582279261
--
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 Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
thanks
On Tuesday, August 9, 2016 11:21 AM, Abhishek Jain
wrote:
PFA
On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS
wrote:
Dear Expert,
please help me out lookup and sum from sheet2
regardsLAKSHMAN--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)
Dear Expert,
please help me out lookup and sum from sheet2
regardsLAKSHMAN
--
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 Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
ewLine &
vbNewLine & "Thank you"
.Attachments.Add "c:\aaa.xlsb"
.Send
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in
inbox
Lakshman Prasad
--
Are you =EX
ewLine &
vbNewLine & "Thank you"
.Attachments.Add "c:\aaa.xlsb"
.Send
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in
inbox
Lakshman Prasad
--
Are you =EX
ewLine &
vbNewLine & "Thank you"
.Attachments.Add "c:\aaa.xlsb"
.Send
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Need to run macro when outlook 2007 sent/receive or refresh or mail arrive in
inbox
Lakshman Prasad
--
Are you =EX
Dear expert
I have a sheet in which money receipt details maintain, I want to filter like
sheet “Result” means UNITNO With amount of higher value.
Reg's
Lakshman Prasad
--
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
- Forwarded Message -
From: Waseem Saifi
To: excel-macros
Sent: Wednesday, July 24, 2013 11:50 AM
Subject: Re: $$Excel-Macros$$ Want conditional lookup
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
wrote:
Dear Expert,
>Want conditional loo
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
wrote:
Dear Expert,
>Want conditional lookup from sheet 1 those data which is active in column A ,
>plz the attached file
>
>Thanks,
>Regards
>LAKSHMAN--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT))
, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
wrote:
Dear Expert,
>Want conditional lookup from sheet 1 those data which is active in column A ,
>plz the attached file
>
>Thanks,
>Regards
>LAKSHMAN--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Dear Expert,
Want conditional lookup from sheet 1 those data which is active in column A ,
plz the attached file
Thanks,
Regards
LAKSHMAN
--
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 Facebook page of this forum @
https://ww
still waiting
Lakshman Prasad
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Cc: "gawlianil8...@gmail.com" ;
"chayamon...@gmail.com"
Sent: Monday, April 15, 2013 12:58 PM
Subject: Re: $$Excel-Macros$$ print
Dear Expert,
Is there any option or code to print all open browsers.
Lakshman Prasad
--
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 Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
NO
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
From: Lalit Mohan Pandey
To: excel-macros@googlegroups.com
Cc: "gawlianil8...@gmail.com" ;
"chayam
still waiting
Lakshman Prasad
Sr. Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Cc: "gawlianil8...@gm
Dear expert
I have a excel file, in a sheet contain some details with URL, is there any
formula add-on or marco to print all URL details in a PDF file.
Lakshman Prasad
--
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 Facebook
ok
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Tuesday, August 7, 2012 11:53 AM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
C the attached file. ? u
eed to.
On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD wrote:
You are missing
>
>
>
>
>SUMPRODUCT((A7:A23>E1)*(A7:A23
>
>
>Lakshman Prasad
>Manager (Finance)
>GAURSONS INDIA LIMITED
>Ph: +91 12 456777 Mob. No. 9582279261
>Website: http://www.gaursonsin
You are missing
SUMPRODUCT((A7:A23>E1)*(A7:A23http://www.gaursonsindia.com/
From: Ashish Bhalara
To: excel-macros@googlegroups.com
Sent: Saturday, August 4, 2012 4:02 PM
Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date
Dear expert
Awaited for your reply...
I
have attached sample file
Lakshman
Prasad
- Forwarded Message -
From: dguillett1
To: LAKSHMAN PRASAD
Sent: Thursday, July 12, 2012 5:37
PM
Subject: Re: Split Workbook
into Multiple Worksheets
If you decide to hire me to do this @ $75
-???
Total-5MB
Regards
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
That's gud
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Tuesday, June 12, 2012 7:23 PM
Subject: RE: $$
Dear Rajan and All,
I request,
Don’t say like this "I will send you on your email id ".If you really want to
send then send him silently.
Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaurson
Hi everyone,
My name is LAKSHMAN PRASAD. I live in NOIDA, age 39 years. I work as an
Assistant Manager Accounts. I work with Excel, ERP and Word. And i also
interseted or hobbies doing Excel r&d, Desktop and Laptop Hardware/software
installation and troubleshooting, photoshop, coral draw
Is this working in excel 2007?
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Wednesday, June 6, 2012 11:29 PM
Subject: Re: $$Excel-Macros$$ Need a file on commonly used Formulas and
Functions for MS Excel 2010
Hi Smitha,
Please find atta
C the att.
From: Lokesh Loki
To: excel-macros@googlegroups.com
Sent: Monday, June 4, 2012 6:48 PM
Subject: $$Excel-Macros$$ Date format
Hi Experts,
I want to confirm the date format whether it is showing Indian date format or
us date format.
Please se
Hello everybody,
But if we want like under example …..
Amount Round figer
1864138 190
361408 40
465654 50
445000 40
12 10
15 10
16 20
123 100
150 100
155 200
1234 1000
1500 1000
1555 2000
Regards
LAKSHMAN
From: Asa Rossoff
To: exce
me 2 plz
From: pawel lupinski
To: "excel-macros@googlegroups.com"
Sent: Wednesday, May 30, 2012 5:39 AM
Subject: Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files
thanks
Pawel
From: Aruna jayaram
To: excel-m
#x27;s know where
are you facing problem.-- Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 11:44 AM, LAKSHMAN PRASAD
wrote:
Hello champ.,
>This formula is picking up only first disit of cell only.
>1001GANG 1
>1002COL. 1
>1002TEJI 1
ng1 As String
Dim i As Integer
String1 = ""
For i = 1 To Len(c)
If IsNumeric(Mid(c, i, 1)) Then
String1 = String1 & Mid(c, i, 1)
End If
Next
removetext = String1
How to collect only numeric value from a particular cell
1462NIRM 1462
1464NIRM 1464
1465NIRM 1465
1404--BL 1404
1031Infr 1031
8020LOKN 8020
202D.B. 202
922Parmi 922
5071RIFA 5071
1040Harj 1040
5078Harj 5078
1471Raj 1471
1571Raj 1571
414Ruchi 414
2084AJAY 2084
Regards
LAKSHMAN
see the attached file
From: Amit Gandhi
To: excel-macros@googlegroups.com
Sent: Wednesday, May 23, 2012 5:18 PM
Subject: $$Excel-Macros$$ VLLOKUP IS NOT WORKING
Hi Experts
>
>
>
>
>VLOOKUP is not working in attached file, can anyone help me why its not
d
On Tue, May 22, 2012 at 10:03 AM, LAKSHMAN PRASAD
wrote:
Plz see the attached file
>
>
>
>
>
>
>From: Aamir Shahzad To:
>excel-macros@googlegroups.com Sent: Monday, May 21, 2012 11:27 PM
>Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
>sorry no
hzad
On Sun, May 20, 2012 at 5:17 PM, Seraj Alam wrote:
Hi,
>
>
>Please try below formula...
>
>
>
>
>=IFERROR(VLOOKUP("*"&A2&"*",Sheet2!$A$2:$B$3272,2,0),"")
>
>
>On Sat, May 19, 2012 at 12:16 PM, LAKSHMAN PRASAD
>wrote:
http://www.4tops.com/mailmergeemailpdf.htm
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Saturday, May 19, 2012 5:23 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for
outlook emails sending Specific Te
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Saturday, May 19, 2012 5:32 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for
outlook emai
If you want With Attachments formats of word and html it would be possible.
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Saturday, May 19, 2012 5:23 PM
Subject: Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a
If you want With Attachments formats of word it would be possible.
From: renuka chari
To: excel-macros@googlegroups.com
Sent: Saturday, May 19, 2012 4:57 PM
Subject: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook
emails sending Spec
. ANUPAM SARKAR(2)
both are not matching that,s why
Regards,
Anil Gawli
On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD
wrote:
Hi Anil,
>
>Plz see cell D13 and D17 value or #NA data no coming
>
>
>
>From: Anil Gawli
>To: excel-macros@googlegroups.com
>Sent: Frid
18, 2012 at 4:36 PM, LAKSHMAN PRASAD wrote:
Dear Expert
>I m unable to use advance vlookup, plz see the attached file.
>Regards
>LAKSHMAN
>--
>FORUM RULES (986+ members already BANNED for violation)
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please
sheets in
excel 2007.
Dear Lakshman,
Please use attached Add-In
Hope it will useful for you.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, May 9, 2012 at 3:41 PM, LAKSHMAN PRASAD wrote:
Dear Expart,
>
>How to create pivot
very nice thanks
From: Maries
To: excel-macros@googlegroups.com
Sent: Saturday, May 5, 2012 5:45 PM
Subject: Re: $$Excel-Macros$$ Need macro website
Hi,
Check below link,
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
Regards,
MARIES.
contect to NOORAIN
@
From: vijayajith VA
To: excel-macros@googlegroups.com
Sent: Saturday, May 5, 2012 11:31 AM
Subject: Re: $$Excel-Macros$$ Please suggest as i want to learn MS-Access
(Noida)
HI prince
Try this.
MVP'S Web Links
Al Campagna http
Congrats Rajan .. bhayee
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't
plz resend file corrupted
From: MURALI NAGARAJAN
To: excel-macros@googlegroups.com
Sent: Wednesday, May 2, 2012 11:00 AM
Subject: $$Excel-Macros$$ Need rank formula
Dear experts.
I need rank formula for attached file.
Thanks in advance
Thanks&Regards
IF(AND(B3="green",B2="red"),30,IF(AND(B3="red",B2="green"),30,IF(AND(B3="red",B2=""),30,IF(AND(B3="",B2="red"),30,0
From: pawel lupinski
To: "excel-macros@googlegroups.com"
Sent: Monday, April 30, 2012 2:45 PM
Subject: Re: $$Excel-Macros$$ change color dep
Hi Anil,
can u share sample sheet with example.
Regards
LAKSHMAN
From: anil kumar
To: excel-macros@googlegroups.com
Sent: Monday, April 30, 2012 12:35 PM
Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know
I exprot data from busy in 5 workbook. a
why need macros? use paste as transpose only.
From: Mukesh Kukreja
To: excel-macros@googlegroups.com
Sent: Friday, April 27, 2012 3:29 PM
Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently
Hi All,
Request you to kindly help me very u
Dear Experts,
Can we convert xls to xlsx without open xls(original file)
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wi
Dear Soni,
plz c the attached file..
From: LAKSHMAN PRASAD
To: "excel-macros@googlegroups.com"
Sent: Thursday, April 19, 2012 5:49 PM
Subject: Re: $$Excel-Macros$$ Urgent - Pivot table
Dear Soni,
plz c the attached file..
top 3 state
Dear Soni,
plz c the attached file..
From: Soni.Rajender
To: excel-macros@googlegroups.com
Sent: Thursday, April 19, 2012 4:26 PM
Subject: $$Excel-Macros$$ Urgent - Pivot table
Dear Team
Please find attached the excel workbook having a pivot table i
.
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of LAKSHMAN PRASAD
Sent: Apr/Wed/2012 11:08
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Best resource to learn MS SQL queries
Dear Expart and Vikash,
Is there any group like this (excel-macros
Dear Expart and Vikash,
Is there any group like this (excel-macros)
LAKSHMAN
From: Vikash Chandra
To: excel-macros@googlegroups.com
Sent: Tuesday, April 17, 2012 6:22 PM
Subject: Re: $$Excel-Macros$$ Best resource to learn MS SQL queries
Hi Amit,
I thi
Dear Experts and Noorian,
Is this site (http://www.ozgrid.com/Excel/free-training/basic-index.htm) is ok
for beginner.
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
Delhi NCR
From: Veeru TOC
To: excel-macros@googlegroups.com
Sent: Thursday, April 5, 2012 12:57 PM
Subject: Re: Fwd: $$Excel-Macros$$ VBA Classes
Venue,,, Plz,,,
On Thu, Apr 5, 2012 at 12:30 PM, LAKSHMAN PRASAD wrote:
me tooo
>
>
>
>
me tooo
From: Lokesh Loki
To: excel-macros@googlegroups.com
Sent: Wednesday, April 4, 2012 7:27 PM
Subject: Fwd: $$Excel-Macros$$ VBA Classes
Hi Experts,
May i know that is there any Excel & Power point Vba classes conducting in
weekend through online on th
use after trim
VLOOKUP(D6,C6:C47,1,FALSE)
From: Deba Ranjan
To: excel-macros@googlegroups.com; NOORAIN ANSARI
Sent: Tuesday, April 3, 2012 1:29 PM
Subject: $$Excel-Macros$$ Exact names Find
Dear Expert,
Please find the attached file. i just wa
Dear Shrini
Plz find out solve attach file.
Regards
LAKSHMAN
From: Shrinivas Shevde
To: excel-macros@googlegroups.com
Sent: Monday, April 2, 2012 12:44 PM
Subject: $$Excel-Macros$$ Count formula
Dear all ,
I have a software which takes the reading for temp.
I
On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD wrote:
Dear Noorain,
>
>I think he want 532, and I'd like to be converted to 05:32
>
>
>
>
>From: NOORAIN ANSARI
>To: excel-macros@googlegroups.com
>Sent: Wednesday, March 28, 2012 7:55 AM
>
>Subje
instead of Criteria Range+Sum Range
--
Thanks & regards,
Noorain Ansari
http://noorainansari.com/
http://excelmacroworld.blogspot.com/
On Tue, Mar 27, 2012 at 3:38 PM, LAKSHMAN PRASAD wrote:
Dear Noorain,
>
>is there any prob. when i use
>
>SUMIF(A1:B4,A7,B1:B4)
>
Dear Noorain,
I think he want 532, and I'd like to be converted to 05:32
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Wednesday, March 28, 2012 7:55 AM
Subject: Re: $$Excel-Macros$$ format a cell
Dear Pawel.
Please try it..
=TIME(
Dear Noorain,
is there any prob. when i use
SUMIF(A1:B4,A7,B1:B4)
just for knowlege
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Tuesday, March 27, 2012 7:45 AM
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
Dear Finos,
Dear Noorian and expert,
Plz see the attached file. Is there any short formula for this result
Regards
LAKSHMAN
9582279261
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Dear Grpou Member,
Look at the attached file this solution was posted by Mr. NOORION. I was trying
to understand step by step the result. But I m unable to understand “INDIRECT”.
Can anyone clarify the steps.
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Us
Dear Group Owner,
I am required link of Unsubscribe only my lakshman...@yahoo.com ID
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need A
Plz see the attached
From: PRAVESH KUMAR
To: excel-macros@googlegroups.com
Sent: Saturday, 18 February 2012 12:38 PM
Subject: $$Excel-Macros$$ Conditional formatting
HI,
Please help...for conditional formatting
PFA attached file
Dear PrIyANkAtyr this
Sub Delete_Folders_FS()
objFolder = "D:\Documents and Settings\lakshman-\Desktop\New Folder\*.*"
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.deletefolder objFolder
End Sub
LAKSHMAN
From: PrIyAnKa
To: excel-macros@
Thanx David
From: David Grugeon
To: excel-macros@googlegroups.com
Sent: Friday, 10 February 2012 6:28 PM
Subject: Re: $$Excel-Macros$$ formula for this
Try the attached
On 10 February 2012 21:50, Lakshman Prasad wrote:
m waiting
>
>
&
Divide from lac =165221/10 (1.65221)
From: Ashish Bhalara
To: excel-macros@googlegroups.com
Sent: Friday, 10 February 2012 5:34 PM
Subject: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Dear expert,
I require the macro to transfer the number in unit
m waiting
From: Lakshman Prasad
To: "excel-macros@googlegroups.com"
Cc: "excelexpertsc...@yahoogroups.com"
Sent: Friday, 10 February 2012 3:01 PM
Subject: $$Excel-Macros$$ formula for this
Dear Group member,
Plz see the attached fil
Dear Group member,
Plz see the attached file, I have a workbook (sheet1) that have some raw date,
I want to arrange as my requirement like sheet2.
Is that any VBA code or formula for this.
Regards
LAKSHMAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thre
Sorry,
=AVERAGE(F2:F11)
From: sunil bn
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 4:49 PM
Subject: $$Excel-Macros$$ excel macros - Sunil B.N
Hi Expert,
Please find the attached file.
1. I need “average formula” which includes
Hello Mr. Sunil
Use =AVERAGE(F2:F11,{1})
From: sunil bn
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 4:49 PM
Subject: $$Excel-Macros$$ excel macros - Sunil B.N
Hi Expert,
Please find the attached file.
1. I need “average
Dear Darwin,
Plz see attached file.
is it ok?
From: Darwin Chan
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 9:24 AM
Subject: $$Excel-Macros$$ Cstr function
Dear group,
Would like to ask how to use Cstr, left and mid functions to split
Dear Pravesh,
You can use lookup too
VLOOKUP(I13:I19,D11:E24,2)
From: PRAVESH KUMAR
To: excel-macros@googlegroups.com
Sent: Friday, 3 February 2012 11:06 PM
Subject: $$Excel-Macros$$ Urgent Help
Hi,
please help ASAP.
please find attached sheet.
Than
Dear anjul
Plz See the attached file with your solution.
From: Anjul Porwal
To: excel-macros@googlegroups.com
Sent: Thursday, 2 February 2012 4:52 PM
Subject: $$Excel-Macros$$ Category wise Count.
Dear Expart,
I want to count or category wise..pls help.
Dear NOORAIN,
It is a success, you truly deserved. It is an achievement you have truly
earned. I congratulate you on your success and wish you all the best for your
future. Well done.
You met the challenge with determination, strength, and total confidence!
Congrats!
LAKSHMAN...
___
Dear Noorain
Anil want to do like under written
Jh yksds'k dqekj vxzoky to Shri Lokesh Kumar Aggarwal
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Friday, 20 January 2012 2:13 PM
Subject: Re: $$Excel-Macros$$ query about transla
thanx noor
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Friday, 20 January 2012 11:20 AM
Subject: Re: $$Excel-Macros$$ EXCEL - TIPS
Dear Kishore,
You can study attached Ebook step by step..
It will help you to learn excel.
-
Thanks & regar
Because this vba for million and billion format.
For lakh you use other vba code
From: Sanjib Chatterjee
To: noorain.ansari ; excel-macros
Sent: Tuesday, 17 January 2012 1:19 PM
Subject: $$Excel-Macros$$ regarding number to text
Dear NOORAIN ANSARI,
This
i think her system macro is disable.
coz, i have checked its working.
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Tuesday, 17 January 2012 1:43 PM
Subject: Re: $$Excel-Macros$$ convert numbers into words
Hi Priyanka,
Can you explain what er
1 To 1000
With rng
If IsNumeric(rng.Cells(i, 1).Value) Then
.Cells(i, 4).Value = .Cells(i, 1).Value
End If
End With
Next i
End Sub
Regards,
MARIES
On Sat, Jan 14, 2012 at 1:26 PM, Lakshman Prasad wrote:
Dear Noorain,
>
>it, ok
>
>bu
Dear Noorain,
it, ok
but if i want to remove number/disite?
Regards
LAKSHMAN
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Friday, 13 January 2012 8:25 PM
Subject: Re: $$Excel-Macros$$ Delete text only
Dear Lokesh,
Please try it..
Sub
Dear Aralan,
could u put the value which u want like.
From: Muhammad Arslan
To: excel-macros@googlegroups.com
Sent: Thursday, 12 January 2012 5:42 PM
Subject: Re: $$Excel-Macros$$ Receivable Aging
Ok For your reference see attached file
On Thu, Jan 12, 2
me too
From: PrIyAnKa
To: excel-macros@googlegroups.com
Sent: Thursday, 12 January 2012 5:51 PM
Subject: Re: $$Excel-Macros$$ Receivable Aging
still not getting what u want in output,
Kindly give one example of it in excel
On Thu, Jan 12, 2012 at 5:42 PM, M
Hello AsaThis =FIND(UPPER(A1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ")and this
is ok =CODE(UPPER(A1))-64for under result
a =1
b= 2
c=3
but what about for this
acb =132
Regards
LAKSHMAN
From: Asa Rossoff
To: excel-macros@googlegroups.com
Sent: Tuesday, 2
Message flagged
Wednesday, 21 December 2011 11:13 AM
Message Body
Hello expert,
I have thousands of mail in many archive folders in Microsoft office outlook
2007. Is any function or VBA script to save all contacts when I open any mail
automatically.
Regards
LAKSHMAN
--
FORUM RULES (934+ mem
Hello anil,
U want to do self programming for this? or u can try attch. file
already programed.
From: anil kumar
To: excel-macros@googlegroups.com
Sent: Tuesday, 20 December 2011 4:34 PM
Subject: Re: $$Excel-Macros$$ convert jpj in excel
HI LAKSHMAN
w where i got
it, and i don´t know if i can give it to you as i´m not aware if it is
coyrighted, someone gave me, but it´s for excel2003, see if it is useful for
you. Regards
>
>
>
>2011/12/9 Lakshman Prasad
>
>Dear All,
>>
>>
>>I don't know anything abo
Dear Tan,
Find “*” with suffix one or two character and replace only selected suffix
Like find “09*” and replace with “09”
Regards
LAKSHMAN
From: tan dennis
To: excel-macros@googlegroups.com
Sent: Friday, 9 December 2011 5:16 PM
Subject: $$Excel-Macros$$
Dear All,
I
don't know anything about macrosand about programming or
VBA to create and use macros. But I
want to do or learn seriously. Can anybody help me related this. Related basic
book or rule or anything plz guide me how can I proceed.
Regards
LAKSHMAN
9582279261
--
FORUM RULES (934+ m
ear Lakshman,
>>>
>>>
>>>You are not able to do the SUM as the data in the last column has leading
>>>and trailing spaces.
>>>You can use the add-on http://www.ablebits.com/excel-trim-spaces/index.php
>>>to quickly remove the spaces, i
s,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Wed, Dec 7, 2011 at 1:43 PM, Lakshman Prasad wrote:
Dear All,
>Plz see the attach file. I can’t understand why I m unable to do sum. What is
>the problem in sheet or number? Help anybody?
>R
Dear All,
Plz see the attach file. I can’t understand why I m unable to do sum. What is
the problem in sheet or number? Help anybody?
Regards
LAKSHMAN
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgen
94 matches
Mail list logo
