how to create a name range in mac excel 2013

In the Microsoft Visual Basic for Applications window, click Insert > Module. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.Ģ.

You can also extract a list of unique values dynamically from a column range with the following VBA code.ġ. The Select Duplicate & Unique Cells utility of Kutools for Excel can help you easily select and highlight all unique values (include the first duplicates) or the unique values that appear only once, as well as duplicate values as you need as below screenshot shown.ĭownload Kutools for Excel now! ( 30-day free trail) When values in this range changed, the unique value list will be dynamically changed immediately.Įasily select and highlight all unique values in a range in excel: Now all unique values in column range B2:B9 are extracted.

Keep selecting cell D2, then drag the Fill Handle down to get all unique values from the specified range. (B2:B9 is the column data which you want to extract the unique values, D1 is the above cell where your formula is located) Select a blank cell such as D2, enter the below formula into it and press the Ctrl + Shift + Enter keys simultaneously. Please try the following array formula.ġ. How to make a dynamical list of unique values? This article will show you how to deal with it.ĭynamically extract a list of unique values from a column range with formulaĭynamically extract a list of unique values from a column range with VBA codeĪs below screenshot shown, you need to dynamically extract a list of unique values from range B2:B9. How to dynamically extract a list of unique values from a column range in Excel?įor a column range which the values are changing regularly, and you always need to get all the unique values from the range no matter how it changed.

How to create a name range in mac excel 2013