sortinggoogle-sheetslambdaformulalookup
Looking for the Last Cell that Meets Critera(Horizontally)
I am trying to find a way in Google Sheets to return the last cell based on certain criteria. I've included the table below:
| Jan | Feb | March | April | LATEST SALE | |
|---|---|---|---|---|---|
| group 1 | sale | sale | no sale | sale | April |
| group 2 | no sale | no sale | sale | no sale | March |
I am trying to have the "LATEST SALE" Column return the values I listed above: "April, "March", but I am having trouble finding the right formula.
I know there is a lookup and sort formula, something like
=LOOKUP(H2,SORT(B2:D2),SORT(B1:D1,B2:D2,TRUE))
Perhaps there is something for a horizontal lookup and sort? Thanks for any help, it is much appreciated!
Solution
try:
=IFNA(BYROW(B2:E, LAMBDA(x, LOOKUP(1, INDEX(1/(x="sale")), B1:E1))))
if you want to drag it use:
=IFNA(LOOKUP(1, INDEX(1/(B2:E2="sale")), B$1:E$1))
- Sort dict according to specific value in Ansible
- C#: Sort xml nodes and childnodes using attribute value
- How to sort letters in a string?
- Sort a list of an object with other object's method
- How to sort my array by length of its keys array in javascript?
- Kth Smallest Element in multiple sorted arrays
- groupingBy in Streams with CollectingAndThen method -> how to get rid of Optional then use Max on the map :)
- How to check if two indexed arrays have same values even if the order is not same?
- Create tablegroup with 4 different values ordered by other value by select in mariadb
- Django admin: how to sort by one of the custom list_display fields that has no database field
- Why is the heap in heapsort "the wrong way"?
- Sorting an array before inserting to database
- Sort 1st level keys and 2nd level keys of a 2d array
- Sort values within each row of a 2d array
- Group 2d array data by one column and then sort by another column
- Sort an array according to another array
- Move an element by key before another element by key in the context of an associative array
- How to generate a random number array and sorting this array using php?
- Sort MySQL query result by calculated average DESC
- PHP MYSQL Array and sort
- Sort a 2D array by multiple columns
- how can i sort 2 dimensional array based on index array in PHP?
- Why does usort() not provide a stable sort for equally compared values under PHP8?
- Custom key-sort a flat associative based on another array
- How to find K most frequent elements using java collections framework?
- Sort the first and second level of a 2d array by numeric keys in DESC order
- Sort the parent level of a 3d array by a column in the deepest subarray descending
- Sort a 2d array by its keys which relate to custom sorting values in another 2d array
- Sorting a php array of arrays by custom order
- Sort an array based on related data in a 2d array