Sent: Thursday, October 13, 2011 10:13 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)
Dear Don other experts
Coloumn A has raw data and column B have sorted data
Before After
52 193
86 195
92C 52
94B 86
94B 87
195 92C
193 94B
ABC
-macros@googlegroups.com excel-macros@googlegroups.com
Cc: sharma@gmail.com
Sent: Fri, October 14, 2011 1:15:27 AM
Subject: Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)
Hi,
In the Sorted list, you have shown 92C, 94B, 94C...
This is not sorted as per alphabet order and neither
Dear Excel Experts (and to my friends who have answered to my
earlier queries)
From a long time, I am searching for a formula which can sort the list
and represent the unique datas only
for Example , In column 1 I have the following data
52
86
92C
94B
94B
195
193
ABC
XYZ
87
94J
94B
94K
94C
Hi,
The query is not easy but remember this group is awsome which can handle
these types of query.
See the attachment where I have tried sorting the data numeric/
alphanumeric.
Regards,
DILIPandey
On 13 Oct 2011 19:17, B Sharma sharma@gmail.com wrote:
Dear Excel Experts (and to my
What would the AFTER look like
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: B Sharma
Sent: Thursday, October 13, 2011 8:46 AM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric
-
From: B Sharma
Sent: Thursday, October 13, 2011 8:46 AM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)
Dear Excel Experts (and to my friends who have answered to my
earlier queries)
From a long time, I am
: Thursday, October 13, 2011 8:46 AM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)
Dear Excel Experts (and to my friends who have answered to my
earlier queries)
From a long time, I am searching for a formula