Excel spreadsheet templates... help!
10 posts
• Page 1 of 1
by Bobby » Tue Jun 26, 2007 11:27 am
Baffled, eh?
Why would you put count totals in the same column as the label? Wouldn't it
make sense to put it in its own column? I'd break that into multiple columns -
count, size, and style (8, 5", Recessed), and then merge them all into a label
column.
Data columns are C, D, E and F.
The A column is a formula: =C2&" - "&D2&""" "&E2&" "&F2
The ampersand is excel's text concatenation operator. To add in constants,
put them in quotes (like the dash and spaces.) Copy the formula down your
data set and you're done. This way you can easily sort the data by individual
column, but still have a label formatted the way you want it.
This calls for a glass of Paul Masson Chablis. It's light, it's crisp - delicious!
-b
Why would you put count totals in the same column as the label? Wouldn't it
make sense to put it in its own column? I'd break that into multiple columns -
count, size, and style (8, 5", Recessed), and then merge them all into a label
column.
Data columns are C, D, E and F.
The A column is a formula: =C2&" - "&D2&""" "&E2&" "&F2
The ampersand is excel's text concatenation operator. To add in constants,
put them in quotes (like the dash and spaces.) Copy the formula down your
data set and you're done. This way you can easily sort the data by individual
column, but still have a label formatted the way you want it.
This calls for a glass of Paul Masson Chablis. It's light, it's crisp - delicious!
-b
Last edited by Bobby on Tue Jun 26, 2007 7:20 pm, edited 1 time in total.
Nobody expects the Spanish Inquisition!- Village Idiot
-
- Posts: 457
- Joined: Thu Jun 16, 2005 7:44 pm
- Location: Calgary, AB.
by Village Idiot » Tue Jun 26, 2007 7:14 pm
Between anarchy and calm, there is a door marked supplies.
10 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 24 guests