1. Y

    Count null or specific value in a row and display counter in the same row

    Hi, Consider the following table, it is an exam record for students. There is a name column at the start and then the Semester Check column and Semester 1 till Semester 6 columns. I want to Find the missing represented by null, The failures (any value < .4) and Want to display the failure...
  2. R

    Expand array of dates based on 2 criteria (VBA)

    Hi I have a counter with a minimum value of 17. As long as this value is not reached, then extra dates should be added to an array of dates. The extra dates should be workdays: if for example 2 extra dates are needed to reach the 17 value, but the 24th of December is not a workday, yet 23rd and...
  3. F

    VBA Counter that sets itself to the number a specifc word appears in a sheet when excel is opened.

    Hey all, Im currently working on an excel project in which I use a counter. Right now I use following code to reset the counter to 0 everytime excel is opened. Private Sub UserForm_Initialize() counter = 0 End Sub I now noticed that this is actually not what I need. I would need the counter...
  4. S

    VBA: Nested counter within formula

    What I am trying to accomplish is increment my CONCATENATE formula by one. My issue however is that this is already located within a counter that applies the formula to every other row. I have tried to include detailed comments in my VBA code to follow what everything does. In short, in the...
  5. H

    A day counter that resets itself

    Hello! There is value in a cell that shows a percentage - Lets say A1 = 5%. I want to enter a formula that starts counting the number of days when cell A1 changes to a value greater than 10%. Let's say on day 8, Cell A1= 9%, the counter should reset back to 0 days. Thanks and I really...
  6. T

    Resetting Row Counter Loop?

    I have this code here that copies, and pastes from one sheet to another if the match is not found. However, I cant seem to get the row counter to reset to the top of the row. Once it is done looping through a row, it should reset to the second row (as the first row will be a header row)...
  7. S

    Macro For...Next Loop - use counter in FormulaR1C1

    I am trying load Picking Sheets with data from another sheet. I cannot workout the syntax to access the data. Receiving Compile error - Syntax. how do I access the other sheet? Sub Macro4() ' ' Macro4 Macro ' ' Dim OrderCount As Integer For OrderCount = 0 To 600 ActiveCell.Offset(0...
  8. S

    Not counting up

    Hi I'm working on a code to make a copy of my template for every day of the year. All goes well, apart from my counter not counting up to number the folders which are created for every month. This is my code: Function Create_Multiple_Workbooks() Application.ScreenUpdating = False...
  9. M

    Formula to calculate certain dates that will populate rows as separate lines

    Hi everyone. I am hoping someone can explain a solution for me in layman's terms please! I am not great with complex formulas. In my original sheet I have the following data as an example: This can be interpreted as Test Employee needs to attend 123 Example Street every Tuesday and Thursday...

    Include a counter in a VBA macro

    Dear all, I'm using a macro just to suffle a sequence of numbers and then assign that to a button (attached), as follow: Sub Embaralha_seleção() Dim numm() numm = Range("A1:A100") ct = UBound(numm, 2) lt = UBound(numm, 1) ReDim dex(1 To lt * ct) n = 0 For h = 1 To...
  11. lockarde

    Search through sheet and count how many cells are blank in a specific column

    Hello all, I have a spreadsheet that I fill out as customer requests come in - each request typically takes up 3 rows; the first row contains titles for each column (I know this is redundant, but it needs to be very clear for upper management as they sift through), the second row is details...
  12. J

    A loop counter

    Hello. I am working on a workbook that uses random numbers that loops until a certain condition is met; a specific number. I am wanting to be able to count how many times the loop has to cycle until the number is calculated correctly. Essentially a counter of the cycles. Any help is appreciated.
  13. R

    Offset and goalseek

    hi, I am struggling to get an offset to work on a goal seek i am trying to do. Essentially i want to goal seek a value in row1, column1 to zero by changing the value of the cell in row 3, column 1. In the next round of calculations, ie when i apply the offset, I want to goalseek row1, column2 to...
  14. D

    Function that counts how many numbers are in a range are between a MIN and MAX

    I am trying to create a function that will count how many numbers are in a range on an excel sheet, and also between a min and a max number that are also on the excel sheet (Without using any excel formulas, Ex. countif). The range on the excel sheet also includes empty and non numeric texts...
  15. K

    get all sheet names starting with a specific letter

    I have this vba code but it returns ALL of the sheet names. But I want another-one that returns the sheets that start with the letter "D" and list them in column H58 on "switchboard". Sub WORKSHEETLIST() Dim ws As Worksheet Dim Counter As Integer Counter = 0 For Each ws In...
  16. bobkap

    Delete column change counter

    This seems ridiculously easy, but I cannot figure it out after many tries. Scenario: I have approx 35 columns (and rows of course) of data. I want to sequence through each column and delete any columns that meet a certain condition. Here's one of my many attempts that do not work. Example of...
  17. C

    stop counting in a cell when another has a date entered

    i am working an excel file that i need the counter to stop after i enter date in another cell G4 has date entered: 5-apr-19 H4 is the due date formula: =WORKDAY(G4,9) I4 is counter: =TODAY()-H4 J4 is date completed: 9-apr-19 what i need is I4 to stop counting when J4 date is entered
  18. kelly mort

    For loop with irregular step or use arrays if possible

    Hi again, I got something I think is a big problem for me but I don't know what you think: I have a loop like For i = 1 To 100 ......... Next The loop is pointing to numbers in column B. However, all the numbers may not be present. For example, 2 or 54 etc, may not be available in the...
  19. bobkap

    IF w/Not Equal?

    I am trying to delete columns if the header of the column is NOT a header containing the word "Transaction Status" and other headers, but when I run this (below) it doesn't delete columns based on these criteria. It deletes every column. Any help on what I'm doing wrong would be greatly...
  20. SharmaAntriksh

    Converting a sub into function

    Hello All, I want to convert the below Sub Procedure into a function that I can call into Excel sheet. Sub SplitTextIntoMultipleCells() Dim Counter As Long Dim WordArray() As Variant Dim WordList As Dictionary Dim dKey As Variant Set WordList = New Dictionary...

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