Copy from list when different (create unique list with formulas)

[pansovic]

I have a column of products that consist of for example 5 times the word "Apple" 3 times "Oranges", 6 times "Bananas". I want now to create other column where appears Apple. Orasnge, banana taking from the previous column. So I need to create formula that when it is same word is not doing anything and when word change it add to the list.

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[NBVC]

Maybe this?

Suppose your list is in column A, beginning in Row 2... So A2 has first entry,

Add a helper column in B2 with formula:

Please Login or Register  to view this content.

and copy it down the list and further if you wish, for future additions.

Then in next column, C2, add

Please Login or Register  to view this content.

Then in D2, to get unique values,

Please Login or Register  to view this content.

copied down.

[pansovic]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Thanks. I noticed that I got mail but on wrong email address. How can I change my email address in my profle?