LinkBack URL
About LinkBacks
One way to get the list without VBA
If data starts in cell A2
Try this in B2 and copy down
Formula:
=IF(COUNTIF(A$2:A2,A2)=2,A2,"")
One way to get the list without VBA
If data starts in cell A2
Try this in B2 and copy down
Formula:=IF(COUNTIF(A$2:A2,A2)=2,A2,"")
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks