LinkBack URL
About LinkBacks
makinmomb 
name 1 stay
name 1 remove
name 1 remove
name 1 remove
name 2 stay
name 2 remove
What should be the formula on b1 ?
Yes i know 2010 has DATA remove duplicates as one click done
name 1 stay
name 1 remove
name 1 remove
name 1 remove
name 2 stay
name 2 remove
What should be the formula on b1 ?
Yes i know 2010 has DATA remove duplicates as one click done
I can then sort by stay and punch delete rows for the ones marked remove , true false will do too
In B1 Cell
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)=1,"Stay","Remove"))
Drag it down..
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
EXACT shorter than fotis 1991 , though I also use some answers from FOTIS in daily real life cases
Have added you a repo sixthsense
In B1
Formula:
=IF(A1="","",A1)
In B2 and copy down
Formula:=IFERROR(INDEX(A$1:A$10,MATCH(1,INDEX((COUNTIF(B$1:B1,A$1:A$10&"")=0)*(A$1:A$10<>""),0),0)),"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks