Try this to sort list in Array Function :
Option Base 1
Function SortedList(rng As Range) As Variant
Dim arr() As Variant
Dim rw, cl As Double
r = rng.Rows.Count
cl = 1
ReDim arr(r, cl)
arr = rng
For i = 1 To r
For j = 1 To r - i
If arr(j, 1) > arr(j + 1, 1) Then
temp = arr(j, 1)
arr(j, 1) = arr(j + 1, 1)
arr(j + 1, 1) = temp
End If
Next
Next
SortedList = arr
End Function
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of naanu v
Sent: Friday, August 26, 2011 5:21 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need formula
thank u
but plz refer to my previous mail
i also wanted tht array to be sorted with d help of formula
On Fri, Aug 26, 2011 at 5:16 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>
wrote:
Dear naanu,
try it through Lookup
=IF(ISERROR(VLOOKUP(C3,$A$3:$A$15,1,0)),"Text Not Found","Text Found")
On Fri, Aug 26, 2011 at 5:11 PM, naanu v <naanu2...@gmail.com> wrote:
Thank u
i would like to know is there any other formula in lookup or statistical or
information
On Fri, Aug 26, 2011 at 5:09 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>
wrote:
Dear nannu,
See attached sheet, if it help
--
Thanks & regards,
Noorain Ansari
<http://noorain-ansari.blogspot.com/> http://noorain-ansari.blogspot.com/
On Fri, Aug 26, 2011 at 4:57 PM, naanu v <naanu2...@gmail.com> wrote:
Thank u so much , but i want in below format
Aru
fddfs
Text found
ihcx
zesr
Text found
dst
fddfs
Text found
cfdf
zesr
Text found
eder
dfds
Text found
dfds
dfds
Text found
yes
err
Text not found
fddfs
dfsf
Text not found
dfds
dsdas
Text not found
zesr
xzcxc
Text not found
vdfd
wewq
Text not found
zdfdf
zcvz
Text not found
drer
sdfds
Text not found
On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ <viper....@gmail.com> wrote:
Dear naanu
Go through the attachment. it may help. or please make it clear with sample
file
--
Great day,
viper
On Thu, Aug 25, 2011 at 8:51 PM, naanu <naanu2...@gmail.com> wrote:
I want to know the formula to find out the solution.
For Ex: I have two columns
Aru
fddfs
eder
dfds
ihcx
zesr
yes
err
fddfs
dfsf
dfds
dsdas
zesr
xzcxc
vdfd
wewq
dst
fddfs
dfds
dfds
cfdf
zesr
zdfdf
zcvz
drer
sdfds
1
2
Nw i would like to sort column 2 in such a way that
There should be different list in column 2
1. The values found in column 1
2. The values not available in column 1
Please help me out of the problem
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Thanks & regards,
Noorain Ansari
<http://noorain-ansari.blogspot.com/> http://noorain-ansari.blogspot.com/
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
