Forum Discussion
Brian0088
Aug 28, 2023Copper Contributor
Conditional range
Hello to all, I'm trying to create a spreadsheet that will keep track of my studying and preparation for a big exam. I'm using space repetition to learn. So in my spreadsheet I have the date tha...
OliverScheurich
Aug 28, 2023Gold Contributor
=DROP(REDUCE("",SEQUENCE(ROWS(B2:B5)),LAMBDA(x,y,VSTACK(x,IFERROR(EXPAND(INDEX(A2:A5,y,1),INDEX(B2:B5,y,1),1),INDEX(A2:A5,y,1))))),1)
Is this what you basically want to do? If so it should be possible to add criteria for 0=<x<3, 3=<x <7, 7=<x<10. Btw. what does "T or F" mean?