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.
|