Forum Discussion
Solved
Formula for excel
Hello! I needed assistance with a formula that will be a "yes or no" in column A, that will determine if the dtcreate (column o) within each group of patient IDs is within 28 days of each other. ...
Did you enter the formula in cell A2? If you expect the formula to return results from cell A2 to cell A14 (as shown in the screenshot of my last reply) then select range A3:A14 and delete all data from these cells.
Here is additional information on how to correct a #SPILL error.
I get a spill error, when I evaluate the formula it shows the lambda portion is causing it?
Did you enter the formula in cell A2? If you expect the formula to return results from cell A2 to cell A14 (as shown in the screenshot of my last reply) then select range A3:A14 and delete all data from these cells.
Here is additional information on how to correct a #SPILL error.
- that worked ! thank you so much for the help! really appreciate it