Forum Discussion
Excel help sorting.
Good afternoon, hope someone can help. so here goes. i have a spreadsheet that has 8 columns the first Column is a list of companies named and numbered starting in A6 down to A52. Then I have fou...
Do you have Excel 365, because FILTER is one of the dynamic array functions that came out in 2018.
The following involves lambda functions simply because I am trying to change the way in which I program Excel.
= FILTER(table, BYROW(operators=selected,ORλ))
where
ORλ = LAMBDA(x,OR(x))In that case, this should demonstrate the formula works. It may be a couple of steps too far for implementation but, hopefully, of interest.
- As you can tell I’m not super advanced with excel. So bare with me. I have the drop down list on H3 ( this is where the accounts are listed.) Do I need to put the formula too left corner cell where I want the result displayed?
