simplify

Hello - How can i clean the below formula - =SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name1"))+SUM(COUNTIFS(State,{"CT","DE","PA","NJ","DC","MD","NH","OH"},Value,">10",OFFICE,"Name2")) Please help thanks

Hi guys, Need help in simplifying the below macro. This macro basically filters the data and copies the filtered data into a new sheet. Then below the filtered data it creates a table which is common in all the sheets created. I need help where after the table is created i need to copy a...

Hi all, BLUF: The formula i have works but is messy. Win 7, Excel 2010. the formula as follows...

Hello I have this code working on a form, it's working fine, simply writing the caption to the label in the form (from a cell value in sheet), then checking the offset cell value in the sheet to color the background label in the form I tried using variables, using loops and many other methods to...

Hello I have this code working on a form, it's working fine, simply writing the caption in the sheet if the box is checked... I tried using variables, using loops and many other methods to get the same result without having to repeat the lines over and over but none worked Private Sub...

Hiya, I have some code that I think can be simlified, but I'm not sure how... Sub graph() Sheets("New QC").Select Dim i As Variant Dim rrange1 As Range Dim rrange2 As Range Dim rcol1 As Range Dim rcol2 As Range Set rrange1 = Range(("e8"), ("s8")) rrange1.Select With Selection Set rrange1 =...

Hi - this is my first time posting. I'm automating a worksheet for analyzing raw data from biology experiments. I can do most of the automating - it's pretty simple Excel formulas. But there are two steps that I'm having a bit of trouble with. I think I could accomplish what I need with a whole...

Dear Reader, I need to simplify a worksheet before I can use it. Maybe I can use it as it is but I do not know how. How can I change this: Bui:Regal(1988-1996);Chev:Lumina(1990-2001),Monte Carlo(1995-1999);Olds:Cutlass Supreme(1988-1997);Pont:Grand Prix(1988-1996) Into this: <tbody> Buick...

Hello, So I am performing a sum if the value from a cell is equal to any one of the multiple conditions I am providing in separate cells. The formula I currently have works, however it is very bulky because I have three conditions I want to compare to. This is what I have: =IF(OR($'Complete...

I get Lists of Client names daily that I need to sift through to simplify. I spend a good amount of time doing this daily. I would much appreciate some pointers on how to simplify the process. I initially sort by Term to find items that match the criteria 1030-1060, for the purpose of...

Hello - I'm going to try this again ... I have a nasty looking formula that I was hoping to simplify. It does what it needs to but I feel like I am missing something and maybe there is an easier way? I'm VBA solutions, but I'm pretty new to it so go easy on me! Formula reads...