Mr Excel & excelisfun Trick 10: Turn Column / Row Upside Dow

[donksyjohn]

My favorite part was when he said "Im just gonna close parentheses"

Awesome video. You guys awesome.

[ExcelIsFun]

@donksyjohn , I am glad you liked it!

[erkarofl]

OMG. THANK YOU SO MUCH. I helped me a lot to do my LAB REPORT

[ExcelIsFun]

I am glad that it helped!

[BLACKxGALLAGHER]

THank YOU! this took me forever

[ExcelIsFun]

You are welcome!

[norderha]

great!

[sachincomments]

Thanks a lot for this video..Extremely useful..

[ExcelIsFun]

Dear sachincomments,

I am glad that you liked it!

--excelisfun

[ExcelIsFun]

Example of when you would use this:

Sometimes you have tables with biggest to smallest (such as a grading scale or sample data) that you must display biggest to smallest, but you need the same table for VLOOKUP that must be sorted smallest to biggest.

[mesq007]

Dear Mike,

May I suggest another challenge: how can I sort a range using formula?

Thanks,

Marco

[ExcelIsFun]

Dear mesq007,

Yes, I will pass it on to Bill and then we see what we can do!!

--excelisfun

[ExcelIsFun]

Dear mesq007,

Do you mean numbers or words?

--excelisfun

[mesq007]

It could be numbers and maybe using a dinamic range table, that would be great...

[ExcelIsFun]

Dear mesq007,

OK - numbers sorted and also formula must be dynamic!

--excelisfun

[moazzamca1]

This video is coool!!