| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Function Help please
Please help with this function. I am using the following function to
identify dupes in my list. "=IF(COUNTIFI(B$1:B$1000,B1)1,"DUP,"NO DUP")". However, I would like the function to keep once instance of the dup and identify everything else. When I filter on "DUP", only the dups will be deleted. Does this make sense? How can I do this please? Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Function Help please
Try it like this:
=IF(COUNTIF(B$1:B1,B1)=1,"NO DUP","DUP") -- Biff Microsoft Excel MVP "TotallyConfused" wrote in message ... Please help with this function. I am using the following function to identify dupes in my list. "=IF(COUNTIFI(B$1:B$1000,B1)1,"DUP,"NO DUP")". However, I would like the function to keep once instance of the dup and identify everything else. When I filter on "DUP", only the dups will be deleted. Does this make sense? How can I do this please? Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Function Help please
This worked great! Thank you very much.
"T. Valko" wrote: Try it like this: =IF(COUNTIF(B$1:B1,B1)=1,"NO DUP","DUP") -- Biff Microsoft Excel MVP "TotallyConfused" wrote in message ... Please help with this function. I am using the following function to identify dupes in my list. "=IF(COUNTIFI(B$1:B$1000,B1)1,"DUP,"NO DUP")". However, I would like the function to keep once instance of the dup and identify everything else. When I filter on "DUP", only the dups will be deleted. Does this make sense? How can I do this please? Thank you. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Function Help please
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "TotallyConfused" wrote in message ... This worked great! Thank you very much. "T. Valko" wrote: Try it like this: =IF(COUNTIF(B$1:B1,B1)=1,"NO DUP","DUP") -- Biff Microsoft Excel MVP "TotallyConfused" wrote in message ... Please help with this function. I am using the following function to identify dupes in my list. "=IF(COUNTIFI(B$1:B$1000,B1)1,"DUP,"NO DUP")". However, I would like the function to keep once instance of the dup and identify everything else. When I filter on "DUP", only the dups will be deleted. Does this make sense? How can I do this please? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
Linear Mode
