I have a data sheet that I would like to make a pivot table or another sheet off of with a specific customer number and then day of the week.
Below is an example of some of the data.
Column E is customer numbers. I would like to make a table or sheet using specific numbers from column E and...
I am trying to figure out how to create a message box that appears based on multiple criteria. I have tried doing research and still can not figure it out. I know minimal VBA, though I am confident it is possible.
I currently have a workbook that my project manager enters his crews...
I am getting nth smallest value with multiple criteria but couldnt get the position of it.
I need postition to lookup other values in the same row of the nth smallest
I used the following formulas
No issue with this...
Hi, I'm knew to this and would appreciate any help provided. I read somewhere that there is a limit to the number of terms that one macro could handle. I need a VBA script to delete multiple rows in column “A” based on if the cell has (ANY) reference of over 150 terms.
For example, if I want...
I have data similar to whats shown in the "Orig Data' table. I would like to pull unique Names only, based on two criteria (Start Date <= today AND End Date >= today. I would also like the data sorted (oldest to newest) based on the Name's corresponding End Date . My goal is to have a...
I'm struggling with the below VBA. I have data In cells A6:S1176 and headings in cells A5:S5.
I want to filter column A based on the value in B1.
I then at the same time want to always filter out anything minus or below 0 in column G.
When I run this macro though I get this error message...
I have a spreadsheet with the following 4 columns – Group,Type, Day Rate, Night Rate. Each row ofeach column has a drop down selection list. Based upon the selections made, I want the spreadsheet to populate theappropriate Day Rate and Night Rate. Data regarding the rates is in a...
I am using below macro to auto filter on col D and Col F on worksheet "confirms" with below criterias and then trying to copy col P and Col S filtered data to another worksheet names "Non=Cash Trades".
the below code is autofiltering only col D with "N" and Col F with "COD" not "F/D"...
Requesting help with setting up a macro to autofilter multiple criteria, copying visible data only, and selecting and pasting sections of the data at a time into another worksheet in the file.
Here is a previous post that works for single criteria...
I'm trying to develop a Index/Match function in VBA with multiple criteria (using the "&" as in an excel function) - but it doesn't work.
Does anybody know what I'm doing wrong?
Function prove(X As Range, Y As Range, Z As Range)
A = Application.WorksheetFunction.Index(X...
hi, two questions: wondering what the most efficient way to write these would be - without just combining multiple countif functions on top of one another to do this without using an array?
1: count the number of times any of the following appears in column R - ABS, BND, or FUND; while...
I've started playing with VBA some days ago, thus I'm new with Excel coding.
Below is a simplified version of the sheet I want to extrapolate the data from (sheet name "Data"):
I have two issues that I am looking for help with.
The first, is to create a dynamic list of results for items matching "Horse" in column J on Sheet 2!, "Ball" in column I on Sheet 2!, and that do not contain the word dog in column A on Sheet 2!
The second, is that while I have calculated the...
This is me first time posting on this forum, so hoping someone can answer.
I have data in the below sample format. I am trying to get a record count when the values in column 1(Week) and column2 (Name) match together. For example, User1 has three entries for 7/14/2018. So in column3, I...
I am trying to construct an IF Function for the following problem:
5 collums of data (A,B,C,D,E) and 33 participants.
define person as 'high risk' if either '3 out of 4 values (A,B,C,D) are smaller than 10' OR if '2 out of 4 values (A,B,C,D) are smaller than...
I toyed with this all day yesterday. Been working away at it all morning and still can't whip it. I think it will be relatively easy for someone with some VBA experience... I'm just not quite there.
So, basically, Ron de Bruin's code from this page works great. Does just what it's supposed to...
I need a formula to return a unique list of values in (A3:A6) of values from (D2:D6) that are in the column (E:H) that match the criteria in (B1) and have an "x" in Rows (2:6). Need column searched to change based on value in (B1). Thank you:)
I have searched all over for a solution to this and I am beyond flummoxed. Don't let me down...
My data is in two columns (Diagnosis and Date) and I need to know the 1st - 3rd most common Diagnoses within a particular date range.
Down's Syn 12/5/17...
Hi Everyone -
I'm looking to create a sum formula to capture multiple criteria and I am open for suggestions.
Below is a sample of a table on a worksheet (we'll call this one PRODUCTS):
1/2" X 3" X 3"
1/2" X 4" X 4"
1/4" X 1 1/2" X 1 1/2"