In Col A i have expressions that evaluate to a logical (True or False)
In Col B i have numbers.
In Col C, there is this formula (and then filled down):
=IF(A2,B2,"")
I also tried a variation, with this formula.
=IF(A2,B2,NA())
Either variation has the problem described below.
I then create a PivotTable of that range.
Col C acts "normally, as expected" (as a column of valid numbers) in most regards. It gives the correct sum and correct average.
If i put Col C in the row area and try to group by numeric range (I want to group it 5-10, 10-15, etc), I get the error "Cannot group by that selection". If I go through manually, and for all the rows that evaluate to "" (or #N/A), if I manually delete the cell contents, I can then group on that column in a PivotTable by numeric range.
So, my question is, is there any way i can construct the IF formula (col C) to get a column that i can then group on by numeric range, as a PivotTable row field?
Thank you.
In Col B i have numbers.
In Col C, there is this formula (and then filled down):
=IF(A2,B2,"")
I also tried a variation, with this formula.
=IF(A2,B2,NA())
Either variation has the problem described below.
I then create a PivotTable of that range.
Col C acts "normally, as expected" (as a column of valid numbers) in most regards. It gives the correct sum and correct average.
If i put Col C in the row area and try to group by numeric range (I want to group it 5-10, 10-15, etc), I get the error "Cannot group by that selection". If I go through manually, and for all the rows that evaluate to "" (or #N/A), if I manually delete the cell contents, I can then group on that column in a PivotTable by numeric range.
So, my question is, is there any way i can construct the IF formula (col C) to get a column that i can then group on by numeric range, as a PivotTable row field?
Thank you.
