repeated values

I want to delete repeated values in excel sheet. I mean if the previous cell contains the same value as in current cell, return current cell value as zero. please go through the screenshot. Please help

hi all, can you help in finding the most repeated dates in a range a1:d4 <tbody> A B C D <tbody> 2/2/2009 </tbody> <tbody> 2/2/2009 </tbody> <tbody> 2/2/2009 </tbody> <tbody> 2/2/2010 </tbody> <tbody> 4/21/2009 </tbody> <tbody> 2/1/2009 </tbody> <tbody> 8/8/2009...

Is there a way I can display consecutively repeated values from a column with column A being my data and column B my formula? Thanks. <!--StartFragment--> <colgroup><col width="65" style="width:65pt"> <col width="65" style="width:65pt"> </colgroup><tbody> Data Formula 7 8...

I have a fluctuating data in column A:A, a Fast MA in column B:B, Slow MA in C:C. I'm going to start with the first formula to compute in Column E:E, which 1. needs to display a prior value repeated at least 3 times consecutively (not in order of occurrence just needs to be in the formula...

Hi All, Good morning..! I have an Excel data with columns OrderDate, Customer, Sales. I want to use this data for a Pivot table. So I need a formula in a column which gives me information about "How often the customers are buying my products". Some examples of transactions. A. Mr. John...

I'm hoping someone here knows a better way than my current method that takes about 6 hours of messing around between Excel and Access as a beginner/intermediate user. I'm working with a table that is about 15000 rows by 18 columns. Column A is a person's initials, and the rest of the row shows...