Unfortunately I am not very good when it comes to working out a formula for such data. I came across this thread BP Excel Formula and have tried to change what I think should be changed but since I have a 'LEFT', a 'MIDDLE' and a 'RIGHT' number along with the '/' & '-' x 3 for each test, I cannot work out how to alter it to work. plus additional data, I want to keep to this format so that I can easily input and see ALL data I input on a screen without left/right scrolling (not spread out over multiple columns for individual numbers taking up too much width with all the additional data - which I know now would make it so much easier to do, but I do not have time now to reset all the data). The format I use in each column for the digital testing machine's results is S/D-H (85/70-81).īecause this is a standard way of showing these 3 measurements and because with a total of 6 measurements a day.
Each time I take 3 tests and then manually AVG.
0 kommentar(er)
