L
Legacy 183598
Guest
Hello.
I cannot get the photo to link correctly: please refer to the photo as a reference. Thanks!
![](/board/proxy.php?image=http%3A%2F%2Fs24.photobucket.com%2Falbums%2Fc47%2Fjohnnytoscani%2F%3Faction%3Dview%26current%3DCountIf.jpg&hash=6024f3fde9b720b05906cf8697642c7f)
http://s24.photobucket.com/albums/c47/johnnytoscani/?action=view¤t=CountIf.jpg
I wanted to see if the data I entered contained any duplicate information for a specific column ("ID") in a table I created and to return a value of "True" when the row had duplicate data
I used a COUNTIF Function and it worked. However, after doing this, I applied filters to some of the columns and the COUNTIF values that were displayed were no longer valid because they were including the hidden rows/cells. I watched a few of the videos on here and some said to use "SUMPRODUCT" and others said to use "SUBTOTAL." I still am not sure what approach to take.
Using the above photo, let's say I wanted to filter the results only by "Procedure Description." How can I get the "True" to become "False" when filtering is applied?
Thank you in advance for your help!
I cannot get the photo to link correctly: please refer to the photo as a reference. Thanks!
![](/board/proxy.php?image=http%3A%2F%2Fs24.photobucket.com%2Falbums%2Fc47%2Fjohnnytoscani%2F%3Faction%3Dview%26current%3DCountIf.jpg&hash=6024f3fde9b720b05906cf8697642c7f)
![](/board/proxy.php?image=http%3A%2F%2Fs24.photobucket.com%2Falbums%2Fc47%2Fjohnnytoscani%2F%3Faction%3Dview%26current%3DCountIf.jpg&hash=6024f3fde9b720b05906cf8697642c7f)
I wanted to see if the data I entered contained any duplicate information for a specific column ("ID") in a table I created and to return a value of "True" when the row had duplicate data
I used a COUNTIF Function and it worked. However, after doing this, I applied filters to some of the columns and the COUNTIF values that were displayed were no longer valid because they were including the hidden rows/cells. I watched a few of the videos on here and some said to use "SUMPRODUCT" and others said to use "SUBTOTAL." I still am not sure what approach to take.
Using the above photo, let's say I wanted to filter the results only by "Procedure Description." How can I get the "True" to become "False" when filtering is applied?
Thank you in advance for your help!
Last edited by a moderator: