Mar 30 2021 03:51 AM
Hi All, I've attached a test sheet based upon our food bank worksheet. We have over 300 families in the rows and over a year of weekly food deliveries in the columns. I can generate results using IF, as on the test sheet (Ive also used vlookup and hlookup). With small numbers of rows and columns this is OK but what i need to do is produce reports of who was fed on a particular date - but without all the blank lines of families that were not fed and similarly for each family a list of the weeks they were fed with out all the blanks of weeks they were not fed. Thanks in advance.
Mar 30 2021 06:13 AM
Mar 30 2021 07:55 AM
Mar 30 2021 08:47 AM
Mar 30 2021 09:29 AM
Mar 30 2021 09:38 AM
Mar 30 2021 10:02 AM