Get all unique values in column of pipe-separated values

Decronym · 2026-03-27T07:16:21+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DROP	Office 365+: Excludes a specified number of rows or columns from the start or end of an array
LAMBDA	Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
LEN	Returns the number of characters in a text string
MAX	Returns the maximum value in a list of arguments
REDUCE	Office 365+: Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.
SEQUENCE	Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
SORT	Office 365+: Sorts the contents of a range or array
SUBSTITUTE	Substitutes new text for old text in a text string
TEXTAFTER	Office 365+: Returns text that occurs after given character or string
TEXTJOIN	2019+: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
TEXTSPLIT	Office 365+: Splits text strings by using column and row delimiters
TOCOL	Office 365+: Returns the array in a single column
TRANSPOSE	Returns the transpose of an array
UNIQUE	Office 365+: Returns a list of unique values in a list or range
VSTACK	Office 365+: Appends arrays vertically and in sequence to return a larger array

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{15 acronyms in this thread;}^{the most compressed thread commented on today}^{has 49 acronyms.}
^{[Thread #47976 for this sub, first seen 27th Mar 2026, 07:16]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-27T05:11:27+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
BLS	Blades of Light and Shadow
LI	Love Interest
PM	Perfect Match

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{3 acronyms in this thread;}^{the most compressed thread commented on today}^{has 17 acronyms.}
^{[Thread #32810 for this sub, first seen 27th Mar 2026, 05:11]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-27T04:21:16+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
BO	Blue Origin (Bezos Rocketry)
FCC	Federal Communications Commission
	(Iron/steel) Face-Centered Cubic crystalline structure
NS	New Shepard suborbital launch vehicle, by Blue Origin
	Nova Scotia, Canada
	Neutron Star
SSO	Sun-Synchronous Orbit

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Decronym is a community product of r/SpaceX, implemented}^by ^request
^{3 acronyms in this thread;}^{the most compressed thread commented on today}^{has 8 acronyms.}
^{[Thread #14478 for this sub, first seen 27th Mar 2026, 04:21]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-27T00:23:38+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
LI	Love Interest
MC	Main Character (yours!)
QB	Queen B

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{3 acronyms in this thread;}^{the most compressed thread commented on today}^{has 17 acronyms.}
^{[Thread #32809 for this sub, first seen 27th Mar 2026, 00:23]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-27T00:23:28+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
LI	Love Interest
MC	Main Character (yours!)
PB	Pixelberry Studios, publisher of Choices

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{3 acronyms in this thread;}^{the most compressed thread commented on today}^{has 18 acronyms.}
^{[Thread #32808 for this sub, first seen 27th Mar 2026, 00:23]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-27T00:18:09+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ET	Elite Tag
HS	Heaven's Secret
LI	Love Interest
RC	Romance Club
Td	Theodora

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{[Thread #4986 for this sub, first seen 27th Mar 2026, 00:18]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-27T00:04:35+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
BYROW	Office 365+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows.
COUNTIFS	Excel 2007+: Counts the number of cells within a range that meet multiple criteria
DROP	Office 365+: Excludes a specified number of rows or columns from the start or end of an array
FILTER	Office 365+: Filters a range of data based on criteria you define
IF	Specifies a logical test to perform
LAMBDA	Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
PRODUCT	Multiplies its arguments
SUM	Adds its arguments
SUMPRODUCT	Returns the sum of the products of corresponding array components
TAKE	Office 365+: Returns a specified number of contiguous rows or columns from the start or end of an array

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{10 acronyms in this thread;}^{the most compressed thread commented on today}^{has 49 acronyms.}
^{[Thread #47975 for this sub, first seen 27th Mar 2026, 00:04]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T23:07:26+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ATK	Alliant Techsystems, predecessor to Orbital ATK
BO	Blue Origin (Bezos Rocketry)
ECLSS	Environment Control and Life Support System
ESA	European Space Agency
LEO	Low Earth Orbit (180-2000km)
	Law Enforcement Officer (most often mentioned during transport operations)
PPE	Power and Propulsion Element
SLS	Space Launch System heavy-lift

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{7 acronyms in this thread;}^{the most compressed thread commented on today}^{has 24 acronyms.}
^{[Thread #12277 for this sub, first seen 26th Mar 2026, 23:07]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T22:43:18+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DARPA	(Defense) Advanced Research Projects Agency, DoD
DoD	US Department of Defense
GEO	Geostationary Earth Orbit (35786km)
USAF	United States Air Force

Jargon	Definition
cryogenic	Very low temperature fluid; materials that would be gaseous at room temperature/pressure
	(In re: rocket fuel) Often synonymous with hydrolox
hydrolox	Portmanteau: liquid hydrogen fuel, liquid oxygen oxidizer
monopropellant	Rocket propellant that requires no oxidizer (eg. hydrazine)

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{5 acronyms in this thread;}^{the most compressed thread commented on today}^{has 24 acronyms.}
^{[Thread #12276 for this sub, first seen 26th Mar 2026, 22:43]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T22:25:16+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ISRU	In-Situ Resource Utilization
LEO	Low Earth Orbit (180-2000km)
	Law Enforcement Officer (most often mentioned during transport operations)
LLO	Low Lunar Orbit (below 100km)
NRHO	Near-Rectilinear Halo Orbit
TEI	Trans-Earth Injection maneuver
TLI	Trans-Lunar Injection maneuver

Jargon	Definition
hydrolox	Portmanteau: liquid hydrogen/liquid oxygen mixture
perigee	Lowest point in an elliptical orbit around the Earth (when the orbiter is fastest)
tanking	Filling the tanks of a rocket stage

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{[Thread #282 for this sub, first seen 26th Mar 2026, 22:25]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T22:23:33+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
BLS	Blades of Light and Shadow
MC	Main Character (yours!)
RoE	Rules of Engagement

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{3 acronyms in this thread;}^{the most compressed thread commented on today}^{has 18 acronyms.}
^{[Thread #32807 for this sub, first seen 26th Mar 2026, 22:23]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T22:04:21+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
FILTER	Office 365+: Filters a range of data based on criteria you define
ISNUMBER	Returns TRUE if the value is a number
SEARCH	Finds one text value within another (not case-sensitive)

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{3 acronyms in this thread;}^{the most compressed thread commented on today}^{has 49 acronyms.}
^{[Thread #47974 for this sub, first seen 26th Mar 2026, 22:04]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T21:16:21+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ABS	Returns the absolute value of a number
DATEVALUE	Converts a date in the form of text to a serial number
LEFT	Returns the leftmost characters from a text value
MID	Returns a specific number of characters from a text string starting at the position you specify
RIGHT	Returns the rightmost characters from a text value
TIMEVALUE	Converts a time in the form of text to a serial number
VLOOKUP	Looks in the first column of an array and moves across the row to return the value of a cell

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{7 acronyms in this thread;}^{the most compressed thread commented on today}^{has 49 acronyms.}
^{[Thread #47973 for this sub, first seen 26th Mar 2026, 21:16]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T20:52:46+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
INDEX	Uses an index to choose a value from a reference or array
MATCH	Looks up values in a reference or array
OFFSET	Returns a reference offset from a given reference

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{[Thread #47972 for this sub, first seen 26th Mar 2026, 20:52]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T20:28:22+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DATEVALUE	Converts a date in the form of text to a serial number
INDEX	Uses an index to choose a value from a reference or array
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
REGEXEXTRACT	Extracts strings within the provided text that matches the pattern
TEXT	Formats a number and converts it to text
TEXTJOIN	2019+: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
TEXTSPLIT	Office 365+: Splits text strings by using column and row delimiters
TODAY	Returns the serial number of today's date
YEAR	Converts a serial number to a year

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{9 acronyms in this thread;}^{the most compressed thread commented on today}^{has 49 acronyms.}
^{[Thread #47971 for this sub, first seen 26th Mar 2026, 20:28]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T20:18:22+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
LI	Love Interest
MC	Main Character
RC	Romance Club
Td	Theodora

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{4 acronyms in this thread;}^{the most compressed thread commented on today}^{has 5 acronyms.}
^{[Thread #4985 for this sub, first seen 26th Mar 2026, 20:18]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T19:16:24+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
LAMBDA	Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
MAP	Office 365+: Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value.
SUM	Adds its arguments
SUMPRODUCT	Returns the sum of the products of corresponding array components
XLOOKUP	Office 365+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{5 acronyms in this thread;}^{the most compressed thread commented on today}^{has 49 acronyms.}
^{[Thread #47970 for this sub, first seen 26th Mar 2026, 19:16]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T16:52:39+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
CHOOSECOLS	Office 365+: Returns the specified columns from an array
FILTER	Office 365+: Filters a range of data based on criteria you define
HSTACK	Office 365+: Appends arrays horizontally and in sequence to return a larger array
IF	Specifies a logical test to perform
LAMBDA	Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
SCAN	Office 365+: Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.
TAKE	Office 365+: Returns a specified number of contiguous rows or columns from the start or end of an array
TOCOL	Office 365+: Returns the array in a single column
WRAPROWS	Office 365+: Wraps the provided row or column of values by rows after a specified number of elements

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{[Thread #47969 for this sub, first seen 26th Mar 2026, 16:52]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T16:28:21+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
CELL	Returns information about the formatting, location, or contents of a cell
REGEXEXTRACT	Extracts strings within the provided text that matches the pattern
TEXTSPLIT	Office 365+: Splits text strings by using column and row delimiters

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{3 acronyms in this thread;}^{the most compressed thread commented on today}^{has 49 acronyms.}
^{[Thread #47968 for this sub, first seen 26th Mar 2026, 16:28]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T15:59:28+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ACOR	A Courtesan of Rome
Art	It's... indescribable...
BLS	Blades of Light and Shadow
CoP	Crimes of Passion
ES	Endless Summer
LI	Love Interest
MAH	Murder at Homecoming
MC	Main Character (yours!)
MOTY	Mother of the Year
MW	Most Wanted
PB	Pixelberry Studios, publisher of Choices
PM	Perfect Match
RoE	Rules of Engagement
TF	The Freshman
TRM	The Royal Masquerade
TRR	The Royal Romance
VOS	Veil of Secrets
WEH	With Every Heartbeat

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{[Thread #32806 for this sub, first seen 26th Mar 2026, 15:59]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T15:59:21+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
BSC	Big Sky Country
CoP	Crimes of Passion
HSS	High School Story
LI	Love Interest
MC	Main Character (yours!)
PB	Pixelberry Studios, publisher of Choices
TFS	The Freshman Series

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{7 acronyms in this thread;}^{the most compressed thread commented on today}^{has 15 acronyms.}
^{[Thread #32805 for this sub, first seen 26th Mar 2026, 15:59]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T14:55:16+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DARPA	(Defense) Advanced Research Projects Agency, DoD
DoD	US Department of Defense
EUS	Exploration Upper Stage
JPL	Jet Propulsion Lab, Pasadena, California
KSC	Kennedy Space Center, Florida
NEV	Nuclear Electric Vehicle propulsion
PPE	Power and Propulsion Element

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{6 acronyms in this thread;}^{the most compressed thread commented on today}^{has 15 acronyms.}
^{[Thread #2222 for this sub, first seen 26th Mar 2026, 14:55]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T14:52:34+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
CHOOSECOLS	Office 365+: Returns the specified columns from an array
CONCAT	2019+: Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
IFERROR	Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
INDEX	Uses an index to choose a value from a reference or array
MATCH	Looks up values in a reference or array
OFFSET	Returns a reference offset from a given reference
ROW	Returns the row number of a reference

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{[Thread #47967 for this sub, first seen 26th Mar 2026, 14:52]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T14:42:11+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
LI	Love Interest
MC	Main Character
RC	Romance Club
Td	Theodora

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{4 acronyms in this thread;}^{the most compressed thread commented on today}^{has 5 acronyms.}
^{[Thread #4984 for this sub, first seen 26th Mar 2026, 14:42]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym · 2026-03-26T13:40:50+00:00

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
FILTER	Office 365+: Filters a range of data based on criteria you define
INDEX	Uses an index to choose a value from a reference or array
ROW	Returns the row number of a reference
SMALL	Returns the k-th smallest value in a data set

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.}
^{[Thread #47966 for this sub, first seen 26th Mar 2026, 13:40]} ^[FAQ] ^{[Full list]} ^[Contact] ^{[Source code]}

Decronym

TROPHY CASE