value

  1. G

    How to find the 2nd largest value in a series of data that may contain multiple incidences of the same value?

    Hi, I am trying look for a function or a solution to finding the second highest value in the array of data that may contain multiple instance of same values. for example: array = [31,28,31,27,28,29,26]. The LARGE function couldn't help me because if I pass arguments like LARGE(array.2) it will...
  2. M

    Pasting to a Row with a Specific Value in another Workbook

    Hi All, I am quite new to this and I have gotten so far but I can't seem to find a structure to do what I need to do. Below I have attached Workbook1 and Workbook2. I can move data from both workbooks, but I was to paste to a row/column that has a specific value in Workbook2. In my code, I...
  3. ibmy

    Sum of Negative or Positive, Exclude 0 or Include 0

    Hi Excel Experts 🥇 Sample of 20k row data I face weekday : BCDEF1Sum of Negative Sum of Positive2ValueExclude 0Include 0Exclude 0Include...
  4. ibmy

    Identify Number Pattern of Positive(+) -> Zero(0) -> Negative(-)

    Dear Smartest Excelers, Some of sample from my 90k row data: ABCD1DiffResult2030.440.552.36070809-3.91B5(+) -> B6:B8(0) -> B9(-)10-0.1Rule 4: Start new find110120.4No count : B10(-) -> B11 (0) -> B12 (+)13014-0.51B12(+) -> B13(0) -> B14(-)150Rule 4: Start new...
  5. C

    #VALUE! Displaying instead of " "

    Good Afternoon All, I wonder if someone could point me in the right direction with a formula that returns #VALUE! when the formula is not True. The formula I have is: =IF(day(B71)=3,"Queen's Platinum Jubilee",""). So when B71 doesn't equal 3, I'd rather display a blank cell rather than the...
  6. E

    Count each Value from a List of Values in a Column

    I have a list of passages in one column and a list of words or phrases in another column. Then I have a third column reserved for how many times each word or phrase appears in the column with the list of passages. For example: In column A (List of passages), A1: The red fox jumped over the red...
  7. D

    Excel conditional formatting does not work!

    Please help, Super simply: I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting: As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...
  8. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  9. M

    assign Incremental numbers in new column based on criteria from two columns

    I am looking for assistance in setting up a formula to return incremental values to a list (including duplicates) only when selected values are present in a different column. Please see the example attached, if the produce is apples, banana or peach assign the number (1,2,3) representing the...
  10. s_macloskey

    Add +1 to a cell value (plus complications!)

    Good morning all, I have another VBA/AcitveX/Button query that I hope someone can help me to solve! Also please forgive me as I don't 100% know the QUESTION I am asking, I just know the result I am after. (I have also have to redact some of the information becuase of where I work.) Context...
  11. S

    Find and Replace Across Specific Sheets based on a Data set with correct names

    I have a list of correct and incorrect names as seen in sample file below. I am trying to loop through a list of sheets and do a find and replace for each item on the List. The Correct Name is what the replace is going to be and the Incorrect Name is the find. I have looped through specific...
  12. ibmy

    Count if the value is positive and negative 'itself'

    Hi, Column A // Column B -0.1 // 1 0.1 // 2 -0.1 // 3 0.3 0.7 0.2 // 1 -0.2 // 2 -0.2 // 1 0.2 // 2 0.7 // -0.5 // 1 0.5 // 2 -0.5 // 3 0.5 // 4 0.5 // 0.3 // Rule: 1. The starting value can be negative or postive 2. Reset the count if :- i- value is...
  13. U

    Format date in function as value

    Hi all! I'm new to this forum and I'm not quite an expert in VBA, but I'm trying. I use this function to get the filedate time from a file: Function GetFileDateTime(R As Range) Set R = R.Cells(1, 1) GetFileDateTime = format(filedatetime(R.Value), "dd-mm-yyyy hh:nn") End Function This works...
  14. SewerUrchin

    Non-reconciling formula in Nested IF AND statements

    Hello: I worked for over an hour last night trying to get this darn formula to work and have been unsuccessful. I know it is probably something stupid, but my brain won't get to the solution for some reason. I split my home with another and we use a list to keep track of expenses that we both...

Watch MrExcel Video

This Week's Hot Topics

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
Top