Forum Discussion
Need help on a formula please!
I am using this formula - =FILTER(A2:A48,E2:E48>=1,"NODATA") - in order to display the contents of a cell in one column when the number 1 appears in a cell in another column. Can anyone please tell me how I can amend this so that it shows that content when ANY number appears in a cell - 1 or 2 or 3 or 4 etc - not just 1 ?
4 Replies
Sorry not to have expressed thanks for this help for a long time. I thought I had issued a message withdrawing the request for help because I had realised that the formula does already show numbers higher than 1, but it doesn't seem to have gone through.
=FILTER(A2:A48, ISNUMBER(E2:E48), "NODATA")
Use cell reference instead of constant number-
=FILTER(A2:A48,E2:E48>=A1,"NODATA")See https://techcommunity.microsoft.com/discussions/excelgeneral/scrap-that/4357300
