Pages

Search

Excel Help Forum - Excel Charting & Pivots: Connecting Pivot Table To Source Data From A Different Workbook

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Connecting Pivot Table To Source Data From A Different Workbook
Hi Excel Help Forum, I am trying to figure out how to connect to the source data of one excel workbook & create a pivot table in a new workbook. Ideally, I would like to keep the source data in one file & then create multiple dashboards on separate workbooks all connected to that Master Source...

Excel Help Forum - Excel General: Vlookup/sumif that picks up all values in a list

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Vlookup/sumif that picks up all values in a list
Hi, I am sure a similar question has been asked before but I cannot find anything quite right. I basically need to do a sumif(/vlookup?) that will let me look up an item code number from a spreadsheet, then instead of just returning one criteria it will look up a list of criteria and return...

Excel Help Forum - Excel Charting & Pivots: How do i show repeated values (Pivot table)

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How do i show repeated values (Pivot table)
I have a pivot table that has a list of people that have a list of figures associated with them in different groups. Person 1 has 0.5 in Group 1 and 0.5 in Group 2. The pivot table shows this as 0.5 in Group 1 and then it does not show any value for Group 2, with an assumed "Same as above"......

Excel Help Forum - Excel General: Shared workbook on a share drive

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Shared workbook on a share drive
I am having problems with a shared workbook on a shared drive, at least 5 people have access to file, some are not saving when they update and others go into sheet and update what has already been updated and then save creating duplicate work. Is there a better way or a way in the shared...

Excel Help Forum - Excel Charting & Pivots: Display values in horizontal axis in groups

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Display values in horizontal axis in groups
I would like to group the values on the horizontal axis into groups. The values of in hrs and the graph can get pretty wide if there are lots of hours. I was able to get the axis to change but wanted a specific range that is more customize. For example, instead of this range: 0 5 10 ...

Excel Help Forum - Excel General: How to change cell entry over many files

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to change cell entry over many files
Hi I have a spreadsheet that I use as a costing template. I have saved that workbook many times as a new file name - ie " save as ". I now have realised that I have made an error in a few cells or I need to add a new cell entry - ie: either spelling, or formula , or format. Is there a way that...

Excel Help Forum - Excel General: Concatenate Help!

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Concatenate Help!
I am trying to concatenate 24 cells of data so that I can combine them into one cell and then paste them into MS Word. I will do some qualitatative anaysis on them once in word. However When I use the concatenate function it cuts off the last few cells. I have also Tried using the & Function....
Subscribe to: Posts (Atom)