count rows

  1. A

    Count of rows after MAX value before recovery, help please.

    Hello everyone - I could certainly use some help, please… Col CS is a running total of sums. (But not every row contains a sum.) Col CT, (helper column) I have: =MAX(CS2,CT1) Col CU has: =IFERROR(IF(CS2=CT2,0,MAX(CU1,CT2-CS2)),"") to help find the drawdown of theses sums, until a new...
  2. D

    Excel Formula to Count Rows Based on First and Last Occurrence of a Specific Text within a Series of Strings.

    I am trying to write a formula that will count the number of rows between the first appearance of a specific text within a string, and the last appearance of that same text. For example, if Column A contains the following values... Email sent 12/15/2017. Email sent 12/15/2017. Sold in 2017...
  3. G

    How can I count # of rows that match a criteria in multiple cells within the same row?

    Hello, I've been trying to figure this out on my own and had no luck. What I'm trying to do is sum up # of rows that match across three parameters - Course, Unit, and Activity #s. I have two sheets with this information: Sheet 1: Sections <tbody> Document No. Course Course Name Unit Unit Name...
  4. J

    Loop Counting - Stop and Start based on a blank row

    I would like to loop count different sets of data. They are separated by a blank. Here is the VBA i have for counting but I want to make it loop for each data set. Sub RowCount() Dim countnonblank As Integer, myRange As Range Set myRange = Columns("A:A") countnonblank =...
  5. J

    Count the rows of Variable Tables Multiple times - Separated by a space

    Hello, I have a spreadsheet with multiple variable tables. I would like to get a count of rows for each table. The tables are separated by a blank row. Is there a way I can do this using VBA? The pattern could look something like this. 4 rows of data blank row 3 rows of data blank row 7 rows...
  6. E

    Divide and export the data according to these instructions

    Hi MrExcel Community, my name is Dominika and I'm looking for a VBA code help. I need to automate some of my Excel work for the sake of completing my dissertation on time, but I'm new to VBA. I have data that have following columns: year quarter code number1 number2 The data are properly sorted...
  7. A

    Count Rows

    Hi, I am looking for a formula or VBA that count only the rows containing the word Yes. In this example the result should be 3 (row 1,3,4) A B C <colgroup><col width="70" span="3" style="width:52pt"> </colgroup><tbody> Yes No 1 No No...
  8. S

    Counting Non Empty ROWS based off of multiple criteria

    I would like to count the non empty rows that meet specific criteria. I have a very simplified version of my data in the table below (my table is much larger and is confined to excel). I can count the non empty cells that meet multiple criteria by using a sumproduct formula...
  9. E

    Counting Rows and Columns in Folder

    Hello Folks, I want to create a macro that will allow me to select a folder and then open each .xlsx file and count the number of rows and columns in each spreadsheet. (for now i want to assume there is no tabs) Then i want to display the name of the .xlsx file in column A and display their...
  10. N

    Count rows, divide by three, copy 1/3 to to each column

    I have spreadsheets that are created on the fly that can have 1 to hundreds of rows. There is always only just one column. I need to create 3 columns in the active spreadsheet from these results using VBA. So I need to count the number of rows, divide this number by 3, and put the second third...
  11. M

    Count rows and insert formula using row counts in VBA

    Hello All, I have a spreadsheet with data about what information in a database has been reviewed or not (data is reviewed on a “page” by “page” basis, per subject).</SPAN> The data looks something like this:</SPAN> <TBODY> SITE #</SPAN> SUBJECT #</SPAN> VISIT NAME</SPAN> VISIT DATE</SPAN>...
  12. H

    Formula to offset based on a change

    Hi, I'm looking for a formula that will take the cells used as a heading and place them cell into columns with the corresponding rows under the heading. I'm thinking that the formula will have an offset that counts the blank cells in column A then place the text from the heading cells (by...
  13. A

    VBA Use Row Count to Copy and Insert same number of rows

    Hi I wonder if anyone can help – I have 2 separate spreadsheets within the same workbook. Sheet1 contains several rows of basic data. Sheets2 contains a single row of formulas which calculates based on the first row of data in Sheet1. Using VB I would like to count the number of populated data...
  14. H

    elp with counting the number of rows matching 2 criteria please

    Okay so I have the following information below and I want to count the number of Green, Blue, Amber and Red scores that each risk ref has. But I don’t want to use a pivot table since it has to be automatically updated every time the source data is changed. <?xml:namespace prefix = o ns =...
  15. amitcohen

    Macro to count rows in files that seats in another folder

    Hi All I have a folder 'ClientsData' that contains over 200 files. Each file have an average of 21 rows of data. (some more..some less..) The data seats in column A only. I have (separate) an Excel file that contains the list of all the files that in 'ClientsData' folder. The file names are...

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