condense

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

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

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

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

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

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

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

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

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

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

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

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

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

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