Pages

Search

Excel Help Forum - Excel General: Matching a cell against a pre-defined table and returning an adjacent cell as...

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
Matching a cell against a pre-defined table and returning an adjacent cell as a result
Hi, Apologies in advance as i am sure the answer to my problem is on here already but i have tried a search and cannot find it. See spreadsheet attached. In column C, i have a list of countries in random order. In Columns A and B, i have an alphabetical list of countries and country codes...

Excel Help Forum - Excel General: Transfering formulas from one worksheet to another???

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
Transfering formulas from one worksheet to another???
I have created a large set of forumlas in a a worksheet. They were created right next to the set of data that I was using for my formulas so that I could refrence it. Now that my set of formulas is quite large, I want to MOVE them to a seperate worksheet so that I can set it up nicely for printing,...

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 ...
Subscribe to: Posts (Atom)