Pages

Search

Excel Help Forum - Excel Charting & Pivots: Software for FAST plotting charts from dynamic excel data?

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
Software for FAST plotting charts from dynamic excel data?
Hi! I am looking for a software that can take dynamically updating data in excel worksheet every second and plot graphs from it. Here is my working conditions: 1. Data supplied from the monitoring instruments is updated dynamically for about 300 (unique IDs) x5 (5 criteria for of the 300...

Excel Help Forum - Excel General: Your expert help needed please...

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
Your expert help needed please...
Hi I really need your help! I have an excel document containing contact information for businesses including web addresses. I have been working on the sheet and now when I try to work on it I get a pop up dialogue box, windows log in; please enter log in credentials for truffaut.com ...

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"......