Forum Discussion
Chloe_Apsey
May 17, 2022Copper Contributor
Comparing two lists of Email Address and names and pulling the non-matching data to a new list
Hello, I currently have an original list of participant's email who I contacted to take part in a study. I now have a second list of the emails of the participants who have taken part in the stud...
- Feb 16, 2024
Including the values on the worksheet to give an alternating pattern is a step backward because it makes any calculation harder. The formula I would use is
= BYROW(status * {60,20,10,10,10}%, LAMBDA(x, SUM(x)))
which spills to return the entire column of overall percentages.
[Look out for the new checkboxes when the come available; they are much better to set up and use]
Lorenzo
May 17, 2022Silver Contributor
- Gr8lifMar 10, 2024Copper ContributorThank you! Super easy formula and it worked!!!
- Chloe_ApseyMay 17, 2022Copper ContributorAmazing - thank you very much!