range

Hello. I need a formula that looks for the value in a cell and compares it to a range of cells to throwback if there is a match anywhere in the range of cells. I would also like the formula to exclude considering blank cells so I do not end up with false No Matches. Example of the data is below...

Hi all, I am trying to find the way to obtain the minimum value from a range, with some conditions. So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...

Is there a way in excel to have a select range of columns in a row following a reference cell? Situation: I have a set range that is part of a data pull and populates information off a reference ID# that I pull in from a data set. The downside is that I have some manual cells that I use for...

Hello, I’m not sure this is the best way to go about it.. But I need code to get a specified range in a macro. The range is variable .. so I’m trying to use keyboard shortcuts like “ctrl + home” and “ctrl + end” to get the correct range. The problem is when I start let’s say at the bottom...

Situation: I have this VBA code that logs any change that is made in the excel sheet and that great; but i need it modified. The plan is to use this in one column as a master change log. But i need a sepret one that will log the window user ID / DATE / Time and lock it to the ROW they edited. So...

I found this by Snakehips and it was VERY helpful ! I tried to modify it but found that it only works with numeric entries and not alpha numeric entries. Rich (BB code): Sub Fill() [A4] = [A1].Value ato = [B1].Value [B4] = [A2].Value bto = [B2].Value [C4] = [A3].Value...

Hi, I really hope someone can help me make this drop down list. I have a cell that a user will type in a acronym. Cell B1 I have a range of acronyms in a separate tab (about 700 of them). I would like the user to presented with a drop down list of cells within the range that contain those...

Hi, ABCDE1± 0.00001explaination : ± Custom (in this case ± 0.00005)explaination : 21.22122Valid Numbers : 1.22121 , 1.22122 , 1.22123Valid Numbers : 1.22117 , 1.22118 , 1.22119 , 1.22120 , 1.22121 , 1.22122 , 1.22123 , 1.22124 , 1.22125 , 1.22126 , 1.2212731.22127RESET. New Valid Numbers ...

I have part of my code below and it requires a little tweaking. Breakdown: I have two worksheets, one called PivotTable and another called PerC. In my PivotTable worksheet, there is a value in Q2 that generally changes every month. I want it to go through column J and find any values that are...

Hi all, I need your advice if possible. I have a dataset which i am trying to determine between blank rows with variable blocks of data ranges in Column R to see if the numerical values are the same within the range and if the value are the same I want "True" and where its not exact "False"...

Hi, I want to look up a number that is in column D from column E, and if it is found in a table on a different tab in column A rows 9-109 put the work 'Expenditure' in the lookup cell in column E, and if the number found from the lookup is in column A rows 121-160, put 'Income' in the lookup...

BCDEF1MAX 3 numbernote:MAX 2 numbernote:2122,1271st number : 122,1271st number : 122,1273122,127114122,127115122,12012nd number: 122,12012nd number: 122,1206122,12213rd number : 122,122RESET. 1st number : 122,1227122,127112nd number: 122,1278122,122119122,1221110122,124RESET. 1st number ...

I appreciate you all in advance. I want to change the meta range of below code (meta range:M31:AM53) to 42 separated ranges below...

I would like to consolidate columns A2:I2 based on the criteria that A2:D2 are the same on the next row. I have attached photos of the whole document to provide how this is supposed to work. I cannot seem to figure out consolidation and I maybe overlooking it. I have the code pasted below...

to all Is there a way of checking when the 1st cell in a range is used see below Sub macro1() Dim rgcurrentrw As Range Set rgcurrentrw = ActiveSheet.Range("A2:E2") Dim strout As String 'what I have currently For Each cell In rgcurrentrw strout = strout & "," & cell.Value Next cell...

Been using the below VBA for years - no issue. All of a sudden i get a break on the bolded line. Guessing something to do with how I use 'Range' as everything else in VBA referencing 'Sheets' is fine. Any advice would be greatly appreciated: Sheets("Blotter").Select Range("AE2:AH2").Select...

= Table.AddColumn(Source, "Custom", each {Date.From(Date.StartOfMonth)..(Date.EndOfMonth)}) I am trying to create a custom column but I keep getting this error:

Hi, I have the following formula which is inserted on sheets through VBA code: =SUMPRODUCT((B3:AF3="AD")*(WEEKDAY(B2:AF2,2)<6)*(ISNA(MATCH(B2:AF2,HolidaySheet!A2:A3,0)))) The A2:A3 range contains two holiday dates which are on a separate worksheet. The holidays change depending on the year...

Hi all, I wondered if there was a clever/efficient way of checking if multiple columns with dates in, fall within a date range, see below table. I want to check if any of these dates fall between the 25/12/2022 and the 02/01/2023. I know I can do repeating if statements, but thought I'd check...

hello, I have had a look through quite a few posts but can't quite find what I'm after. I need to use some VBA to select everything between "START-OF-DATA" and "END-OF-DATA" These will constantly be moving when more rows are added in-between, but I don't want to have to keep changing the cell...