I have multiple worksheets for which I have created a range and named "sheetlist".
I am trying to write a formula that will list the data of each B3 cell (people's names) if the corresponding B21 cell on the worksheet is >.1 but <1
(So, anyone who has a value of >.1 but <1 in B21 will have their name shown in a list).
How do I write that?
I am trying to write a formula that will list the data of each B3 cell (people's names) if the corresponding B21 cell on the worksheet is >.1 but <1
(So, anyone who has a value of >.1 but <1 in B21 will have their name shown in a list).
How do I write that?
