I am working on a spreadsheet where I want to use data to create a table. The data is in the format where column A is the first day of the week. Column B is Friday's business, column C is Saturday's busines, etc. And the cell immediately under each day's total is the percentage of the total week.
Row 2 would be Date, $Fri, $Sat, $Sun, $Mon, $Tue, $Wed, $Thu, $Total
Row 3 would be Blank, %Fri, %Sat, %Sun, %Mon, %Tue, %Wed, %Thu
Row 4 would be blank and then Row 5 would repeat the same pattern.
I want to create a chart that would contain just the percentages and the dates.
At this point the only way I can figure to do this is type b$3 (or whatever the row number is) into each cell for Friday and then copy that cell to the rest of the week. There has to be a faster way.
2007-02-03
12:09:26
·
4 answers
·
asked by
Justin H
7