copy text to another sheet

[Stuart_Anderson]

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

[protonLeah]

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

[Stuart_Anderson]

Just been think about what i want has changed attched is the excel sheetBook1.xlsx

[Fotis1991]

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)

[Stuart_Anderson]

thank you that works


cheers Stuart

[Fotis1991]

You are welcome Stuart

Welcome to the Excel Forum.