I have two columns of data, one with names (A7:A), and one with percentages (B7:B).
I am trying to use the filter function to show me the names of results with non-zero percentages. I also want to change what it spits out to have only cells in column B be multiplied by a value in a specific cell (B2) but keep column A the same.
This works to filter out zero results but doesn't change column B
This changes column B to the desired value, but column A has #VALUE! error since it's a word and can't be multiplied by a number
This gives the right name values but keeps the original percentage values and doesn't change it.
This gives the right number values but gives #VALUE! error for name as it is not a number.