First and foremost, I want to thank for Hansdouwe unwavering supports below, because I didn't think it through enough and didn't make my request clear, I have to apologize for hansdouwe effort
NEW Objective: I am seeking a simple formula to extract from "Circle 1" to "Circle 2" in pic ONLY if it is possilbe in excel
- a formula to extra any cell with value from top to bottom then next column again in this order while skippng all the cell with FALSE
- I am using excel 2021 and 365, either version is fine whichever makes the formula easier and simpler.
- Range B2:G6 is dynamic, the cells' value pivot (meaning it can be any number or no number) day to day
- * I already know another DIFFERENT working formula to get the result in Column K from previous help (mentioned in post below), so my request is for my own educational purpose only to see is possible to continue to utilize the formula in "circle 1" to "circle 2".
The reason why is that it took me ages to understand the formula under Column L, and I really want to see if it is possible to leverage the formula in a similar way .
column L formula : =INDEX($B$1:$G$1,SMALL(IF(ISNUMBER($B$2:$G$6),COLUMN($B$2:$G$6)-COLUMN($B$2)+1),ROW()-ROW($A$1)))
Thanks for your time and help in advance, deeply appricate helping me to learn excel.
help.jpg
Bookmarks