Create a Weight Tracking Worksheet in Excel with the OFFSET Function

Описание к видео Create a Weight Tracking Worksheet in Excel with the OFFSET Function

I use this method in my Google Sheet fitness tracker, but of course, we can do the same thing in Excel. Use the OFFSET function to calculate a median of the current weight and the six prior weight entries. A little bit of IF function is used too so that we can only display the median on Saturdays that are past or present, not in the future.

Комментарии

Информация по комментариям в разработке

Похожие видео