Complex fill problem. I think.

Question

Level 1

0 points

Complex fill problem. I think.

I'm playing a game. It's fun. So I like to chart where planets are in each solar system using Numbers 10 or whatever the latest one is. I have a buddy helping me by charting some of the solar systems as well.

Here's what he gave me:

Is there a way to fill in the blank rows for the System to make it look like:

I've highlighted the rows that need to be filled. System/Planet are filled out for the FIRST System/Planet but not for the remaining 14 planets.

Anyhow, possible?

OS X Mavericks (10.9.2)

Posted on Apr 14, 2014 11:16 AM

Reply

Answer 1

Best reply

Wayne Contello

Level 7

26,529 points

Apr 14, 2014 11:35 AM in response to AaronTB

Aaron,

You can do something like this:

starting from the very top of the table...

make the first row a header.

B2=IF(MOD(ROW()−2, 16)=0, "System", IF(MOD(ROW()−2, 16)=1,MAX($B$1:B1)+1,B1))

this is shothand for select cell B2, then type (or copy and paste from here) the formula:

=IF(MOD(ROW()−2, 16)=0, "System", IF(MOD(ROW()−2, 16)=1,MAX($B$1:B1)+1,B1))

select cell B2, copy

select column B by clicking the column header (the "B" at the very top), no unselect the first cell in the column by holding the command key then single click cell B1

now paste. That should fill the whole column automatically

Reply