Search code examples
EXAMPLE-A
excel
google-sheets
unique
How can I generate a two separate columns list of unique “combos”?
desired output:
E
F
red
2016
red
2020
black
2018
example:
A
B
C
color
year
red
2016
red
2020
black
2018
red
2016
red
2020
Solution
In sheets:
=UNIQUE({A2:A,C2:C})
which will error in Excel.
How to make Colors Mixer in vba
How to get HEX color value from cell color?
SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
How to randomize Excel rows
VLOOKUP Returns 0 even though there is a value in the line below the first result
transpose a table with multiple values in excel
Trying to late bind outlook to but getting type mismatch error after create object line
Power Query Transform a Column based on Another Column
Apply FILTER formula to array (and use filter criteria on specific column in the array)
Bitly API call using VBA Excel Macro
excel vba projects not closing
In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
Sigma or Summation function in Excel
Problem getting the value from a cell using M in excel
INDEX MATCH to also pull through notes
Move formatted data in selection from Excel into Word tables
Excel VBA function to remove letters at end of string
Can't get all excel processes to stop when closing through Powershell
Excel function to construct an array from values without VBA
Alternative method to delete file with out having to add MS Scripting Runtime Reference
Add new button to worksheet with Excel Add-in
Apply outline border only to range of cells with openpyxl
How to Separate Data with Inconsistent Patterns into a Structured Format in Excel
Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
How to reference the current User\Desktop location in VBA
Powerpoint chart to excel relative link
EXCEL: How do I return multiple columns using XLOOKUP, when the lookup_value is a range?
VBA: How to Loop IF Statement through a Cell and Chart Series
Incorporating Checkbox to lines of code rather than Cell value
How do I remove a character from a column of data in Excel