count alphanumeric data

  1. ukbulldog001

    Macro to count hyphenated range

    Dear MrExcelites, Need your help in modifying below macro to count hyphenated range as below. Sub ConcatenateRefDesignator() Dim a, w Dim i& a = Cells(2, 1).CurrentRegion With CreateObject("scripting.dictionary") For i = 2 To UBound(a) If Not...
  2. T

    Sum of multiple Cells to give date when it meets criterion

    Hi all, i have rainfall data for 3 years. I want a formula that can give me the day of the month once total rainfall from 01 Jan is equal to 51...
  3. B

    Functional counting specific categories of data without adding to the data / Frequency

    Hi I'm hoping for some help to create some stats on the status of working through client jobs. First I must state that I can't use a pivot table or Visual Basic solution as there is a shared workbook which I don't control. I've simplified client on boarding in an example. I was wondering if...
  4. S

    count confusion - please help!

    Hi, I am trying to do a summary page for an existing hotel bookings spreadsheet. I am trying to do a number of different things which is using more brainpower than I have.:( 1. I have a list of usual guest names all being counted using a countif formula, =COUNTIF('2016'!B:B,"=Guest A") easy...
  5. S

    Help please! - Count Unique with 2 criteria

    Help! Excel Gurus, I've been trying to figure this one out for the past few hours, but am completely stumped. Below is my sample data. TransactionID Date Location 201611609 2016/4/24 A 201611609 2016/4/24 A 201611609 2016/4/24 A 201611611 2016/4/24 B 201611611 2016/4/24 B 201611612 2016/4/24...
  6. J

    how to count the number of times a word appear in a sentence in a column

    <tbody> A B 1 video not working 2 youtube video 3 hello 4 yes </tbody> I have a table where col B is all text. How do i count the number of rows that contain the word "video"? countif(B1:B4, "*video*") doesnt work. Thanks,
  7. G

    Need to Count Text Entries Across Multiple Sheet That Correspond With Criteria in the Same Row

    Hello, This is Military Spreadsheet that involves troop movement so I have to be very vague but I'll try not to be confusing. Here's a problem I'm having. I need to count how many times text (any text/numbers/combination of the two) appear in a column across multiple sheets. Here's the...
  8. C

    Counting the instances of many alphanumeric values across a wide range.

    I'm hoping someone here knows a better way than my current method that takes about 6 hours of messing around between Excel and Access as a beginner/intermediate user. I'm working with a table that is about 15000 rows by 18 columns. Column A is a person's initials, and the rest of the row shows...
  9. C

    Access 2010 Calculated query field

    I am using a query that compares two fields from a large db. This I can do. What I would like to do is - have a calculated field that tells me the number of matches found so I then can perform other calculations such as averages or percentages Etc. In Excel I use the Count or CountA functions...
  10. H

    Count various cell values

    In column C, I generate various values through C%:C9999. Lot of generated values are EXACT. How to COUNT the number of various generated values in column C. "Ledger" & "LEDGER" should be counted separately. Similarly, "Led ger" & "Ledger" should be counted separately. Similarly, " Ledger" &...
  11. H

    Count non blank cells

    I get values in a column R (R18:R9999) which are either values (alphabets, numericals or alphanumericals) or null "" throgh formula. How to count no. of cells where values (serial no. 1) appear? Please someone help.
  12. A

    Counting Number of Students Registered per Semester

    I'm looking for an easy way to take a student's academic plan (for the next 2-4 years) and match the classes that they take with the semester they take it, and then do that for 175 other students and counting. The semesters will change depending on the students, but they all take the same...
  13. 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 =...
  14. N

    Need help with count formula

    Excel 2007 (Windows XP) This is probably a simple fix, but I can't figure it out. I have 20 rows on a spreadsheet. I will be entering data in column B and I want column A to count column B if there is data (anything) entered in column B. I want the count in each cell to increase by one...

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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
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