Hi
Very Limited Knowledge of Excel as compared to most others. I use Excel
2003. What I did was to add another column with the formula
=text(C2,"mmmm") C2 is the date column. (I converted 05.04.2012 into a
proper date format first).
The above formula gave me a month like "April". Then used the regular
"Filter" to sort on the additional column created -- Month.
Most likely a longer method of solving the issue. CoRe's solution works
great. (And without the need to add any column).
Thanks
Ashish Pradhan
(M) 9167594244
On 13-08-2012 15:55, CoRe wrote:
Hello Gunjal ,
Please check the file attached.
My result (excel 2007 or older) : Select all your date , go to Home >
Sort & Filter > Custom Sort
On Monday, August 13, 2012 1:00:20 PM UTC+3, Pravin Gunjal wrote:
Dear Friends
Greetings for the day!
I have attached herewith one file in which three columns are
there. viz. 1) Doc. No. 2) Doc. Date & 3) Party Name
1) I would like to sort this file as per the serial doc. numbers
but unable to do. If we do the date wise sorting it takes day
wise only and not as month wise day wise.
2) As we are having some customer data in different excel file and
need to be gathered in a single file. But we can not do the
v-lookup use directly, as this file is having customer names along
with the places. And in other file we are having only names
without their places - At present we are doing it manually like :
we are sorting it customer wise and removing the place by using
edit function for a stockist and using copy-paste for that
particular stockist.
As approximately we are having 98 customers and it is very
difficult to do it manually.
Kindly help me out on this issue. Thank you.
*With regards,
**Pravin Gunjal**
*
--
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, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
--
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
