formula & filter

Hi, I am using excel 2010 and in that I have applied CountIF fuction to calculate the number of records that have been processed and not processed. =COUNTIF(Consolidated!W:W,"Processed") =COUNTIF(Consolidated!W:W,"Unprocessed") It gives me the count as per the condition, but I need that I...

This is probably a simple filter, but I couldn't figure this out. I have two columns, I'd like the filter to show only the rows where BOTH columns are not blank. How can I apply such?

Hello Friends of Excel, I want to construct a formula that will list all the products that come in Bushals. <colgroup><col><col span="3"></colgroup><tbody> A B C 1 SKU NAME TYPE 2 78564 Apples Bushal 3 98453 Oranges Sack 4 23453 Pears Sack 5 34546 Grapes Can 6 45673 Plums Bushal...

hello! I have a worksheet with several tabs. I want to take the data from one tab and apply it to another . This is a sample of the info from tab 1. <tbody> 0750010204 Dynamic 0750010205 Dynamic 0750010205 </tbody> What I want to do is apply the information to the new tab so that...

I need to identify (and eliminate) duplicate cells in column "A" and combine/merge correlating cells (cells adjacent to duplicate cells) in column "B" I need to combine so that I don't lose information in the cells in column "B". I was hopeful that I could create a formula that could achieve...

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...

Hi there, I work with huge data sheets that are sometimes more than a million lines long and 80 columns across. Already in my current excel version I have run out of space and cannot even total the amounts, there is not one line left, so I usually use a pivot table to capture totals. However...

Hi, I have a range of rows that contain formulas. I want to sort the rows by the formula outputs but I want to still keep the formulas referencing to the correct destinations. Currently, when i just apply the sorting, formulas reference to the same CELLS, but not the needed destinations. I...

Dear All, Some help on this would be greatly appreciated. I have a column of text data (Column B). I would like this text data to be rolled up in to a single cell separated by commas and for it to be sensitive to filtered results. E.g. If column A has been filtered to roll up the text...