Web Development

General discussion

Gravatar
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.

4 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| 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
4 total posts (Page 1 of 1)  

Start or search

Related Forums