Pull out uniqe Values.

So I have 36 cells that will have multiple letter values. The cells in the range (MyRange) in question, have formulas in them. I will be transferring this into a cell range that has over 6000 cells, but I'll worry about that when I get this part down. :D I have 07 excel but this is in the older versions. Thanks Bro's

So now the Range is a little better populated. So I was thinking of like E14 is the start and than E14=E4 and than E15=E5 unless E5=E4, than E15=6 unless so on Im trying to look to figure this out. But Im stumped.

Yo yo yo
I want to pull out all the different sets of letters. Its a punnent square system and I have a larger one thats 6000+ cells that Im appliying all this to.

I want all the different values to go into different cells underneath it. But, as you can see, there are instances that values are repeated. So I jsut want a set of the 1 of each. Starting where ever is fine I can adjust it. But Like start at E14.

Does that make sense?

Ipsl

Can you attach a sample file w/o zipped? so that I can see what I can do.

w/o zipped? I dont understand how I can do that? Its the same thing I was working on before that you helped me with here.
http://www.excelforum.com/showthread.php?t=630034

Dude.. you totally on point. Do you like leopards Gekcos?

?
So has it been solved already ?

Sorry, I don't really understand what you want to do.

How do you want the result from the data presented?

I would like the uique values to under the word results. I'll put that word at the top of one of the colums. Just a list of all the unique sets from the range (MyRange)

Somehting like in this thread.
http://www.excelforum.com/showthread.php?t=631338

except I want to pull out froma range. And I want them to be on the first sheet starting at any particular cell. Say the cell under the word/ cell Result. That way I can move the values to other cells when I transfer.

Still not sure....
try this anyway
The code will extract unique value for each column...

Please Login or Register  to view this content.

ok now if instead of coloums, its a range (cells E4:L11). How would I change it to do that? Than where do the answers pop out? Thanks man.

Please Login or Register  to view this content.

Damn bro your good. I just tweaked it so now it perfect @#%# yeah man!! You rock!!!