condense

  1. H

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top