value

Good Morning All I have raw data that contains 0's in the price per gallon field (first image. 0 record is first) Second image shows pivot table with a 3.017 average (this includes the 0 value record) Third image shows what the average is not including the 0 value . formula used is...

Hi Forum, Can someone please validate that this is an issue I have a column with large numbers stored as text (ex. 10000001000012) and I am concatenating a date column (ex. 45265) into a larger number: 1000000100001245265 Now if i evaluate this concatenated number with the VALUE() function...

Help please. Looking for a formula to define col D. I want to know the latest known 'Value' from colC (where it is not 0, UNLESS there is no other value). Grouped by 'ID' (ColA), and ordered by date (ColB) To get the latest date I can use "=IF(MAXIFS(B:B,A:A,A2)=B2,"Current","")", but I need...

Hi everyone, Is there any possibilty to simply write value of range variable into cell? See my code Dim SpecifiedRange As Range Set SpecifiedRange = Application.InputBox("Označ myšou v exeli z 3D rozsah kopírovania pre 1 kartu", Type:=8) Dim Range1K As String Range1K =...

I am looking to see if this can be done as a formula but if it has to be VBA code then I can try and get it to work. Basically, This file will track the Ins ( Column E) and Outs (Column F) of Totes. The outs will go out every day but the ins will only be delivered if the route is scheduled for...

Hi I am trying to save the data into the MainInventory but unable to do as I keep getting this error When my sheet is empty and insert the second row as my first row is headers row the data is inserts fine everything works fine but as i enter the third row this pops ups and my vba closes and...

Hi Mr Excel, How to get result in Column Q & S? Given number of range to check for Column Q in M , Column S in O The Range to check in Column G. Example : Cell O6 show 2 number of range , then check how many value < -0.6 in Column G and the result is 1 in Column S. Same goes to Column M for...

hi guys, so in column X my value have formula, so i want to change the format to value only with VBA. can you help me?

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

Remote* Cell values in a named range "MyNamedRange"** have following structure: "U. HeaderName - KeyWord"*** Filters and HeaderName row is in row 10 Objective - Upon Right Click on a cell in above named range: - Filter in Column U using the "KeyWord" * Remote - as in it is not part of the...

Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table. I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code? Sub...

When I type past the end of the cell my text is spilling into the next empty cell. When I add a sum to the cell, it wont spill into the next cell and just cuts off at the end of the first cell. Any reason why this may be happening and how to fix it? Things to note:- The next cell is definitely...

Hi guys, I really need help to set up a logical solution to this. In 'Value' column I want to have a value based on time interval. If a time interval in a cell in Sheet 1 falls inside a time interval in Sheet 2 then take the values shown in Sheet 2, otherwise 40. See image. THANKS FOR HELPING

XERROR allows for conveniently generating most of the Excel errors as output to functions With XERROR, it is very easy to generate all but four of the Excel errors as output to functions. Error types 0, 1, 2, 3, 4, 5, 6, 7, 8, 13, and 14 (i.e. #EXTERNAL!, #NULL!, #DIV/0!, #VALUE!, #REF...

Hello everyone. I need a VBA to compare two sheets and highlights the unique values. I have this VBA, but it also highlights if a cell changed it´s position, which I don’t need. I only need the VBA to highlight which cells have different values and the unique cells in each sheets. Sub...

Hello everyone, I'm having difficulty with how to make a VBA, which compares all the values of a worksheet in another. I tried to do it this way, but it didn't work: Sub CompareSheets() Dim RowSheet1 As Long Dim RowSheet2 As Long RowSheet2 = 1 While Sheet2.Range("A" & RowSheet2).Value <>...

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

Hi Gurus, Good day! I was looking for some codes on how to create a prompt if the data is not the same. I saw this which is workable but I need to apply the condition that if the cell is blank, it should ignore it: ========================================================= "= Existing Code...

Hi all, I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why? Thank you!

How do I enter sequential numbers based on cell value start with D9 and end with D7 (30 years term) and I would like to calculate in range Q3:V14. If I change D7 value to 10 years, in range Q3:V14 should count only 10 years and stop. See my attached XL2BB file. Thank you so much for your help...