empty cells

I am trying to create a chart using the following table: ....A...B...C 1...5.......4 2...3.......3 3...8.......7 Formula used in cell B3 is: =IF(SUM(B1:B2)=0,"",SUM(B1:B2)) When I create the chart; it returns showing a "zero" value from that cell. Cell B3 is not really "empty"; How can I...

I am trying to create a chart using the following table: . A B C .1 5 4 .2 3 3 .3 8 7 Formula used in cell B3 is: =IF(SUM(B1:B2)=0,"",SUM(B1:B2)) When I create the chart; it returns showing a "zero" value from that cell. Cell B3 is not...

Hi All, I need help making a macro that will scan for duplicates, length & empty cells. I have the sample file below that does conditional formatting but it doesnt help as much because I want to show the reason for the highlight's on a comment instead. sample file ...

Hi, I desperately need help with a pivot-table and can't find anyone else who's ever had this problem...I have a very large healthcare data table which for simplicity I will describe as follows. In essence the first two columns respectively are (A) location and (B) month. Let's say the third...

Hi, I`m working on a compression of a picture. For most of you that probably is pea-nuts, but I really just stopped wearing diapers when it comes to excel. At this point I have a sheet in front of me with 300 rows (length of the picture) and 185 columns (breadth of the picture). The cells are...

I have a column(for example: b1:b5000) that has cells that have info, and many other cells in that column that are empty. I have copied that column to another worksheet. On the new worksheet, I need to leave the order of the cells with info in the same order, but remove all of the empty cells...

ok im trying to create a sheet for my girlfriend. she has stomach problems depending on what she eats. ive made a sheet so she can put down everything she eats and give it a score out of five depending on how she feels the next day. the problem is i need to add all these scored cells up and...