Web Development

Ask something
Discussion Locked

excel spreadsheet help with fomula

0 helpful
4 replies

by ffontan1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

On my excel spreadsheet I've got a column labeled 1 through 100 (Item#'s) and a
column with (dates).
Further over on the same spreadsheet I have the same columns located in the
middle and at the end of the spreadsheet going from left to right. Iwant to be able to type in the item # and the Date only once and have it appear in all three columns for each. Can you give me a fomula for doing this and tell me how to set it up on an existing spreadsheet.

4 replies

by teddybear99

if i understand you correctly, all you need to do is set the 2nd & 3rd sets of columns equal to the 1st set.

if column A is 1 - 100 & column B is your dates ... then you have columns N & O and columns AC & AD that you want to hold the same information... in cell N1 type =A1 and fill down & fill right all 100 rows & for column O ... then in cell AC you can either type =A1 or =N1 and then fill down & right for all 100 rows & for column AD.

if this confused you, feel free to email me.

Aimee

This discussion is closed to new replies.