There are no limits when you are surrounded by people who believe in you, or by people whose expectations are not set by the short-sighted attitudes of society, or by people who help to open doors of opportunity, not close them.
I need to make a list of unique values in a range i.e. A1:Z7 (text or numbers)... I do not have 365 so I don't have the fancy new UNIQUE function. I have searched the Inter-Web and find a lot of variations to do a list for a single column but not for a 2D rang. I can't use advanced sort because it needs to run auto_magically when updated. I have tried some MMULT and CSE things with no JOY - PLEASE HELP :)
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.