Web Development

General discussion

Gravatar
0 Votes
Locked

excel spreadsheet help with fomula

By ffontan1 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

excel spreadsheet help with fomula

by teddybear99 In reply to excel spreadsheet help wi ...

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

gravatar
Collapse -

excel spreadsheet help with fomula

by ffontan1 In reply to excel spreadsheet help wi ...

Poster rated this answer

gravatar
Collapse -

excel spreadsheet help with fomula

by ffontan1 In reply to excel spreadsheet help wi ...

Point value changed by question poster.

gravatar
Collapse -

excel spreadsheet help with fomula

by ffontan1 In reply to excel spreadsheet help wi ...

This question was closed by the author

Back to Web Development Forum

Start or search

Related Discussions

Related Forums