I have created an Excel spreadsheet that determined the number of weighted plates needed for a barbell when lifting a certain amount of weight.
As an example, if the weight to lift is 200lbs, a 45lb plate, 25lb plate, and a 5 2.5lb plate is needed.
The spreadsheet lists the weighted plates in a row. Using our 200lb example there would be 4 columns with a number in it: 45 25 5 2.5
The "45 25 5 2.5" indicates that a 45lb plate, 25lb plate, 5lb plate, and 2.5lb plate
Each value is in its own column.
I have created a formula to put all the value in one column with wording. The output if this column is:
45x1 35x0 25x1 10x0 5x1 2.5x1 1.25x0
The formula I am using is: ="45x"&COUNTIF(B5:H5,45)&" 35x"&COUNTIF(B5:H5,35)&" 25x"&COUNTIF(B5:H5,25)&" 10x"&COUNTIF(B5:H5,10)&" 5x"&COUNTIF(B5:H5,5)&" 2.5x"&COUNTIF(B5:H5,2.5)&" 1.25x"&COUNTIF(B5:H5,1.25)
My question is how can I ONLY display the values that are greater than 0. In this case, the output would look like:
45x1 25x1 5x1 2.5x1
I have included an image of the spreadsheet for visual reference.
Thanks in advance for your help.
Jeffrey
As an example, if the weight to lift is 200lbs, a 45lb plate, 25lb plate, and a 5 2.5lb plate is needed.
The spreadsheet lists the weighted plates in a row. Using our 200lb example there would be 4 columns with a number in it: 45 25 5 2.5
The "45 25 5 2.5" indicates that a 45lb plate, 25lb plate, 5lb plate, and 2.5lb plate
Each value is in its own column.
I have created a formula to put all the value in one column with wording. The output if this column is:
45x1 35x0 25x1 10x0 5x1 2.5x1 1.25x0
The formula I am using is: ="45x"&COUNTIF(B5:H5,45)&" 35x"&COUNTIF(B5:H5,35)&" 25x"&COUNTIF(B5:H5,25)&" 10x"&COUNTIF(B5:H5,10)&" 5x"&COUNTIF(B5:H5,5)&" 2.5x"&COUNTIF(B5:H5,2.5)&" 1.25x"&COUNTIF(B5:H5,1.25)
My question is how can I ONLY display the values that are greater than 0. In this case, the output would look like:
45x1 25x1 5x1 2.5x1
I have included an image of the spreadsheet for visual reference.
Thanks in advance for your help.
Jeffrey