number counting

  1. J

    Formula to Search multiple criteria of month/year within a cell and return total numbers from a different cell

    Hi All, I've tried countif using substitute, but I know I'm missing something. I can't figure out how to incorporate counting column B (numbers) if SOME of the text from column A matches column C, provide the total numbers of column B. Ultimately, I would need 8 different text to find. I'm...
  2. F

    Trying to modify this 'auto-fill down to the next empty cell' macro to auto-fill sequential numbers instead

    Hi all, I've attached a worksheet with the macro already installed that will auto-fill cell values down through empty cells to the next cell containing data (and so on and so on).. It works great! BUT, I'm now trying to modify it to make it fill empty spaces with sequential numbers. Any help...
  3. B

    Automatically numbering rows in a large sheet of data

    Hi everyone, I've been learning a lot about excel recently from this site while working on a large database of comparative linguistics. I am basically writing out the IPA (phonetic spelling) of a number of different words, for a number of different languages. My spreadsheet looks like this...
  4. S

    Creating a New Suffix for a File Each Time Code is Run

    Hi all, I have a piece of code that runs and creates an output Excel sheet that currently has the run date as a suffix for the automatically generated file name. However, I now sometimes have to run this report multiple times in one day, which currently means overwriting the previously run...
  5. A

    HOW?!? Analyse specific data based on separate criteria

    Hi there, I'm pretty new to this forum but have been using it to help me find answers to excel forumlas for a while. I'm hoping someone on the forum can help. I have a huge list of survey responses which asks people to identify their location and then rate how important 6 facilities in their...
  6. P

    How to Find / Separate a Number from Message Text

    Is there a way to find and seperate a number from message text? These are all errors within the system. Ultimately I would like to identify material numbers that are generating multiple errors. Below are several examples. In some cases, the number is not completely seperated (adjoined to...
  7. D

    Help me in coding formula....

    i am using excel2007 and i'm making a database system here is want... this is my first sheet, the input sheet. Excel WorkbookABCDEFGH12Code No.3DEPARTMENTS4DepartmentHR5SL for Sales6Project TitleMK for Marketing7FN for Finance8Created byOP for Operations910Date...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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