$$Excel-Macros$$ Re: How to slove Serial numbers problem

2009-10-02 Thread Sandeep
17 AM Subject: $$Excel-Macros$$ Re: How to slove Serial numbers problem Hi, One way could be to use Rand or Randbetween function, but both of them will not produce consecutive numbers. I have given a try in the attached workbook which is using the function ROW to get +1, +2, +3 etc adde

$$Excel-Macros$$ Re: How to slove Serial numbers problem

2009-10-01 Thread Dilip Pandey
Hi, One way could be to use Rand or Randbetween function, but both of them will not produce consecutive numbers. I have given a try in the attached workbook which is using the function ROW to get +1, +2, +3 etc added, if dragged down till the last desired number and after that a conditional forma