settlement

I am trying to delete columns if the header of the column is NOT a header containing the word "Transaction Status" and other headers, but when I run this (below) it doesn't delete columns based on these criteria. It deletes every column. Any help on what I'm doing wrong would be greatly...

Good Morning I am having a small issue with the following formula =SUMIFS('DVP Settlement Report'!P:P,'DVP Settlement Report'!E:E,"Sell",'DVP Settlement Report'!V:V,FALSE,'DVP Settlement Report'!R:R,C7) This formula returns a zero value (as it does not recognise the FALSE value) (I have tried...

Dear All, I have very hard question. Criteria's Cell G2 I'm looking for Sales Agent named 'A' Cell K2 looking contract status of 'Settlement'. Cell L2 $500,000 I'm trying find out row number when the Sales Agent named, 'A', first surpasses cumulative settlement sales of $500,000. I have...

Hi, Need a help on following, I have 4 selection on column G which includes Working, Left, Vacation, & Final Settlement. I need to Color cell column from A TO B if i select Left, Vacation or Final Settlement. Can you help me on this. if The cell H value is left or vacation the cell A & B will be...