Pages

Search

Excel Help Forum - Excel General: How to retrieve particular data from web into excel

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 retrieve particular data from web into excel
Hi friends, I need your help on how to retrieve data from a particular location in a web page. Please note that by data i mean a single line not a table. I am using Excel 2007 version. Below is the link from which i need the data and also i am attaching the image of the data. I have highlighted...

Excel Help Forum - Excel Charting & Pivots: Adding a % to aggregated data in pivot table based on row

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
Adding a % to aggregated data in pivot table based on row
I have an Excel 2007 worksheet which has scores from a test for a number of candidates. The headings are: Area, QuestionNumber, QuestionSubNumber, Comments, AvailablePoints, Candidate1, Candidate2, Candidate3 Each Area can have one or more question and each question can have one or more...

Excel Help Forum - Excel General: Merging/Averaging a List of Rankings

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
Merging/Averaging a List of Rankings
Hey guys, glad I found this resource. I'm currently working on an assignment where I have 2 lists, each ranking websites based on traffic. The first list is very basic has two columns: ranking and domain name. The second is the same, but with slightly different rankings and a few domain names that...

Excel IT Pro Discussions Forum: The differences between vba of office 2007 and vba of 2010

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
The differences between vba of office 2007 and vba of 2010

Here's the deal.

My company decided to update the Office from 2007 to 2010. We use Excel mostly to processing economic data, and develop some vba program to do that. The problem is we have already developed a lot of vba program, and we are not so sure wether this updating thing will destroy some of them.

So now I need a list of the differences between 2007 version and 2010 version. This list should include every detail of both programing changes and application changes.

I have been looking for this kind of documentations on official website for more than a week, and I only get some general descriptions at present.

Is there anybody has the documentations like this, or knows the url of web pages contain this kind of information? Please share them.

Thanks

Excel Help Forum - Excel General: Need to distribute data from one worksheet to multiple spreadsheets.

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
Need to distribute data from one worksheet to multiple spreadsheets.
Looking for help on a sport's team payment sheet where the first tab is a running list of all charges and payments and each subsequent tab are the individual player's account balance. I am using only the first tab to input data and the subsequent tabs to contain formulas. How do I have the tabs...

Excel IT Pro Discussions Forum: PivotTable Date Handling in Excel 2013

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
PivotTable Date Handling in Excel 2013

Just testing out porting some 2010 reports into 2013 and found that Excel functionality has changed just enough to break them.  Curious if someone might point out a solution:

1) Report is pulling from a SQL database and/or OData feed.

2) I have projects along the Y axis.

3) I have standard stage gates along the X axis.

4) Each cell should depict the date upon which each project will hit the stage gate.

In 2010, I simply set up the PivotTable and then set the cells to display the "Max" value of the date.  After formatting the cell to appear as a date, it worked just fine.

In 2013, I get a message that I can't use the Max calculation with date fields in the pivot table.  Effectively, this breaks the report.  Is there an easy fix to this or do I need to break out some sort of combination of v and hlookups?

Thanks in advance....

Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

Excel Help Forum - Excel General: Listing unique terms from combined strings

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
Listing unique terms from combined strings
Hi, I have string data in a column that I would like to create a list of just the unique terms. Each unique term string in the cell is separated by / . See below for a partial list. Each of these strings is entirely in one cell. I do not need the number of times or in what combinations the terms...
Subscribe to: Posts (Atom)