Hey guys, i have an issue i havent been able to figure out
I have a table that displays a year split into 12 months, I'm drawing graphs for each of the months
My table is not full of data, some days are just empty. When i try to create graphs out of them sometimes they bug out, they never do if i leave no empty spaces but fill them with 0's.
So my issue is, my single cells looks like this: 192 / 7 avg = 27
I only care about the 27 part, so i make a replica of the table with just right(cell, 2) and have the table i want to make graphs out of.
But, i would like to fill all the empty fields with 0's.
I could make a cycle that goes through the cells that checks 1 by 1 and if it doesn't have a value just make it 0
But i would like to keep the pointless computations to a minimum
If i take the replicated table, copy it, paste it in as values and convert it to numbers i can use the data, BUT all the empty cells that i copy pasted, are not actually blank anymore and I'm unable to make any quick selects and fill them with 0
Any ideas how to find the empty, non blank cells? Or maybe my whole approach of right(cells,2), copy paste can be done different
I have a table that displays a year split into 12 months, I'm drawing graphs for each of the months
My table is not full of data, some days are just empty. When i try to create graphs out of them sometimes they bug out, they never do if i leave no empty spaces but fill them with 0's.
So my issue is, my single cells looks like this: 192 / 7 avg = 27
I only care about the 27 part, so i make a replica of the table with just right(cell, 2) and have the table i want to make graphs out of.
But, i would like to fill all the empty fields with 0's.
I could make a cycle that goes through the cells that checks 1 by 1 and if it doesn't have a value just make it 0
But i would like to keep the pointless computations to a minimum
If i take the replicated table, copy it, paste it in as values and convert it to numbers i can use the data, BUT all the empty cells that i copy pasted, are not actually blank anymore and I'm unable to make any quick selects and fill them with 0
Any ideas how to find the empty, non blank cells? Or maybe my whole approach of right(cells,2), copy paste can be done different