Excel Trick

Easily compare numbers in Microsoft Excel.

Category:

People & Blogs

Tags:

• numbers
• compare
• analyze
• how-to
• howto
• easy
• tutorial
• excel
• microsoft
• bar
• chart

[helmet22fc]

how do you sort them?

[Silverado31]

@helmet22fc Click the top left box, to the left of A and above row 1 to select all cells. Then data - sort, and sort by the value.

[flixmsncom]

Seems like Adam is getting fired

[Silverado31]

@excaliber2023 Sure, but that would take a lot more time wouldn't it? The premise is that this trick is quick.

[xclmedia]

Excel trick is useful

[goodgradesfast]

I also teach this in my computer and study skills course. Students really like it. You are the only other person I've seen that knows this neat trick.

[fwidjaja1]

Thank you for the video. It's really usefull. It's nice to have the graph (the multiplied "I") directly side by side with the data at several situation (instead of making the diagram from excel).

[NXTWolf]

It tells me at my excel Error 501

[myutoobvids]

Brilliant!!!!!!! Thanks

[37no37]

cell-01.02.03.04.05.06.07.08.0­9.10.11.12.13.14.15.16.17.18.

-----17.19.23.23.29.29.37.19.1­9.23.29.37.41.19.19.23.23.29

You can see number 23 is in third place and four, 10,16,17, I would like to generate a list of positions for any number I choose, in this case for 23 the list will be 3,4,10,16,17, how is possible to do in excel 2003.

[togair9]

@excaliber2023l- lol ur right- loved the trick but i just thought about it - the charts would make more sense right and look more professional in a professional settting lol... but gotta give it to him, that was a cool trick if the charts did not exist.

[37no37]

I really apreciate if you can tell how using your example, I mean the same list of number, I need to substract each one among them and see the result in another column how can I do that