| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Unique Consecutive Duplicate Values across Single Row
Hi Domenic,
Thank you very much for your assistance. Does the job great. Brilliant! Cheers, Sam Domenic wrote: Assuming that A2:H8 contains the data, try the following... J2: =SUM(IF(FREQUENCY(IF(A2:H7=A3:H8,A2:H7),IF(A2:H7= A3:H8,A2:H7)),1)) ...confirmed with CONTROL+SHIFT+ENTER K2: leave empty L2, copied across: =IF(COLUMNS($L$2:L2)<=$J$2,MIN(IF(ISNA(MATCH($A$2 :$H$7,$K$2:K2,0)),IF($A$ 2:$H$7=$A$3:$H$8,$A$2:$H$7))),"") ...confirmed with CONTROL+SHIFT+ENTER Hope this helps! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200702/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| duplicate numbers in column a and diferent values in b | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Hybrid Mode
