Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

COMPARING NUMBERS IN EXCEL

Comment:

I would like to compare four numbers in an excel spreadsheet and would like to assign positions to the numbers based on the numbers. The highest being first and the lowest being fourth. I do not know visual basic so is there someway in excel that this can be achieved without using visual basic.

Name: Jennifer
Date: May 16, 2002 at 06:05:54 Pacific

Reply:

The only option I know of is writing a macro to do this, and Excel Macros use VB. Give it a try though. :)

0

Name: Glen
Date: May 16, 2002 at 08:41:20 Pacific

Reply:

WTF? This is a Windows 2000 support forum, not an Excel forum. Please direct your questions to the appropriate location.

0

Reply:

Coleen You can use Data - Sort if you just want the numbers in order. If you want them to appear in other cells also click on the other cell and Type = followed by the cell reference you are copying.

0

datafly 128/b

IE6 and W2000 SP2 crash

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: This may sound like a dumb question. I am trying to compare four numbers in an excel spreadsheet and trying to associate positions to them such as first, second, third and fourth. However I can't seem...

Summary: I'm building a test matrix in Excel and for some reason the macro that I am writing is having a problem reading the cells in the range that I pass to the functions. The test matrix is a workbook compr...

Summary: bring up your list in ms access then there is an option under the tools menu to "analyze data using Excel". Select this option. Once this data is in Excel, select the column your names are in, go to...