View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
sunny sunny is offline
external usenet poster
 
Posts: 1
Default Insert Row when zero or Positive value

sorry if u get u reply me back..

FIRSTROUNDKO via OfficeKB.com wrote:

Hi,

I have sorted a collumn in ascending value from negative to positive, I want
to insert a row when the change in the value is zero or greater. i.e

-2
-1
0
1

Becomes

-2
-1

0
1

The Collumn changes in length and sometimes there maybe no negative numbers
and sometimes there may be no positve numbers

Can sombody Please help me Thanks in advance

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1