-
Hi, I am the owner and main administrator of Styleforum. If you find the forum useful and fun, please help support it by buying through the posted links on the forum. Our main, very popular sales thread, where the latest and best sales are listed, are posted HERE
Purchases made through some of our links earns a commission for the forum and allows us to do the work of maintaining and improving it. Finally, thanks for being a part of this community. We realize that there are many choices today on the internet, and we have all of you to thank for making Styleforum the foremost destination for discussions of menswear. -
This site contains affiliate links for which Styleforum may be compensated.
-
STYLE. COMMUNITY. GREAT CLOTHING.
Bored of counting likes on social networks? At Styleforum, you’ll find rousing discussions that go beyond strings of emojis.
Click Here to join Styleforum's thousands of style enthusiasts today!
Styleforum is supported in part by commission earning affiliate links sitewide. Please support us by using them. You may learn more here.
The Excel Questions Thread
- Thread starter CunningSmeagol
- Start date
- Watchers 27
lbcgav
Senior Member
- Joined
- May 25, 2007
- Messages
- 437
- Reaction score
- 18
This will be an easy answer. (Need to improve Excel skills).Originally Posted by snuffy
I have 6 worksheets with only two columns each. Column A has a listing of names, Column B has a listing of percentages corresponding to the names.
I need to add up the listing of Names(A) with the percentages across the 6 worksheets. Essentially consolidating into one. Keep in mind some of the same names appear in the 6 sheets, with different percentages.
Any suggestions?
Thanks
This solution might not be the prettiest, but I'm pretty sure it would work: Copy the contents of the 6 worksheets onto one worksheet, then use a Pivot Table to sum up the values of the percentages for each name.
dsgNYC
Senior Member
- Joined
- Dec 9, 2008
- Messages
- 422
- Reaction score
- 1
Is there a way to have the height of a cell grow while keeping the width the same as you add more text to the cell? Something like an auto-grow function.Originally Posted by lbcgav
You can wrap the text (Format -> Cells -> check the Wrap Text box). This will also expand the size of the row for all cells in that row.
lbcgav
Senior Member
- Joined
- May 25, 2007
- Messages
- 437
- Reaction score
- 18
You can wrap the text (Format -> Cells -> check the Wrap Text box). This will also expand the size of the row for all cells in that row.Originally Posted by dsgNYC
I tried that and it didn't work, but it must have been the way I copied the contents from a word document and pasted them into Excel. I tried it again using paste special, text and now it works like a charm. Thanks.
dsgNYC
Senior Member
- Joined
- Dec 9, 2008
- Messages
- 422
- Reaction score
- 1
This solution might not be the prettiest, but I'm pretty sure it would work: Copy the contents of the 6 worksheets onto one worksheet, then use a Pivot Table to sum up the values of the percentages for each name.Originally Posted by lbcgav
This is part of the solution I was thinking about. You could write a macro that compiled all of your data from the 6 worksheets into a new worksheet, then run a PivotTable off of the data in that new worksheet.
calatrava
Active Member
- Joined
- Oct 10, 2006
- Messages
- 43
- Reaction score
- 0
Is there a way to get a formula to jump a certain defined amount of rows or columns?
Imagine that there is a chunk of data from a package that I copy and paste eight times. It takes up the same dimensions but alot of it is redundant. So I want to make the output smooth.
The function I imagine is like =B(8+10), such that I want it to skip down 10 rows.
Imagine that there is a chunk of data from a package that I copy and paste eight times. It takes up the same dimensions but alot of it is redundant. So I want to make the output smooth.
The function I imagine is like =B(8+10), such that I want it to skip down 10 rows.
MetroStyles
Stylish Dinosaur
- Joined
- May 4, 2006
- Messages
- 14,586
- Reaction score
- 30
Is there a way to get a formula to jump a certain defined amount of rows or columns?Originally Posted by calatrava
Imagine that there is a chunk of data from a package that I copy and paste eight times. It takes up the same dimensions but alot of it is redundant. So I want to make the output smooth.
The function I imagine is like =B(8+10), such that I want it to skip down 10 rows.
Google the "offset" function.
CunningSmeagol
Distinguished Member
- Joined
- Oct 15, 2006
- Messages
- 3,882
- Reaction score
- 20
Google the "offset" function.Originally Posted by MetroStyles
Offset is great. Let us know if that's what you needed.
CunningSmeagol
Distinguished Member
- Joined
- Oct 15, 2006
- Messages
- 3,882
- Reaction score
- 20
Hey guysOriginally Posted by snuffy
Any suggestions on how to improve excel skills. Do most of you learn through books? Seeing other peoples templates?
Your boss wants something done and you have to figure out a way to do it. A lot of times this means using the help index, asking on the internet, or reading a book. I got a lot of answers by reading the excel newsgroups, the microsoft support pages (where the real excel motherfuckers hang out), and John Walkenbach's books (there's one for formulas and one for VBA).
The 'easy' or 'elegant' solution will sometimes take longer to find than finishing the task manually, i.e. deleting all empty rows in a list of thousands, or summarizing the names of a 150 sheet workbook. Especially at first. The extra effort is almost always worth it, even if the same task does not come up again, because a) you will learn functions that can be applied to other tasks, and b) you will learn to quickly navigate the resources you can tap to find answers.
dsgNYC
Senior Member
- Joined
- Dec 9, 2008
- Messages
- 422
- Reaction score
- 1
Hey guysOriginally Posted by snuffy
Any suggestions on how to improve excel skills. Do most of you learn through books? Seeing other peoples templates?
I learned on the job a few years ago. I was semi-proficient in Excel when I started and I got a lot better just using it day in, day out. However, I learned the most by buying a book on VBA, frequenting sites like MrExcel.com, etc. For me, it wasn't so much the reading of the books that helped, but it was the working through examples and problems in the books that really helped.
FEATURED PRODUCTS
-
LuxeSwap Auction - De Bonne Facture Made France Plaid Boiled Robe Coat One of several De Bonne Facture robe coats featured this week, these pieces are being sold for our consignor in conjunction with our NMWA tradeup program - a forum first program that gets you several add ons for consigning and credits to shop at NMWA.
-
Nicks Boots - Wickett & Craig English Bridle Veg Tan Leather - $759
These boots are made from 6.5 oz Wickett & Craig English Bridle Leather. This tannery has been making leather the old fashioned way since 1867. Each side can take about six weeks to produce, making it a significantly longer production time than most leather on the market.
-
UNIFORM/LA - Relaxed Type III Trucker Jacket - $348 A versatile desert-kissed vintage indigo – the Relaxed Type III Trucker Jacket in Dune is made of premium 14-ounce Japanese 3x1 denim and features a beautiful vintage wash. Outfitted with a perfect relaxed fit and slightly cropped length, it's designed to replicate denim jackets that have been worn for years – fading with hard wear under the intense sun.
