View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
geotso geotso is offline
external usenet poster
 
Posts: 10
Default Serial number of a list

In a list like this:

100
200
150
120
250

how to get the serial numbers in the next cells? Like this:

100 1
200 4
150 3
120 2
250 5

thanks in advance

--
geotso
---- ---- --- -- - -
Please, remove hyphens to contact me
---- ---- --- -- - -