| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Row Number of PREVIOUS Numeric Consecutive Duplicate in Col
Hi bj,
Think, I've got it: =LARGE(ROW(Data)*(Data=OFFSET(Data,1,0))*(Data<"" ),2) Cheers, Sam Sam wrote: Hi bj, Thank you very much for reply and assistance. Your Formula does the job. Great! =LARGE(ROW(C2:C100)*(C2:C100=C3:C101)*(C2:C101< ""),2) corrected typo in the last range =LARGE(ROW(C2:C100)*(C2:C100=C3:C101)*(C2:C100<" "),2) However, can you provide a version using the actual Dynamic Name "Data", rather than the column and row references. Further assistance appreciated. Cheers, Sam try =LARGE(ROW(C2:C100)*(C2:C100=C3:C101)*(C2:C101< ""),2) entered as an array control-shift-enter change the bottom if 100(101) is not enough to find the last instead of the penultimate one use 1 instead for the end number -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200708/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Formula based Cell Content Return Unique Consecutive Duplicate Values | Excel Worksheet Functions | |||
| Return Unique Consecutive Duplicate Values across Single Row | Excel Worksheet Functions | |||
| Return Row Number of LAST Numeric Consecutive Duplicate in Column | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Threaded Mode
