I wrote this formula for a spreadsheet years ago, its an order sheet for a restaurant, when the adjacent cell next to an item in the source sheet is marked with a number it appears on a different sheet, a neat list with no spaces in between. This list was to be emailed to the person buying the supplies. It worked great until someone changed the source and moved tables around. I don't use it anymore so I didn't think about it until I wanted to replicate the formula in different spreadsheet to do basically the same thing, but I cant remember exactly what I did. I've been trying to break it down and change the info but I just cant make it work in a new sheet. Can anyone explain this formula to me? Does this question even make sense?
These are the first 2 cells, the only difference in every formula is the very last number which is the destination for the source:
=IFERROR(INDEX(KITCHEN!B:B,SMALL(IF(KITCHEN!$A$4:$A$58<>0,ROW(KITCHEN!$A$4:$A$58)),ROWS($C$1:D1))),"")
=IFERROR(INDEX(KITCHEN!B:B,SMALL(IF(KITCHEN!$A$4:$A$58<>0,ROW(KITCHEN!$A$4:$A$58)),ROWS($C$1:D2))),"")
Bookmarks