Return characters based on another column

[Crusaders43]

Is there a way to look in a column and get a return based on the numbers in that column?

For example, say I have the following numbers in the following cells


A1 = 3
A2 = 6
A3 = 8
A4 = 3
A5 = 3
A6 = 2
A7 = 8
A8 = 9


I want to somehow look through column A and if there is a number that I have not seen before, return the number "1" in column B.
Esentially, I'd like to see....

A1 = 3 ........... B1 = 1
A2 = 6 ........... B2 = 1
A3 = 8 ........... B3 = 1
A4 = 3 ........... B4 =
A5 = 3 ........... B5 =
A6 = 2 ........... B6 = 1
A7 = 8 ........... B7 =
A8 = 9 ........... B8 = 1

Is there a way to do this using VBA?
Also, if a cell was blank in column A, I'd like that to be skipped....meaning no return in B would come from a blank cell in A.

Thanks in advance!!!

[Crusaders43]

In a ruff sense, if a column is not empty, then look in the column

If the number is new, return "1" else number is not new, return ""

Something along those regards but this is just a first thought....there may be an easier way. The main part of this is to find a number and return a "1" but then every time that number re-appears, skip it....returning ""

[NBVC]

By just using a simple formula...you don't need VBA....

=IF(COUNTIF($A$1:A1,A1)=1,1,"") copied down

[shg]

Cross-posted at http://www.ozgrid.com/forum/showthread.php?t=85336

[Crusaders43]

NBVC - PERFECT! The function works great though -- thank you!!! Works like a charm but is there a way to do this in VBA? That way, If I have a lot of points, I don't have to drag to the end.

[NBVC]

This will automatically insert my formula into column B adjacent to Column A down to last row.

Please Login or Register  to view this content.

Note: Please remember to tell us you cross-posted next time and show the link. Please read this to understand why: http://www.excelguru.ca/node/7

[Crusaders43]

NBVC,

Thank you for your time and help...that did it.
Sorry for the cross-post

But again, thank you thank you thank you for the help......!!!

Problem solved.