The function of education is to teach one to think intensively and to think critically. Intelligence plus character - that is the goal of true education.
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.