critera

Hi Mr. Excel. I am in the process of automating some stuff at work, and therefore I would like to sort some data with VBA, based on 3 criteria. I would like so sort some data like seen below: The way I am doing it now is like the following code: Range("G7").Select...

Hi everyone, I'm looking for a different way of writing the below formula. The only way I could make it work was by combining it into an IF function... Basically, I'm trying to make the index/match populate a value ONLY if it meets one of two criteria... the criteria being in cells D1 ("def")...

hello right now i was making a search enggine using VBA with sheet 1 as database and sheet 2 as search enggine i have code like this : my code is search enggine that search a data that contain an alphabet or number where the data being search anyone can change this so that the criteria for...

Hi, I need this code to select multiple criteria, but having real problems. Please help! Dim IndustryColumn As Long Dim foundIndustryColumn As Range Dim copySheet AsInteger Set foundIndustryColumn = Sheets("Consolidated Data").Rows(1).Find("Industry") clientIndustryColumn =...

Hi I've always referred to these forums but I was unable to find the direct answer to my question this time so I figured it was time to create an account. The basic idea of what I want to do is to use tag based logic to find the category that meets my specified criteria. At First I was just...

<tbody> Item # Manu # Vendor # New # <tbody> 46118 </tbody> <tbody> 1650 </tbody> <tbody> 3963-535 </tbody> <tbody> 46973 </tbody> 0531005FG <tbody> 07-397-6396 </tbody> <tbody> 2540-145 </tbody> <tbody> </tbody> <tbody> 07-090-0035 </tbody> <tbody> 4779-073...

Hello World, I think I have a challenge here, or maybe this is an excel limitation. I need to count the unique Ticket Numbers (Column B) for a given month / date range (Column E), but also segregate it out by Place (Column D) uniquely. The table to the left is the source of the information...

<tbody> Products Suppliers doors Harper windows Smith floors Brown lights Smith tables Johnson chairs Jones beds Cooper sinks Jones baths sofas Smith </tbody> Friends, I again request your assistance. I have 2 columns of sales data, A and B. Range A3:A12 contains unique...

Hello everybody, I am trying to find an easier way to look up values out of Database sheet if certain criteria are met. {=IF(A2=1;INDEX('Source Sheet'!$B$2:$B$18;(MATCH(2;'Source Sheet'!$A$2:$A$18;0)));IF(A2=2;(INDEX('Source Sheet'!$C$2:$C$18;MATCH(3;'Source...

So alright, this is a little hard to explain, but I will try my best: I have 3 columns of dates: A, B and C. I have another column of the money in D. I would like to be able to do this: if a value in C2, says 6/16/2014, is in between the dates in A2 and B2, says 6/15/2014 and 6/18/2014, then D2...

G'Day Excel people's, Background: What I have is an Excel sheet set up as a monthly schedule. Currently a file number is allocated to each job manually in a separate Excel workbook and then this is manually inputted onto the monthly schedule. This is a cumbersome timely process (and who here...

Hi, I'm working on Excel 2003. I need to find the average of the absolute values of values in column H only if column C contains the word "Correction" I tried doing AVERAGEIF(ABS(C2:C90, "=CORRECTION", H2:H90) but I'm probably way off. Thanks in advance!