dear all,
In attached xls, my data is in col C, D, E. col A is the ranges to be used and col B is the description for each range.
i request the following solutions:
a) group data in col D and col E as per ranges in col A, with a count in descending order,
b) subgroup data obtained under each year as in col C.
thanks
yours sincerely
Default extension for Ex2010 is xlsx not xls (Ex2003) so attach xlsx file (not zipped) or change Excel version in your profile to Excel 2003
dear all,
as advised, i am attaching the file for the problem again. thanks.
please attache xlsx fileDefault extension for Ex2010 is xlsx not xls (Ex2003) so attach xlsx file
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.
dear all,
i do not have excel 2010, so have saved it as 'excel workbook'- hope that will enable you to work on it? the extension does appear as xlsx. sorry attached twice!
1. Your profile says you do.i do not have excel 2010
2. You can't save in .xlsx format from earlier versions.
So which version DO you have?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Firstly, in CPT CODE column your data is mixed: text and number. You need re-check this and decide what is this really.
and maybe any small example of result? Please?
Last edited by sandy666; 08-12-2017 at 05:48 AM.
Dear sandy666,
pl find attached a sample result sheet. hope it helps.some of the CPT codes are alphanumeric - if it a problem - pl avoid/remove them and i shall count manually. otherwise they will be included in 'unknown and others'.
thanks.
no result workbook attached
sorry, now attached.
you don't add the data in your file, so this is no way to make a pivot table.
Not just add the manualy answer, also add the data in your file.
Easier for me was to use formula(s) than PT (especially for Ex 2003 ?)
I didn't see description about last column (second vertical Total) so I did what I did
edit: little correction - file updated
Last edited by sandy666; 08-12-2017 at 09:58 AM.
Thanks Sandy for the eye-opener.
With a table to find the values (with VLookup).
After that a pivot table.
See the attached file.
oeldere
I don't remember too much from Ex2003 especially about calculated fields & items so I choose formulas and no-helper columns
but thanks to show another way
my first thought was PT/PQ/Unpivot and so on... but Ex2003 has no these possibilities
Last edited by sandy666; 08-12-2017 at 10:10 AM.
@Sandy666
Excel 2003 has PT
Hahaha, I know, but I don't remeber all features there (maybe the same like in 2016, maybe not) but for sure Ex2003 doesn't work with PowerPivot and PowerQuery
Ex2003 is like Methuselah
Last edited by sandy666; 08-12-2017 at 10:33 AM.
thanks a lot.
If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks