Hello,
I'm wondering how I can convert data in the form;
A B B B C D E F F
1 2 2 2 3 6 5 4 3
to data in the form;
A B C D E F
1 2 3 6 5 3
I'm not really able to use the =frequency function, I'm not too sure how to use bin_arrays without excluding data, and I'd prefer to do it in a more intuitive method (logic functions perhaps). I'd also like to keep only the first instance of the variable. Sorry if I'm being a little ambigious
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Also, please clarify also if you are open to using VBA or are looking exclusively for formula based approaches.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks