| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Unique Duplicate Numeric Values across Single Row
Hi Ron,
Thank you very much for your assistance. Laurent Longre's Excellent MoreFunc add-in and your Great Array Formula provides the required results. Very much appreciated! Cheers, Sam Ron Rosenfeld wrote: Here's one method, assuming you have fewer than 256 entries. Download and install Longre's free morefunc.xll add-in from http://xcell05.free.fr NAME your data range: rng Enter this **array** formula in some cell. Copy/drag to the right at least as far as required. (It will return blanks if you copy too far, so no harm). To enter an array formula, after entering the formula, hold down <ctrl<shift while hitting <enter. Excel will place braces {...} around the formula: =INDEX(UNIQUEVALUES((IF(COUNTIF(rng,rng)1,rng)), 1), COLUMNS($A:A)+NOT(ISNUMBER(UNIQUEVALUES(( IF(COUNTIF(rng,rng)1,rng)),1)))) --ron -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200701/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
| Return Row Number of LAST Numeric Consecutive Duplicate in Column | Excel Worksheet Functions | |||
| Match 3 Criteria and Return Lowest Numeric Value | Excel Worksheet Functions | |||
| Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Threaded Mode
