Search results

I know that this is probably pretty simple but for some reason I cannot get it. I have selected columns A-I, and put in the following conditional formatting formulas: =MOD(ROW(),2)=1 */This is to get zebra lines all the way down/* =$I1="Archived" */This is to strikethrough the entire row...

I have used this formula in the past to check whether a condition was true in two columns. (Excel 2003) and it seemed to work fine. I am trying to count the number of times I have the term 'R1' in column A, and the term 'Onshore' in column I. =SUMPRODUCT(--(ISNUMBER(SEARCH("R1",'Process...

I would like a macro that would hide a row if a specific cell on that row contained text that was formatted with a Strikethrough. So, if cell A25 had text that was formatted with strikethrough, row 25 would get hidden. The range for strikethroughs is A2:A1000. Thanks,

Okay. I have a sheet with a list of items that need to be categorized. An item can fall into more than one category. Other people will be categorizing them. I want to simplify the process for them. So I thought that it would be good to number the categories, then they can add up the numbers...

I have a doozy. At least for me. I am using Excel 2003. I have a two lists of documents. I want to find out if a document exists on both lists. Not a problem. The problem is that there are two file naming conventions in use. The old standard: Document Number_Document...

I found this formula on this site to count the number of closed items between two dates. http://chandoo.org/forums/topic/hot-to-count-records-between-2-dates-and-a-condition =+SUMPRODUCT(1*(A2:A11>=E3)*(A2:A11<=E1)*(C2:C11="Closed")) It does not work for me. I have successfully...

I have this big spreadsheet. It is basically a list of documents that comes from a Sharepoint site dataview. The data is copied and pasted into Excel 2003. There is a column for the filename, and several text columns that help define the document. I asked here...

I am trying to count all the items in Column A if Column D contains a partial string and column E contains a different partial string. So: Column D contains a cell with AB CD EF GH Column E contains a cell with FAST or SLOW I want to count everything in column A only if column D contains...