Pages

Search

Excel Help Forum - Excel General: Complex Batching Problem

Feed2Mail notification - new post on Excel Help Forum - Excel General
Complex Batching Problem
I have a file a 60k excel spreadsheets and I need to figure out a way (if possible) to pull them into a single excel worksheet. I know if push comes to shove I can code this in C# but my company isn't wanting to give me access to visual studio thanks -Jacob

Excel Help Forum - Excel Charting & Pivots: Calculating Weighted Averages in Pivot Tables

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Calculating Weighted Averages in Pivot Tables
Does anyone know the best way to have a pivot table return a weighted average instead of the standard average? Within the attached spreadsheet I have a pivot tab. I'd like to create a weighted average for the APR. Currently it shows 4.62%. On the data tab I calulated the weighted average at...

Excel Help Forum - Excel Programming / VBA / Macros: Filter one column with multiple checkboxes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Filter one column with multiple checkboxes
Hi excel guru's!! I am in need of some VBA coding that will allow me to filter a specific column with multiple check boxes. For example, I have a worksheet with over 100 rows of data and each row in column B has a month. Can I have check boxes for each month and filter my data based on the...

Excel Help Forum - Excel General: Excel 2010 Slicers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Excel 2010 Slicers
I have 3 different pivot tables on the same sheet. It's an employee commission sheet. The employee sold policies for 3 different products. On the sheet, it has his/her break down laid out in 3 pivot tables. Each different pivot table is for a separate product, and all 3 pivots are based off 3...

Excel IT Pro Discussions Forum: Excel using Processor but not RAM

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel using Processor but not RAM

When we run Excel 2010 x64 (large calculation) it consumes all of the processor 100% but less than 1% of the ram. How can I force (or firmly request) excel to utilize all of the RAM (24GB) that the machine has available. 

If I add another processor - what settings can I manipulate to let excel utilize multi-core processing?

Windows 7 PRO 64bit, 

Thanks,

SJ

Excel Help Forum - Excel Programming / VBA / Macros: Add the similar ID

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Add the similar ID
Hello Everybody I want to add the similar IDs, for the sake of example workbook is attached with this thread.

Excel Help Forum - Excel General: Changing Axis

Feed2Mail notification - new post on Excel Help Forum - Excel General
Changing Axis
If I have information going along the x axis, how can I switch it all to go the other way along the y axis?
Subscribe to: Posts (Atom)