Map-like array function in Excel?

Is there something like a map function in Excel?

For example, let’s say I want to apply the formula ABS to a list of items. Something like:


As an example of python-like notation:

# list comprehension
>>> [abs(i) for i in [-1,2,3,4,5]]
[1, 2, 3, 4, 5]

# map
>>> map(abs,[-1,2,3,4,5])
[1, 2, 3, 4, 5]

# passing arbitrary function
>>> map(lambda x:abs(x)+1, [-1,2,4,5,6])
[2, 3, 5, 6, 7]

Is there something similar in Excel?

Note, the closest I’ve gotten is using native operators against lists, such as =2*{1,2,3,4,5}, but this just gives things like the basic arithmetic operations.

>Solution :

In Excel-365 you can directly use ABS() function with array of data. Try-


enter image description here

Leave a Reply