# condense

1. ### Countifs with Or tidy-up

Hi, Can anyone help condense this please? =COUNTIFS(DatesWork!\$C\$2:\$C\$3000,"GATED",DatesWork!\$G\$2:\$G\$3000,"01/01/1900")+COUNTIFS(DatesWork!\$C\$2:\$C\$3000,"GATED",DatesWork!\$G\$2:\$G\$3000,"#")+COUNTIFS(DatesWork!\$C\$2:\$C\$3000,"GATED",DatesWork!\$G\$2:\$G\$3000,"No Date") Thanks
2. ### How to condense a nested MIN/MAX formula in IF statement

Hi all, I want to somehow condense the red and blue sections below so my formula isn't so bulky. Background: this formula is returning the first or last invoice date for select products depending on drop-down selection. All works fine... But Is there a way to condense this so I don't have to...
3. ### Condense a column (by using formula)

I have 2 columns that is as follow: A B C D 12 0 6 11 0 4 23 3 3 21 4 8 11 0 10 6 17 0 17 0 28 8 10 0 I would like to have in column C, the order from small to large (of column A) based on column B when there is a value greater than 0...
4. ### VBA Code / Formula Help Needed to Condense and Subtotal a Table

Hi folks, This may be too complex, but let me know. I can use some help with some code or macro button and would appreciate it any support. Here is what I am trying to do: The "Billing" tab is our exported data, and only a sample is shown. Rows may extend to 1000. Ideally: Once data is...
5. ### Wanting to simplify this formula - new to forums, happy to be told where/how i should be posting

Hi i knocked up this formula to get the sum of a columnof cells only if the values in the cells next to them were less than 20. =(IF(J15<20,K15,0)+IF(J16<20,K16,0)+IF(J17<20,K17,0)+IF(J18<20,K18,0)+IF(J19<20,K19,0)+IF(J20<20,K20,0)+IF(J21<20,K21,0)) I'm sure there's a way of condensing it but...
6. ### Tips for condensing information

Hi all, I'm new to the forum. My name is Meagan. I have an issue I'm wondering if someone can help me out with. I work at a non profit organization where navigators help patients with their healthcare and call Medicaid for them, etc. We have an excel spreadsheet where we enter information...
7. ### Condense Dates

Hello, I have a report that spits out various dates for individuals and they are all in one cell and look like the following: "10/10, 10/11, 10/12, 10/13, 10/29, 10/30, 10/31, 11/1, 11/5, 11/6, 11/11, 11/30, 12/1, 12/5, 12/10, 12/24, 01/1, etc" Now this is fine for a detailed report, but I...
8. ### How do I condense this code that copies "HOURS" text to next available D field based on value

Set sh = wb.Sheets("Hours") If sh.Range("c2") = "12" Then Set sh = wb.Sheets("Work") sh.Range("D" & Rows.Count).End(xlUp).Offset(1).Value = "HOURS" sh.Range("D" & Rows.Count).End(xlUp).Offset(1).Value = "HOURS" sh.Range("D" &...
9. ### Clean up code for loop to edit other excel sheets

See code below: Sub runallmacros() Dim wbSource As Workbook Dim wsDest As Worksheet Dim row As Integer, os As Integer Set wsDest = ThisWorkbook.Worksheets("File Copier") row = 2 os = 0 With wsDest Do While .Range("K" & row).Value <> ""...
10. ### Code change required

Dear All, I have the following code which is working fine when I am using the columns as under: Module Step # Comm Step 1 Comm Step 2 PD Step 3 Comm Step 4 Comm Step 5 Broner Step 6 Broner Step 7 Broner Step 8 Sub alternative() Dim lr As Long, c(), a, i As Long, k As Long...
11. ### Make Macro smaller and condensed

How would I condese this into a small amount of lines and add additional rows/columns if I needed to Sub Converter() ' ' Converter Macro ' ' Keyboard Shortcut: Ctrl+Shift+H ' Sheets("Unconverted").Select Range("B2:AP2").Select Selection.Copy Sheets("Converted").Select...
12. ### Formatting one row into multiple rows with one identifier column

Hello, So I have the results of a survey and the output given were <tbody> Name Prof Course Description Prof2 Course3 Description Prof5 Course6 Description Prof8 Course9 Description Prof11 Course12 Description Prof14 Course15 Description </tbody> Each row has the responses. However I need...
13. ### helping scaling down small code...

If anyone has any recommendations that might make this a little smaller, I would appreciate it. Its not that slow or long but every little bit will helps. Application.ScreenUpdating = False Sheets("Test Sheet").Select Range("Ash3Freq").Value = ComboBox1.Value Range("Ash3Trgt").Value =...
14. ### Condense rows add data to new columns?

Hi, I have a spreadsheet with 1200 rows of rugs. There are perhaps only 300 rug styles, in varying sizes, HOWEVER the varying sizes are listed in separate rows with unique UPC codes and Item Numbers. (Enter my pain!) I need to condense the rows into one row, the initial row, and show all...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back