Register
Help
Forgotten Your Password?
Remember Me?
Forum
Today's Posts
FAQ
Calendar
Community
Groups
Forum Actions
Mark Forums Read
Quick Links :
What's New?
Members List
Calendar
Forum Rules
Dashboard
Commercial Services
Advanced Search
Forum
Microsoft Office Application Help - Excel Help forum
Excel Formulas & Functions
[SOLVED] Array Formula to extract all values (both duplicates and unique values in a range in Excel
For the best help
attach a sample workbook
to your post
New Notice for experts and gurus
:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.
Results 1 to 12 of 12
Array Formula to extract all values (both duplicates and unique values in a range in Excel
LinkBack
LinkBack URL
About LinkBacks
Thread Tools
Show Printable Version
Subscribe to this Thread…
Rate This Thread
Current Rating
Excellent
Good
Average
Bad
Terrible
Display
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Threaded View
bjnockle
Array Formula to extract all...
10-26-2016,
08:43 PM
Pete_UK
Re: Array Formula to extract...
10-26-2016,
08:59 PM
bjnockle
Re: Array Formula to extract...
10-26-2016,
09:02 PM
Pete_UK
Re: Array Formula to extract...
10-26-2016,
09:09 PM
bjnockle
Re: Array Formula to extract...
10-26-2016,
09:11 PM
azumi
Re: Array Formula to extract...
10-26-2016,
09:05 PM
bjnockle
Re: Array Formula to extract...
10-26-2016,
09:14 PM
Phuocam
Re: Array Formula to extract...
10-26-2016,
09:55 PM
bjnockle
Re: Array Formula to extract...
10-27-2016,
07:29 PM
azumi
Re: Array Formula to extract...
10-26-2016,
11:30 PM
bjnockle
Re: Array Formula to extract...
10-27-2016,
07:28 PM
Phuocam
Re: Array Formula to extract...
10-27-2016,
07:33 PM
10-26-2016,
09:14 PM
#7
bjnockle
View Profile
View Forum Posts
Forum Contributor
Join Date
02-06-2013
Location
Maryland
MS-Off Ver
Excel 2010
Posts
1,022
Re: Array Formula to extract all values (both duplicates and unique values in a range in E
Attachment
Attached Files
SampleProduct.xlsx
(9.7 KB, 20 views)
Download
Register To Reply
«
Previous Thread
|
Next Thread
»
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread.
(0 members and 1 guests)
Similar Threads
Non Array Formula to pull unique values and sort in a range
By bjnockle in forum Excel Formulas & Functions
Replies:
13
Last Post:
02-04-2021,
06:15 AM
extract unique values in an array
By froggeja in forum Excel Formulas & Functions
Replies:
17
Last Post:
06-24-2015,
03:58 AM
Extract Unique Values from VBA array
By cmore in forum Excel Programming / VBA / Macros
Replies:
13
Last Post:
10-16-2013,
08:25 PM
[SOLVED]
Array formula to extract and sort unique values from two worksheets
By rshukla in forum Excel Formulas & Functions
Replies:
2
Last Post:
10-07-2013,
06:11 AM
Extract unique values and their count from a two dimensional Array
By shahirslmn in forum Excel Programming / VBA / Macros
Replies:
8
Last Post:
05-17-2012,
09:37 PM
Excel 2007 : Array formula to extract unique values from a range
By Motox in forum Excel General
Replies:
3
Last Post:
11-24-2011,
06:11 AM
Extract Unique Values from an Array based on Criteria
By ronleex324 in forum Excel General
Replies:
1
Last Post:
10-04-2011,
06:37 PM
Bookmarks
Bookmarks
Digg
del.icio.us
StumbleUpon
Google
Posting Permissions
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
Off
HTML code is
Off
Trackbacks
are
Off
Pingbacks
are
Off
Refbacks
are
Off
Forum Rules
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1
Bookmarks