count

I have a macro program where I save the name of the excel file with the values I get from certain cells. After this save, I have to say "Don't save" when asked if you want to save the sample file so that it is empty. Otherwise, it will come with the last values in the next opening. I want the...

Hi, I am looking for a formula that looks between two date ranges (that can be adjusted in cell B10 and B11 of the below) and return the COUNT of data within those ranges. If anyone can help with this it'd be much appreciated. Link to the Google Sheet here: Google Sheets: Sign-in Thanks Ryan

I am writing a Sub to identify the longest Collatzs Sequenze between 1 and 1000. How do I need to implement an inner while loop to count the steps of the inner loops to identify the longest Collatz sequence? Sub LongestCollatz() Dim i As Long Dim maxSteps As Integer For i = 1 To 1000...

Hi, Specific Value = 0.1 BCD1DataNumberResult20.430.140.250.13260.570.11180.590.1100.2110.2120.1130.1140.3150.1160.284170.9Description: 1. C5 number is 3, so count 0.1 in B5,B4,B3 2. C7 number is 1, so just count 0.1 in B7 only 3. C16 number is 8, so count 0.1 from B16 -> B9 No count if there...

I have a set of data in which two columns define a start date and end date - I'll call it my Census data. I have another dataset, call it my Day of Month data with one column that has individual dates of a month, i.e. 7/1/22, 7/2/22....7/31/22. In the range of start dates and end dates in my...

Hello I have a simple spreadsheet in which I keep track of mortgage payments. My mortgage repayment term is 22 years and 11 months. Beside each months' payment, I would like to count down the number of years and months left. For example, 22 years, 9 months > 22 years, 8 months etc I just...

HELLO, everyone. Im trying to figure out how to this conditional formatting. In the photo below shows the week schedule, where the desired input is the text "A". While the numbers below is the count for this "A". So my issue is to create a conditional formatting that anticipatedly highlights...

Does anybody know how to make excel count rows sequentially. Where if there is a different text, it will stop counting to that number until a desired text is given? like for example at A2 to F2, has two possible letters to be inputted. First excel counted 2 As from A2 to B2, however it stopped...

I am attempting to count the number of cells in column A that are formatted with different colors (Green, Yellow, Blue, Orange, empty, etc.) and place the total in column M. I have tried =countIf( ...) and many others. Is there a Filter command I can use? Any advice is welcome. I thought...

I’ve been able to make macro’s to do one or the other but have struggled to combine them. I need it to be able to check if the first three characters are a match and check if the cell has strikethrough before counting.

Hello all, I am having a problem, I thought I got it all figured out with sumproduct function. However, it doesn't work as it should. I am trying to count all the cells containg "2" in columns AM:AO, but only if "1" is found in columns AJ:AL. Ideally a formula that can be further filtered, for...

Hi, I have a file which has ~10K rows of data. I want to create a Pivot table removing duplicated values based on the name column this gives me ~2k but I want to capture the data that is derived in a column that contains a tag. The problem is that when the tag is generated there are many...

Hi Folks. Working with about 1000 rows of data, I have numeric values in column D not sorted but recurring at random intervals. Column A contains names. Those names can and will be repeated. I'm looking for a way to say if the cell in column D is equal to 000415 then count the unique text...

Hi there, I am banging my head against a wall trying to have a formula that would instantly count from 1 to 100 and then reset infinitely. I assumed I could do 1 to 100 twice and then use the fill handle but that causes excel to assume I want 1-100, 1-100, 200-300, 1-100 etc Now...

Hello, I'm looking for a formula to return the most commonly occurring text in a range minus a specific phrase. Is there anything I can add somewhere into the formula I already have, which returns the most commonly occurring text? Or do I need to rewrite what I already have? Here's what I have...

I have a code to Export/Copy Data from Pdf to Excel using Word. (I have included the code below) So the code should create a Word file and import the selected Pdf file and copy every page as a table to word and then to excel. the code should run with in "tbindex = 0 to wDoc.Tables.Count" Range...

Hi all, Hoping someone can help me with this formula: {=SUMPRODUCT(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]"))} Which is returning 0 Or, =SUMPRODUCT(SUM(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]")))...

Hey everyone, I have substance measurement data from water quality checks. The data is listed in a table starting with the date (dd/mm/yyyy). Above the table are the norms. The variable norms are in green. Those norms are generated on a second tab, and change (sort of) weekly. I need to...

What I'm attempting to do: copy all the rows from an open workbook, insert them into my other workbook that is a template, between to placeholders with formulas. my data in the template goes from A:CE. I've got the first part working where I insert the rows, but I don't know how to paste formats...

Current.png shows a simple example of my dataset. I want to count every value in column furniture and eventually get the dataset as shown in wanted-outcome.png. However, the code needs to look at the column name and not the column number. I want to use the vba for different sheets where column...