value

Hello, This is my first attempt at Xl2bb. Could you please help me with a formula that can get value only from December month from year given ? Need to calculate year-end balance which is in each year December month. But value can be YYYY format only in L3 column. For example, in Q3 result...

Hi, Does it possible to generate result in Column H? From the past data, the max positive value appear (>=0) is below 100 row. My data range between 250k-750k row...

有一个问题让我很困惑。如图1所示，当我在正常操作中设置除法公式时，显示错误值。但是有一天我在做表格的时候，如图2和图3所示，我发现它不会显示错误的值和公式。当我填写前两个值时，它会自动为我计算结果的值。所以我的问题是这是一个错误还是在哪里可以找到该功能？不加其他公式可以实现吗？

Hi all...I have a query that I'm struggling with, I'm not too sure if I'm going too technical too quickly tbh! I have some values laid out in a table similar to below, I need a formula that can automatically calculate the position of the value in % form. Min Max Value Position % 50 100 75...

Hi, Data contain just 2 value which are 1 and 0. AB1DataResult20311405061718139010111121201301411150160170 Thanks advance.

Hi guys I need to insert two rows after a row with some content like this: To this: I haved found this code: Sub InsertRows() Dim Rw As Long Dim Rng As Range Set Rng = Sheets(1).Range("A4") Rw = Rng.Row Do...

I have an Excel workbook with no external references and no VBA. There are only 4 worksheets in the file and on one of those worksheets, I use the INDIRECT formula to automate getting a value from a cell in a different worksheet in the same workbook. The formula is looking for a value from...

Hi, I am attempting to use two countif conditions across multiple sheets (which I have named "Tabs" in name manager) to count how many times a job is raised for an item with a certain reference number in a particular year of its ownership. I have used a no. of forum posts to get me to where I...

Hi, Can I count the first instance of a duplicate value with multiple criteria? Based on below table we have the following: - 3 unique companies - 3 unique PO's - 12 items across 3 PO's Based on below table I want the following: - Cell B2: This cell should reflect the amount of PO...

Hi All, I would like to know how to achieve this condition programmatically. The main idea is to collect the same "attribute name" for each row for each grouping (column 2) Note: Grouping will be more than 1. like : Logi1, Logi2, Logi3, etc From this : To be like this (result): I had...

hi, how do i select values from my listbox1 (after he gave me values ) copy and paste the value anywhere? my listbox result have 3 cols

Hello, I am trying to make this code work: Private Sub commandB_Click() If Cells(ActiveCell.Row, "G") = "Výtah" Then realita.vytah.Value = True End If If Cells(ActiveCell.Row, "G") = "Konstrukce" Then realita.konstrukce.Value = True End...

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...

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...

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

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...

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...

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...

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...

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...