Thread: How to get sequence number in the next column?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geniusideas geniusideas is offline
external usenet poster
  
Posts: 70
Default How to get sequence number in the next column?
Hi,

I have series of numbers in column A and I need the sequence number in
column B exclude empty cell. Example:
Column
A B (result)
15 2
20 4
18 3

14 1
80 6
50 5

Please help how to do using vba and without any sorting?


Reply With QuoteReply With Quote