zero

Greetings excel community, I have some cells that contain a zero and I would like to replace the zero value with the value from the preceding row (the cell above). I saw a formula online which is as follows:=INDIRECT(ADDRESS(ROW()-1|COLUMN())). However, I would have to copy and paste this value...

Hey all, Thanks for taking the time to review my question. I must be missing something simple but for whatever reason I am missing something. In "Tab A" I have a list of "A" names, "B" dates and "C" total hours, In "Tab B" I have "A9:A39" each date of the selected month, "A1" the name I want to...

Good morning, everyone! I am trying to create a dynamic chart in Excel. However, I want to hide the columns in Bar chart with contains zeros because it looks too much crowdy. I used the zero filters, but it hides for me the whole column. my problem that each category has 4 bar chart I just want...

Hi Mr Excel, How do find Number Pattern in data which is : 1. Starting a Negative value ( - ) 2. Follow by at least a Zero ( 0 / 00 / 000 / 000..... ) 3. Follow by a Positive value ( + ) 4. End with a Negative value ( - ) Number Pattern : - 0 + - When Number Pattern found, assign "1" at...

Hi, I am running a macro to create some charts, my orange line is on the primary axis with the blue and purple are on the secondary. I need the secondary zero point to start at the same as the primary, is there a change to my VBA code that would do this?? Also... how do i change the colour of...

Hi guys, desperately seeking help :-) I am attempting to Multiply a cell in another cell by using PRODUCT, my problem is this . . . A1 is a currency format cell which is then multiplied by A2 with a number format, I cannot for the life of me figure out how to have A3 show a zero in currency...

Hi Excel Experts ? Sample of 20k row data I face weekday : BCDEF1Sum of Negative Sum of Positive2ValueExclude 0Include 0Exclude 0Include...

Hi everyone, I am having issues counting the number of Males/Females that were enrolled in a study during the month of March (3/1/20-3/31/20). I'm not sure why, but when I try to use the COUNTIFS formula to figure out the number of females that were enrolled in March (between 3/1/20 and...

A frequent question on the forums is "how do I not display a zero?" There are several methods to do so, each with their own pluses and minuses. I will explain the various methods here as a guide, and the interested user can choose the one most suited to their situation. Consider this...