View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default Create a new set of data from 2 data sets

On Wed, 28 Aug 2013 10:30:53 -0400, GS wrote:

In case anyone's interested in doing similar in XL2003...

In G2: Replace
=IFERROR(INDEX(Country,INT((ROW()-2)/COUNTA(Stock)+1)),"")

with


=IF(ISERROR(INDEX(Country,INT((ROW()-2)/COUNTA(Stock)+1))),"",INDEX(Country,INT((ROW()-2)/COUNTA(Stock)+1)))

--
Garry


Thanks, Garry.
I don't even think about XL2003 or earlier versions anymore, unless it's on the Microsoft Answers forum where the version is often cited.