I want to copy text from cell in a sheet and place in another sheet but i want it to check if its not there then copy
Cheers Stuart
I want to copy text from cell in a sheet and place in another sheet but i want it to check if its not there then copy
Cheers Stuart
Last edited by Stuart_Anderson; 09-14-2012 at 03:20 AM.
You need to be more specific and provide a sample workbook.
When you are in Advanced reply, click on the paperclip to open the upload window.
View Pic
Ben Van Johnson
Just been think about what i want has changed attched is the excel sheetBook1.xlsx
One way could be this.
In B1 put this and copy down.
=COUNTIF($A$1:$A1,A1)
Then use this formula to find how many different test exist in your list
=COUNTIF(B1:B14,1)
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.
thank you that works
cheers Stuart
You are welcome Stuart
Welcome to the Excel Forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks