https://www.extendoffice.com/documents/excel/895-excel-sort-dynamic-data.html#a
I've been trying to accomplish something in Excel for about a week. After many Google searches, I was led to the link shown above. Although the type of data shown in this link is different, it is essentially showing exactly what I'm trying to accomplish.
This article seems to be written in slightly broken english, and I'm not sure I'm following it correctly. When I duplicate it, the "=iferror...." formula shown in step 5 does not work for me. Can anyone provide assistance, please?
What I'm trying to accomplish:
1. A small table in columns A,B, and C where I can enter data.
2. The individual rows of that table will be copied and sorted into rows E,F, and G, based on the value shown in column C.
3. The ability to sort must be able to accommodate duplicate numbers in column C. In other words, per last screenshot in the link above, columns E, F, and G should be able to handle duplicated numbers in the following fashion:
E.........F..............G
1.....Pen............200
2.....Ballpen.......200
3.....Pencil..........78
4.....Notebook.....55
5.....Ink...............5
Thanks for your time
I've been trying to accomplish something in Excel for about a week. After many Google searches, I was led to the link shown above. Although the type of data shown in this link is different, it is essentially showing exactly what I'm trying to accomplish.
This article seems to be written in slightly broken english, and I'm not sure I'm following it correctly. When I duplicate it, the "=iferror...." formula shown in step 5 does not work for me. Can anyone provide assistance, please?
What I'm trying to accomplish:
1. A small table in columns A,B, and C where I can enter data.
2. The individual rows of that table will be copied and sorted into rows E,F, and G, based on the value shown in column C.
3. The ability to sort must be able to accommodate duplicate numbers in column C. In other words, per last screenshot in the link above, columns E, F, and G should be able to handle duplicated numbers in the following fashion:
E.........F..............G
1.....Pen............200
2.....Ballpen.......200
3.....Pencil..........78
4.....Notebook.....55
5.....Ink...............5
Thanks for your time