Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spread sheet with 4 columns and 900 rows I am trying to identify the
rows that do not contain a duplicate amount. For example I have rows with 100 100 97 97 96 96 98 101 I am trying to pull the list of 98 and 101. The spreadsheet is a list of invoices paid vs invoices unpaid if it is paid there are two rows with the same data if it is unpaid there is only one row. I am trying to find the unpaid invoices. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count a value excluding duplicates depending on a set criteria | Excel Worksheet Functions | |||
Finding Unique/Duplicates | Excel Worksheet Functions | |||
Sumproduct excluding duplicates with added condition?? | Excel Worksheet Functions | |||
Requesting Help with Counting in a Pivot but Excluding Duplicates | Excel Worksheet Functions | |||
Count excluding Duplicates | Excel Worksheet Functions |