Hi nice to see you again guys, please need assistance again for the problem. The explanation and the desired results is in the file
thank you
Hi nice to see you again guys, please need assistance again for the problem. The explanation and the desired results is in the file
thank you
Administrative Note:
Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.
With this in mind, please update your profile to something more precise than Earth (something such as UK, Europe, USA, UAE, etc. will suffice).
Thank you for helping us to help you.
Administrative Note:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand, and I look forward to a clear explanation of what your requirements are in your reply to this post.
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.
Im updating my profile thank you
E3=IFERROR(INDEX(A$3:A$14,SMALL(IF(FREQUENCY(IF(A$3:A$14<>"",MATCH($A$3:$A$14&$B$3:$B$14,$A$3:$A$14&$B$3:$B$14,0)),ROW(A$3:A$14)-ROW($A$3)+1),ROW(A$3:A$14)-ROW(A$3)+1),ROWS($A$3:A3))),"")
Control+shift +enter
copy across and down
custom format column F d-mmm
Last edited by CARACALLA; 07-27-2020 at 04:20 AM.
Try this in E3:
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).Please Login or Register to view this content.
Drag down and accross
Quang PT
Thank you @CARACALLA and @bebo021999 the formula works, thank you again
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks