auto fill a column

Timbz 

I have a question that is very hard to explain in writing.

Is there any way to ask someone a quick question?

I am having a hard time reconciling those two statements. How can you turn something hard to explain into a quick question??

What you can do, that would make the explanation less arduous perhaps, is to post a copy of the spreadsheet in question on OneDrive or the equivalent, pasting a link here that grants access. Then, with that as part of the picture, your explanation would have a visual aid and might not be so hard.

OR, if there is no spreadsheet yet, take a pass at that "hard to describe" question by breaking things down into these parts:

• the situation (challenge/business need/whatever)
• the raw data you'd be working with (let's call it input data)
• the result or output desired...what you want that raw input data turned into

Leave "How you want to get there"--the process or the calculation--to us.

Give it a try.