compare cells

[miso.dca]

Hello guys, you helped me lots of times recently, but this is little bit tricky problem ... so :
- I have external data, which are loaded every 1 second
- each row has in column A unique number
- sometimes this row is deleted (from external source)

and I need "just" find If something is new (for this I use

Please Login or Register  to view this content.

and If yes, just copy it somewhere
btw. I will have to use some other criteria, but I think I will be able to modify it and I dont want to complicate it now I have lots of problem to explain myself

I thought that I could store all unique numbers in variables, but there will be lots of variables maybe somebody has better solution?

[mehmetcik]

store your unique numbers in a column.

It is then easy to use find to look for a new number, using an exact match.

If there is no match then this is a new entry.

[FDibbins]

If you could have your data added vertically instead of horizontal, you could use a countif() function to ID the 1st occurance of an entry, and then either just filter on those, or filter and copy/past to the new location.

Take a look atthe attached to see what I mean

[miso.dca]

thx for answer FDibbins, but I cannot use your solution because datas are added only horizontally and I cant change it

[miso.dca]

mehmetcik - your solution looks better, but I am not sure if it so simple could you be please more specific? thank you

[mehmetcik]

Here is a sample of what I meant.

study the data.

there are only three unique numbers in my list.#

Modify the list if you want

then run the macro.

Please Login or Register  to view this content.