excel uses macros to arrange the number of a column, how to write the program

You can do this by recording a macro.

excel2007 can be sorted by color, no need to write macros, 2003 does not have this function!

Excel2007 can be sorted by color, no need to write macros,

Record macros, directly manipulate the sorting, and the generated ** is it.

Try if the attachment meets your requirements.

Hope it helps.

Just enter the formula in C1 and drop it down.

vlookup(a1,$d$1:$e$8,2,0)

According to the figure, C12 input = VlookUp(A12,$d$2:$e$8,2,0), and pulling down to C18 is the answer.

With the vlookup function, enter the formula: in cell C2

vlookup(a2,d:e,2,false)

There's a filter sorting function, you try to do it.

This is the formula for picking 5 numbers at random from all of them:

index($a$1:$e$7,choose(rand()*7+1,1,2,3,4,5,6,7),choose(int(rand()*10/2)+1,1,2,3,4,5))

Hope it helps

Save the file as a loading macro (..)xla) file, and then open xecel, dot"tools"->"Load the macro"->"Browse"to find the one you saved. XLA file, dot"OK".

Suppose the data is in column A1:A100, enter 1 in B1 and enter 2 in B2, select B1 and B2 to fill down to B100, then select B and A, sort B in descending order, and finally delete B column.

Backwards and forwards should not be lined up, and they should be reversed

You insert a column of serial numbers.

Then select all the worksheets.

Use the "Sort function" to select the column of the serial number and use "Reverse Order".

Excel comes with a sorting tool, data-> sorting.