View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Merge data rows at fixed ratio

Is this calculating the ratio of input file sizes (rows)?
The suggestion doesn't calculate the ratio -- the ratio is taken as a known
param. It melds the rows from the 2 source sheets in exactly the manner
desired in "C", viz.: the first 2 rows from "A", followed by the first row
from "B", then the 3rd & 4th rows from "A", followed by the 2nd row from
"B", and so on ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"AirBoss" wrote in message
oups.com...
Aha. I'll see if I can understand what's going on and why the earlier
try resulted in circular calc at C:B1.

Is this calculating the ratio of input file sizes (rows)?

Thanks, Max.