excel 2003 formula

Hi everyone I need help for a formula to count unique values in column A that are blank in column D ...and also to count unique values in column A that are not blank in column D. I use Excel 2003 <tbody> A B C D 3 7/1/2016 17 30 7/1/2016 32 7/1/2016 34 13/1/2016 46...

Hello, I am using excel 2003 and have the below sample data (from a main excel sheet with 1000's of rows). <colgroup><col span="4"><col><col></colgroup><tbody> A B C D E F ID Owner Region Action Date Timestamp 1001 Shawn APR Closed 12/01/2015 12:52:06am 1001 Shawn APR opened...

Hi guys, I'm having issues getting my head around a formula and wondered if you could help me before I throw my PC out of a window! I do not like excel 2003 at all! I'm working across 2 spreadsheets, for arguments sake we'll call them S1 and S2. The result i need from a formula is as follows...

I am using the data auto filte function to drill down to a single variable in a list of variables. When I use the filter to drill down I can get the individual total to change using the formula =SUBTOTAL(9,C2:C5), however I can not get the week over week change to update when using the filter...

Column A ------ acne pimple scar Column B ----- treatment surgery cure medication Column C ------ mumbai delhi chennai ahmedabad pune I want to combine the data and generate all possible combinations such as acne treatment mumbai acne treatment delhi acne treatment chennai acne...

I am trying to translate the following formula into an array that will have the same function, but will be cross compatible with all versions of Excel. From what I have read online, you need to create an array in order to accomplish this. Does anybody know how to translate the formula below? I...

Hi, I have rows that have the following formula in them to give them a "Serial" number: Example of one cells code: =B3+0.01 Every time I add a new row (with a macro that copies a formatted row from another sheet) it adds a 0.01 to the "Serial" thus incrementing the number e.g. Cell...