Hy to everybody,
I please you need help on this problem: i have 6 items that, random, get value 1 and i want to know, on every row, the last 3 divers items that has the 1 value. Hope to be clear i attach an example. Thanks in advance.
Regards
Davide
Hy to everybody,
I please you need help on this problem: i have 6 items that, random, get value 1 and i want to know, on every row, the last 3 divers items that has the 1 value. Hope to be clear i attach an example. Thanks in advance.
Regards
Davide
Given the need for each value to also be unique I think a native function will prove expensive (& ugly) ... are you open to a UDF ? (ie VBA Custom Function)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Not very elegant but perhaps along the lines of:
Above stored in a Standard Module and called from cells perPlease Login or Register to view this content.
You should find that you can alter the headers etc and the UDF would reflect immediately.K5: =LAST3UNIQUE($A$1:$F$1,$A$2:$F5,$J5:J5)
copied down and across - eg I was using replica matrix K5:M33
Whre first parameter specifies headers, second values to be used up to that point, third specifies preceding results
NOTE: the above requires you have a blank column to left of first result column - ie J is blank
(this is to validate that current result is unique for the row)
Last edited by DonkeyOte; 10-06-2009 at 12:30 PM.
Great DonkeyOte! It works!
Thank you very much
Davide
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks