1. H


    Hello Friends, I am new to VBA and i have trying to set a code up that does the following. If values are entered in any given row of column F. all the columns in that given row will be locked and protected. Private Sub Worksheet_Change(ByVal Target As Range) Set Rng = Range("F2:F999999") If...
  2. L

    COUNTA (with countif) with OR condition

    Hello, You may remember me from before, I was helped to full through three different attendance types. It works lovely and I'm still trying to understand it... haha... I've come into another road bump. I had somehow figured out how to do countif with counta (I did it in a trance and was...
  3. D

    "Blank" cells that are not really blank

    Hello, I have a large batch of data that, once generated has some blank cells in it. I am attempting to count a column of the data, using the COUNTA function, to count the number of cells that have content in them. Upon doing this, however, I realized that the COUNTA function was counting...
  4. L

    CountA issues

    Using COUNTA to exclude blanks – having issues I have a spreadsheet that has 101 rows of data (First row contains column headings) Column B is a text field. There are four blank cells, so the correct count is 96. =COUNTA(B2:B101) returns 96 =COUNTA(B:B) returns 98 =COUNTA(RGIndex!Authors)...
  5. S

    CountA with a Dynamic Range

    I am trying to determine the number of active months for personnel on a rolling 12 month basis. This is the formula I'm currently using but am getting an incorrect result value. I'm new to offset so I know I must be missing something simple. =COUNTA(OFFSET(D2,0,COUNTA(D2:AA2),1,-12))
  6. A

    Dynamic range name when it starts in a row > 1? Counta() does not work for me!

    Excel friends, I would like to setup a dynamic range name for B9:C20. I have tried out too many online examples using Counta(), but those examples do not work for me. B9:C20 starts in row 9, and it is two columns wide. Variations of this formula do not work for me...
  7. V

    VBA Code for Inserting Rows Based on Cell Value

    Hello all, I am trying to create a macro that will perform some very basic formatting. Essentially, I have a dynamic list of records that I want to display under relevant headers. I'm using a counta formula to determine how many records exist under each category. I then need the macro to insert...
  8. R

    Counta with If

    For whatever reason, I'm drawing blanks on this one. I'm currently using =COUNTA(tblCourses[Name]) to count the number of courses I have. I had to add a column to my table, tblCourses[State] and I intend to type "Inactive" if the course is no longer available. How could I modify the counta...
  9. C

    Dynamic Name Range (Blank Cells) / OFFSET & COUNTA #VALUE! Error

    Good afternoonall, First off, apologies in advance for the long post and maybe long windedexplanation. I have asummary which was created using a combination of SUMPRODUCT, MATCH & ROWfunctions with the good help of Marcelo Branco - This works fine and theresults are as expected. However, I...
  10. B

    VBA Worksheet Function CountA using Dynamic Range

    Needing some help using the the CountA Worksheet function in VBA Currently my code runs and the active cell is BG2 (BG IS COLUMN 58) I then want to count the number of non blank cells from BF2:B2 then I want the active cell to go to the next cell down to BG3 then count the number of non blank...
  11. I

    I need URGENT Help

    <tbody> Group 1 P Group 1<strike></strike> A Group 2 P Group 3 A Group 3 A Group 1 P Group 2 A Group 3 P Group 2 P Group 1 A </tbody> I need Results, i have 1000 rows for 15 groups <tbody> Group No Count(P) Count(A) Group 1 2 2 Group 2 Group 3...
  12. C

    Counting the Dates in one column if the value in another column is "X".

    I've tried every formula I could find online and in Excel help. I have a spreadsheet with many columns. Column B contains business tracks; QTD, ATM, PLM, etc. Column I contains the dates new items where added to the spreadsheet for each business track. Their may be as many items listed for QTD...
  13. H

    CountA multiple columns no duplicate counts

    Hey Guru's!! I've done a counta =COUNTA(L4:M10000) which gives me every cell with data. but ....... I also need unique's in that if L4 and M4 both have data it's only counted once? I know it's going to be something simple that i'll smack my forehead in shame for after but you guys always...
  14. A

    Counting entries from dynamic range

    Hello all, I am writing a simple macro to count the number of categories in a dynamic range by: Offsetting the bottom of the range (“SectionInfant”) by -1 CountA the resulting range (B4 to Target) Paste the resulting number in F1 I can’t get the following code to work. Any help is...
  15. BrianGGG

    Array of Counts

    Hello. I'd like to figure out a formula in a single cell that returns an array of counts rather than an overall grand total count for a given list of columns. Example. If I have the following 3 columns and four rows: x x x x x x The answer I am...
  16. D

    counta returning array

    hy i want to count cells not empty in each column to use in functions presently i have row 1 with this information, each column have a counta function (data starts in row3) is there a function or and array formula that would return this array to use in other functions? (allowing to eliminate...
  17. D

    If Statement + Is Number + CountA

    Hello- I have the following data set, which I'm trying to calculate the time spent based on =CountA of the items (columns A-E below). <tbody> Col. A B C D E F G H I Item 1 Item 2 Item 3 Item 4 Item 5 Total Time Spent (mins.) Time Spent - Item 1 Time Spent - Item 2 Time Spent - Item 3...
  18. E

    Dynamic COUNTA function based on user input (row #)

    In cell C2 of sheet1 the user enters the row number of the header row for the 'new_report' tab. I need to count the number of header columns based on which row number the user enters (i.e. user enters 3 then COUNTA row 3, user enters 5 then COUNTA row 5 etc.) The formula below was my attempt at...
  19. S

    Pivot Table question

    I have created a Pivot Table using Distinct Count. The issue I have is the Grand Total number does not match to the number I get if I do a COUNTA for that column in the Pivot Table. Any ideas? Thanks
  20. W

    think right about objects: here, columns

    in a few quick words, how am I thinking wrong when I use Application.CountA( to return the incorrect number of 1, versus Application.CountA(ActiveCell.EntireColumn) to returna the correct count of 109 in my particular spreadsheet? I know I don't need to...

Some videos you may like

This Week's Hot Topics