Thanks Pankaj & Mandeep, all the codes running properly on real time data.
On Fri, Jan 15, 2016 at 7:10 PM, Pankaj Sharma
wrote:
> Result type2 is here:
>
>
> Sub SortRangeData2()
>
> Dim sh1 As Worksheet, sh2 As Worksheet
> Dim rng1 As Range, rng2 As Range, rng As Range, data As Rang
Result type2 is here:
Sub SortRangeData2()
Dim sh1 As Worksheet, sh2 As Worksheet
Dim rng1 As Range, rng2 As Range, rng As Range, data As Range
Dim arr As Variant, arr2 As String, txt As String
Dim i As Long, lr As Long
Set sh1 = ActiveSheet
On Error Resume Next
Set
Hey Devendra,
This code made me insane :*0,Let me tell you why ??
1) Numerous of Keywords Integers,Y,Years,SR Doesn't understood the meaning
what they are denoting Except years.
2) Took(Almost 2.5 hour).
Sorting is easy when all are numbers but difficult when Text values !!
the previous code y
Hi Mandeep,
Please revert, as I am facing a big issue because of this.
Thanks
On Fri, Jan 15, 2016 at 11:33 AM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi Mandeep,
>
> Please revert.
>
>
> On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay <
> devendrasahanypt...@gmail.com> wrot
Hi Mandeep,
Please revert.
On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi,
>
> I dont want to sort column a, I want to sort the comma separated data
> alphabetically & numerically in column 2.
>
> but the code which i have shared, it shorts the dat
Hi,
I dont want to sort column a, I want to sort the comma separated data
alphabetically & numerically in column 2.
but the code which i have shared, it shorts the data of column a & b both,
So all the data shuffled
This is the required format of the data.
Col 1Col 2
A10,15,
Hey Devendra,
Asked for output format? your query is not understandable. data shuffled
all the data ??,
Show me the output you require for this data given below :-
Col 1Col 2
A10,8year,5 year,15
B15,20year,17
D30,50 year,12
--
Are you =EXP(E
Hi Mandeep,
Please check the attached sample of data with the headers.
On Thu, Jan 14, 2016 at 3:49 PM, Mandeep Baluja
wrote:
> Didn't get what is ref.name ??? Didn't find it anywhere in your data,Will
>> it be possible if you share the output required format.
>>
>
> Regards,
> Mandeep baluja
>
>
> Didn't get what is ref.name ??? Didn't find it anywhere in your data,Will
> it be possible if you share the output required format.
>
Regards,
Mandeep baluja
--
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
Hi,
Sample of the data is attached. Please check
.
Thanks,
--
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
hope i understand ur requirement
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 2:33 PM, Prabhakar S H wrote:
> Hi Team,
>
> Need your help to sort (In one Short) Rows in Ascending order without
> using Macro or ASAP Utilites. Pls help.
>
> Rgds,
> Prabhakar
>
> --
> Are y
Hi Vijay,
Their is no need of formula to solve your request. By using sorting option
in excel we can sort the data from largest to smallest or smallest to
largest.
Here are the few steps to get your desired output
Step1
Go to cell "B1" (i.e Salary Column) press Ctrl+Shift+L
Press Alt+Downarrow
Pl refer
http://www.contextures.com/xlSort01.html
HTH//Thanks
On Fri, Jul 26, 2013 at 2:17 PM, vijay yadav
wrote:
> Dear Excel experts,
>
> I have to sort data in two columns ,first column contains name and second
> column contains salary.
> The new columns should contain salary in descending
Hi Viney, Thanks a lot for your suggestion...in the end we arrive to the
same solution. I was managing the problem in a similar way!
Sergiovery
Il giorno sabato 16 marzo 2013 06:14:13 UTC+1, viney mehta ha scritto:
> hi Sergiovery,
>
> i tried is for you.see the solution sheet..
>
> hope thi
hi Sergiovery,
i tried is for you.see the solution sheet..
hope this will help
On Fri, Mar 15, 2013 at 7:04 PM, Sergiovery wrote:
> Here it is!
> Thanks for your time :-)
> Sergiovery
>
>
> Il giorno venerdì 15 marzo 2013 13:16:27 UTC+1, viney mehta ha scritto:
>
>> Please send the excel f
Here it is!
Thanks for your time :-)
Sergiovery
Il giorno venerdì 15 marzo 2013 13:16:27 UTC+1, viney mehta ha scritto:
> Please send the excel file to analyse and understand
>
>
> On Fri, Mar 15, 2013 at 5:31 PM, gurur...@gmail.com <
> gurur...@gmail.com > wrote:
>
>>
>>
>>
>>
>> Sent from my
Please send the excel file to analyse and understand
On Fri, Mar 15, 2013 at 5:31 PM, gururam...@gmail.com
wrote:
>
>
>
>
> Sent from my HTC
>
>
> - Reply message -
> From: "Sergiovery"
> To:
> Subject: $$Excel-Macros$$ Sorting by levels
> Date: Fri, Mar 15, 2013 16:36
>
>
> Hello!
> I
Sent from my HTC
- Reply message -
From: "Sergiovery"
To:
Subject: $$Excel-Macros$$ Sorting by levels
Date: Fri, Mar 15, 2013 16:36
Hello!I've tried to look for solution to my problem waving the site...but till
now, no success :-(
My issue:
I've a table with these 7 columns
A. Colum
Hi Amit,
1st Select Your Data & Press Shortcut Key: - Alt+H+S+S. Expand the
selection & Click Short button.
[image: Inline image 1]
Regards,
Kuldeep Singh
On Thu, Sep 13, 2012 at 9:16 PM, >>Excel Beginner<< wrote:
> Hi Amit,
>
> First Select Your Data and Using this shortcut
Hi Amit,
First Select Your Data and Using this shortcut Key
>> Alt+A+A
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Sep 13, 2012 at 5:37 PM, Amit Desai (MERU)
wrote:
> Please let me know if we have an easier way for sorting data all
> together in all sheet having common column
use =SMALL($B$2:$B$21,ROW()-1)
On 6/8/12, Rajan_Verma wrote:
> Hi Hilary
>
> You can take idea from this file.
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of hilary lomotey
>
Hi Hilary
You can take idea from this file.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: 08 June 2012 6:56
To: excel-macros
Subject: $$Excel-Macros$$ Sorting Alphabetically wi
thanks Noorain for the examples really grateful, however, i noticed that
you still have to use COUNTIF($O$29:$O$44,"<="&O29) in other to be able
to sort,ie the sumproduct etc are all dependent on it.
THE PROBLEM WITH THE SHEET I AM WORKING IN IS THAT IT DOESNT BEGIN WITH 1
IF I USE THE COUNTIF
Thanks, Dave, but its not working, could you kindly do it in the sheet and
send back? thnks
On Fri, Jun 8, 2012 at 1:36 PM, David Grugeon wrote:
> Hi Hilary
>
> Use the SMALL function starting with 1 and increasing it each time.
>
>
> On 8 June 2012 23:25, hilary lomotey wrote:
>
>> Hi Experts
Hi Hilary,
Please find attached sorting sheet, Which have many example to sorting data
through formula. Hope it will help to you.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 8, 2012 at 7:06 PM, David Grugeon wrote:
> Hi Hilary
>
> Us
Hi Hilary
Use the SMALL function starting with 1 and increasing it each time.
On 8 June 2012 23:25, hilary lomotey wrote:
> Hi Experts
>
> i am trying to sort alphabetically with a formula in the attached sheet in
> column "O", i tried using COUNTIF($O$29:$O$44,"<="&O29) to get the first
> numb
: Saturday, April 14, 2012 3:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sorting cells
Hi Rajan,
I did ... and it doesn't work. If you sort B1:B4 using A-Z, the cells in
column B remain the same ie B1 holds =A1, B2 holds =A2 etc. I want to see
Bonn in B1 (actuall
Hi Rajan,
I did ... and it doesn't work. If you sort B1:B4 using A-Z, the cells in
column B remain the same ie B1 holds =A1, B2 holds =A2 etc. I want to see
Bonn in B1 (actually =A3), London in B2 (actually =A1), Madrid in B3 and
Paris in B4.
Regards, kenrock
On Friday, April 13, 2012 8:51:53
Hi
Why don't you use sort by the way
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of kenrock
Sent: Apr/Thu/2012 08:59
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sorting cells
I have the word "London" in cell A1, "Paris" i
Hi Saravanan
check whether this help
http://www.rondebruin.nl/key.htm
Thanks
Mahesh
On Fri, Jun 17, 2011 at 8:35 PM, saravanan R wrote:
> Hi Excelates,
>
> I need an Urgent help on disabling the Sort in the filter dropdown.
> Is there a way to disable only the short cut key i.e only the lette
Tx Ashish
Regards
Akhilesh AIren
--
--
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
Sub sort_ascending()
' choose xlno if data is not having header
' change order as ascending or descending
Sheets(1).Range("a6:h" & Range("a6").End(xlDown).Row).Sort
key1:=Sheets(1).Range("c6"), order1:=xlAscending, Header:=xlYes
End Sub
On Tue, Jun 14, 2011 at 7:35 PM, airen wrote:
> hello,
>
Wow, I like this VBA example quite a bit, the problem I provided was
indeed simplistic and would need to be modified for my intended need.
I'm fairly new at VBA and very much appreciate your skill and
knowledge. I was wondering if an array was the way to go! Thank you
Again!
On Feb 2, 3:51 am, s
Very easy to understand, and just what I needed. Thank you very much
for your time and knowledge!
On Feb 2, 12:40 am, ashish koul wrote:
> see if this helps
>
> Sub sort1()
>
> Sheets(1).Range("a1:a" & Range("a1").End(xlDown).Row).Sort
> key1:=Sheets(1).Range("a:a"), order1:=xlAscending, Header:
see if this helps
Sub sort1()
Sheets(1).Range("a1:a" & Range("a1").End(xlDown).Row).Sort
key1:=Sheets(1).Range("a:a"), order1:=xlAscending, Header:=xlYes
Sheets(1).Range("b1:b" & Range("b1").End(xlDown).Row).Sort
key1:=Sheets(1).Range("b:b"), order1:=xlAscending, Header:=xlYes
Dim i As Long
For i
Tommy:
Sorry, it looks like my response didn't get sent.
How "deep" do you want to go?
The fact is: You can name a range to contain
the upper section, then either select the named range and sort,
or use a macro and do:
Sub SortData()
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
Hi Paul, thanks for helping me.
Below is the configuration of my data. The only area that is to be
alphabetized is the array of letters in the example below, A7 and
below remain unchanged. As new data is entered it is place in row 1
and all existing data is shifted down including the data below th
Let me see if I understand.
A7-A has information that will be untouched.
First: the sort:
the first 6 rows and 4 columns you want to sort.
alphabetically.
each cell? or each row?
if each cell, vertically then horizontally?
as in:
Alpha Golf Mike Sierra
Bravo hotel November Tango
Charlie India
Hi Om,
We can sort this using VBA in the same way I summed them, but I don't think
it's possible to sort them without VBA.
We can get VBA to re-write the data, so that all the Cr's are copied to one
column, and all the Dr's are copied to another.
Then you can use worksheet functions on those
39 matches
Mail list logo
