$$Excel-Macros$$ Re: SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as per descending order of salary
Great! Excellent! Perfect work! Thanks again Deepak, you are a genius. Regards Vijay Yadav On Friday, 26 July 2013 14:17:30 UTC+5:30, 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 order and name in > corresponding cell. > > A small example is given below - > > *DATA available-* > Column A(name) Column B(salary) > KISHAN > 6 > > AJAY 24000 SANGEETA > 6 > > > *OUTPUT required with help of formulae -* > Column C(name) Column D(salary) > KISHAN > 6 SANGEETA 6 AJAY 24000 > Excel sheet is attached containing the data. > Kindly help. > > Regards > Vijay Yadav > -- 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 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as per descending order of salary
Dear Vijay PFA Regards Deepak On Fri, Jul 26, 2013 at 3:18 PM, vijay yadav wrote: > Dear Kartik, > > Thanks for the suggestions. > I do not want to sort list manually but need formuale to sort the above > columns as there is some interlinking with other cells. > > Also i can sort the salary in descending order using array formulas (also > non-array formulas) but i am facing problem with the names as VLOOKUP (and > match-index-large) is giving same names for different persons with same > salary. > > Kindly refer attached excel sheet in first post > > Regards > Vijay Yadav > > > > On Friday, 26 July 2013 14:17:30 UTC+5:30, 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 order and name in >> corresponding cell. >> >> A small example is given below - >> >> *DATA available-* >> Column A(name) Column B(salary) >> KISHAN >> 6 >> >> AJAY 24000 SANGEETA >> 6 >> >> >> *OUTPUT required with help of formulae -* >> Column C(name) Column D(salary) >> KISHAN >> 6 SANGEETA 6 AJAY 24000 >> Excel sheet is attached containing the data. >> Kindly help. >> >> Regards >> Vijay Yadav >> > -- > 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 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. sorting_columns_-_salary_and_name.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: SORTING DATA IN TWO COLUMNS (salary and name ) - sorting as per descending order of salary
Dear Kartik, Thanks for the suggestions. I do not want to sort list manually but need formuale to sort the above columns as there is some interlinking with other cells. Also i can sort the salary in descending order using array formulas (also non-array formulas) but i am facing problem with the names as VLOOKUP (and match-index-large) is giving same names for different persons with same salary. Kindly refer attached excel sheet in first post Regards Vijay Yadav On Friday, 26 July 2013 14:17:30 UTC+5:30, 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 order and name in > corresponding cell. > > A small example is given below - > > *DATA available-* > Column A(name) Column B(salary) > KISHAN > 6 > > AJAY 24000 SANGEETA > 6 > > > *OUTPUT required with help of formulae -* > Column C(name) Column D(salary) > KISHAN > 6 SANGEETA 6 AJAY 24000 > Excel sheet is attached containing the data. > Kindly help. > > Regards > Vijay Yadav > -- 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 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
