exclude rows

Hi Guys, Can you possibly help me of how to code for this scenario: Basically, I need to exclude the data not older than 4 years. However for the computation, the start date is not based from the current date but I want to set the date so a message box will pop asking me what is the starting...

Hi All, I want to average the dollar amounts in a column but I need to exclude those columns that have a zero dollar value and I also need to exclude rows that have today's date. I am lost as to how to do this and any advice would be hugely appreciated! A B C...

1. I have an excel sheet with a column where I want every number should b numbered, but since it’s not sorted in the sequence this number, and when i want to insert a new number for this row, I need to know what is the biggest number that is already used in this column, also I want to make...

<tbody> <tbody> Table 1 A B C D E 1 Interest Clubhouse Dividend Rental Parking 2 5 100 20 0 5 3 Table 2 4 Clubhouse 100 5 Dividend 20 6 Interest 5 7 Parking 5 8 130 </tbody> </tbody> I am trying to create table 2 in descending order...