Hi all I have this function that someone helped me with, now I've gone and forgotten how to use it. I know there is something I have to do to the worksheet before it will reconigze the function can anyone help?
Please Login or Register to view this content.
Last edited by randell.graybill; 09-05-2009 at 11:52 PM.
The function would need to reside in a Module, thereafter assuming Macros are enabled:
=UNIQUEITEM(A1:A10,2)
would I believe extract the 2nd unique item from the range A1:A10 (excluding blanks).
(the above is not my code so is based on my interpretation)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks Donkey that is what I thought, but it wasn't working for me on a different spreadsheet then it was originally created for...which it should. Anyway I'm going to mark this as solved as I found a completely different unrelated way to accomplish my goal...which I don't remember what it was at this time but yeah.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks