I have a new study that needs to report and calculate %agreement of working and checking standard each injection with 20+ compounds, which means there will be 40+ different concentration for each working and checking.
Repeat table is not feasible because each compound has it's own concentration and we would have to write 20+ "iif()" statement or create 20+ table for each compound.
Are there any other way we can do this?
Thank you for your help.
Picture above are the calculation we want to perform.
Thanks again for any help.