View Single Post
 
Old 09-10-2016, 06:32 AM
BadlySpelledBuoy BadlySpelledBuoy is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Sep 2016
Posts: 1
BadlySpelledBuoy is on a distinguished road
Default

The formula in column E on the MealChoices sheet has an incrementing number in the ROW part at the end of the formula. When you get to row 23, for some reason this incrementing stops and continues again at row 28. This is what is causing the duplication.

Select cell E2 and double click the fill handle (bottom right hand of the cell) to copy the formula down again. This will solve the issue.

BSB
Reply With Quote