Thread: Excel Question
View Single Post
  #2  
Old 08-24-2005, 02:36 PM
IHateKeithSmart IHateKeithSmart is offline
Senior Member
 
Join Date: Mar 2005
Location: check folding the nuts
Posts: 182
Default Re: Excel Question

War:

Will it always be "some unknown # of cells with numbers followed by some unknown # of cells that are blank" or will they be interspersed (e.g. 3 cells with numbers, 3 with blanks, 2 with numbers, 1 blank, etc.)?

The latter will be more difficult, but the former should be relatively simple. The isblank(<cell&gt and isnumber(<cell&gt functions look for blanks and numbers, respectively.
Reply With Quote