In this video we will see how to get Excel automatically sort data in a column. We will show two different methods of achieving this.
1) Sorting data using helper column
2) Sorting data using table
In this video we also use the Index/Match combination. VLookup only looks to the right where as Index/Match can also look to the left.
If you liked this video then please give it a thumbs up and if you would like to see more videos like this then please subscribe.