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...
    • jqadri
    • Thread
    • countif 4 conditions formula & text number counting text & date text & numbers in a cell
    • Replies: 3
    • Forum: Excel Questions
  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...
    • Paul.DeVito
    • Thread
    • identical values number counting number in cell separate numbers
    • Replies: 3
    • Forum: Excel Questions
  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...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top