If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|