LinkBack URL
About LinkBacks
Guys,
I have a table containing the data of audits of companies by Rating Agencies (in last 03 years). My boss asks summaries of these audits. I attached the table and the summery report format.
Can u guys help me to do this?
Book1.xlsx
Guys,
I have a table containing the data of audits of companies by Rating Agencies (in last 03 years). My boss asks summaries of these audits. I attached the table and the summery report format.
Can u guys help me to do this?
Book1.xlsx
If you re-arange your data in a verticaly way, you can use a pivot table for analyze your data.
See the attached file.
Please reply.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
@Rasika99
Did you read the forumrules, especialy the one's about crossposting?
http://www.mrexcel.com/forum/excel-q...ata-table.html
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
@ sktneer & oeldere,
I'm really sorry for what i did. It was because i was not much aware of the rules and the reasons behind those. Now i understand and i will post the links to other posts.
http://www.excelguru.ca/forums/showt...4806#post14806
http://www.mrexcel.com/forum/excel-q...ml#post3934875
http://excelexperts.com/extract-data-table
OK. That's fine. Please edit your first post and include these links there also.
Try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter which you normally used in case of a regular excel formula.
On Summary Sheet
In D9
Please Login or Register to view this content.
Forgot to mention that formula in D9 is copied across and down. i.e. you need only one formula to populate the table based on the company name.
Thanks sktneer. Its working!
I have another small problem. If I add another column called "Overall rating" to the table, how should this formula to be changed? I have attached edited excel file. can u help me again?
Book1_RASIKA99 NEW.xlsm
For that you don't need to make any change in the formula. You just need to copy the formula (the formula in D9) down to the row 12 and across. That's it.
See the attached. Are you getting the correct desired output?
I think my problem is solved. Thanks a lot sktneer.
You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks