| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unwanted Repeats
I am getting repeats when there should not be any. Here are the formulas and
below is a portion of the worksheet. You can see hhow the Section and Work Order are repeating. It should only show a one time entry. =IF(ISERROR(SMALL(Overall!$AP:$AP,ROWS(A27:$A$29)) ),"",INDEX(Overall!AI:AI,MATCH(SMALL(Overall!$AP:$ AP,ROWS(A27:$A$29)),Overall!$AP:$AP,0))) =IF(ISNA(MATCH(A2,Overall!AI:AI,0)),"",INDEX(Overa ll!A:A,MATCH(A2,Overall!AI:AI,0))) Section Work Order 00910 OK00021 20380 OK00017 29025 OK00002 20380 OK00017 00910 OK00021 13301 OK00022 20380 OK00017 13001 OK00008 13001 OK00008 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes | Excel Discussion (Misc queries) | |||
| Deleting unwanted Cells | Excel Discussion (Misc queries) | |||
| Deselecting unwanted cells | New Users to Excel | |||
| Unwanted blank line in cell with wrapped text | Excel Discussion (Misc queries) | |||
| Count repeats | Excel Worksheet Functions | |||
Threaded Mode
