|
| 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
September 19th, 2008, 04:50 PM
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
September 19th, 2008, 05:08 PM
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
September 19th, 2008, 06:18 PM
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
September 19th, 2008, 06:30 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
