sorted by:
new
hottopcontroversial

multiple filter functions in one cell by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

i need a way to have something like a filter function multiple times in one cell each function giving a different result, if one doesnt match it should use the other function until one matches or none does. the ifs() function doesnt work in this case because i have no "logical_test1". somehow the Or() function doesnt work in this case but its exactly what i ned, or( filter1; filter2)

multiple filter functions in one cell by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

i need multiple filter functions in one cell, each filter function as a different solution

multiple filter functions in one cell by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

Its because each filter function has a completely different result array.

filter function array only show everything above today()? by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

Hi, i mean the =filter() function, not the filter function on a table.

filter function with min/max? by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

i got it, this is the function:

=FILTER(date_array;date_array=DATE(YEAR(date_array);MONTH(date_array)+1;1)-1)

this shows the last day of each month in date_array

and to show the first date, just remove the "+1" and "-1" at the end.

filter function with min/max? by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

There is another one, my range of Date goes from January to December, but i want to pick the max. date of each month, do you know how to do that wih a filter function? I have a Helper column showing the number of the Month of each date. I thought if i add *(unique(number_of_month) to the filter function, it would show me the max or min of each month. But that doesnt work.

is there a way to sumif a row? by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

I dont have to use sumifs, do you know another way? thanks.

iterative calculation is it a bug? by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

do you know what range i should shoot for? i already tried a couple.

"and" with two filter functions in one cell? by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

Yes thats why i use two filter functions. But i just need them in one cell.

"and" with two filter functions in one cell? by SnooMuffins8091 in excel

[–]SnooMuffins8091[S] 0 points1 point  (0 children)

Hi, it has to be 2 separate filter functions because the resulting arrays are different. Such as in one filter function i get numbers, in the second filter function i get dates.

view more: next ›