ind

Hi I need get data based criteria in column T from Master sheet and paste in 5 differents sheets. My Sheets 1 - Master (200 thausand rows, 56 columns), criteria in column T 2 - Entry_Data -> (Paste here all data based criteria which start 1* and 2*, in column T) e.g 1102, 2353 etc 3 -...

=SUMPRODUCT(--('2019 Sales'!$CR$1:$CR$1055<>"IND")*--('2019 Sales'!$D$1:$D$1055=$A$2)*--('2019 Sales'!$B$16:$BY$16=BX$1)*--('2019 Sales'!$B$17:$BY$17=$A3),'2019 Sales'!$B$1:$BY$1055) Using the above SUMPRODUCT formula - where I have "IND" aim is to sum everything excluding any matches to IND...

Run0time error 1004 : Unable to set Indentlevel property of the range class Someone kindly gave me this code and I am trying to use it in a new spreadsheet. it does indent the rows but them it debugs with the message above. Anyone know why? Sub Indent() ' Dim Ind As Range ' 'this is...

Hello! I try to do a weighted average of data in a single column. Example: <tbody> Module Indicator Type Data M1 Ind 1 A 100 M1 Ind 1 B 80 M1 Ind 2 A 15 M1 Ind 2 B 20 Mn Ind n X </tbody> Simply put, I need to do weighted average per Type for Indicator 2 using Indicator 1. The...

I have a checkbox1 I only want the code to run of the box is checked. (And have a message box if its not checked.) How do I put that If statement in? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ' Dim LastRow As Long ' LastRow =...

Hello, everyone Let's say I have on column A the range of number and on column B the name of the ind. it correspondes to. Is there any way to have a vlookup searching through the range on each cell and returning the ind.? For instance, on cell A2 I would have 01-09 and cell B2 would say...

Hello all, I am trying to summarise Value by IND (column B) and summarise in the 2nd table (columns F - column M). The query I am trying is to match 2 criteria - IND & Value <= value in column E. So , cell F3 & G3 has the count of values for Beta with Value <= 1.2 & Average Value for cases with...

EDIT: Solved Hey all, This is probably something obvious I'm missing, but I've been staring at it all morning and can't figure it out. The code below pulls a bunch of rows from multiple sheets and puts them all together in the "To Do - Ind." sheet. If that sheet doesn't exist, it creates it...