300

Hello: I created a macro to reformat the following spreadsheet. Column N (Resulting Current Projection) is a formula of: L + M. The formula only needs to be added to any row with code "R" from column B. The problem I am having is that even though I filter code R, the formula carries down to...

Excel Experts, I have a customer who has given me a spreadsheet of about 1,300 words they consider profane. They will be sending me a mailing list of names they want to send samples to. However, they do not want to send a sample to any customer name that contains one of the words they...

Hi I'm trying to write a formula in the grey cells which looks at the contract start date in column A and the current month e.g. DA30 then takes the data from the range in yellow and puts it into the corresponding month..... the start dates will be variable so I want the data in the grey cells...

I need to change my dates (over 300,000 rows in Excel) from the current format (General) of 24.01.2013 to a regular date format of 01/24/2013. What is the easiest way to reformat these values, especially given that I have over 300,000 rows worth of dates.

All, I need a little help. I have a spreadsheet. In Column E (Capacity MB) it list the size of a virtual disk drive. I used the following formula to find all the disk drives greater than or equal to 300,000 =COUNTIF(E2:E373,">=300,000") This returned 10 matches. That is great! Now, I...