multiple values

Going to try to make this as brief and simple as possible. My workbook has 3 worksheets, each sheet's data starts at A4, columns are A:F. I'm trying to make my macro read Sheet1!A4:F4 as a single value, then check if it exists in either Sheet2 or Sheet3 (also A:F, not in a single cell)...

I'm trying to set up a quick reference list and I need to list equipment across the page based on their status. - Column A lists what room the equipment is in. - An "X" in B indicates that the equipment is down. - C lists the name of the piece of equipment. <tbody> A B C D E F G 1 RM1...

Could someone help me what formula to use for below? I have values separated by commas in sheet 1 column A (about 500 rows of values) and I would like to have a formula that looks up any value in these cells from sheet 1 column A and if it matches with any value in sheet 2 column A (has about...

I am graphing weekly data in a Pivot Chart over a range of time. The time values aren't stored as dates but names like "14wk01" or "14wk37". Right now the time filter selects multiple items to display so I can see data over time. My ultimate goal would be to include the beginning and end time...

I am graphing weekly data in a Pivot Chart over a range of time. The time values aren't stored as dates but names like "14wk01" or "14wk37". Right now the time filter selects multiple items to display so I can see data over time. My ultimate goal would be to include the beginning and end time...

Hey all, I've been trying to get a formula working based on several examples I've seen elsewhere but I'm getting no dice. Here's the situation: I have a table I'm trying to fill in with data that is coming from another tab. The original data is a list with two columns - one has ID numbers...

Hi Everyone, Hope you can help with this one. Is it possible to have a Worksheet Change event based on different values in the Target? The Code I have is: Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False ActiveSheet.Unprotect If Target.Cells.Value <>...

Thought I'd share this. I have been looking for a way to store multiple values in a single cell while having that cell's value be and display the first, or primary value. I found a lot of ideas that just didn't work but I finally came up with my own that does. In the VBE add a module and creat...

Hey everyone, It seems to me that I am getting strange output of an excel formula and for the life of me I can't figure out why. Could someone explain why I am getting these results? The goal of this array formula is to list all the first names of the people with a certain eye color. In this...

Dear all, I have tried now for several days to solve this problem and would be so thankful for any help. I use Excel Mac 2011 and have the problem that if I want to display the count for values in multiple columns side by side, the count for column 2 repeats the same numbers as for count in...

Hi everyone I have a table which includes the names of people, a date field when something happened, and a value for that date. The list is not sorted and changed regularly. ID, Name, Date, Value 01, Peter, 2013-05-12, 100 01, Peter, 2013-10-19, 104 02, Paul, 2013-12-01, 99 03, Jake...

Hello, Here's my first ever post. Thanks in advance for the help. I'm in sales. I downloaded every transaction made for 2013. The final tally was 7442 transactions. There are 546 different sales people. I have a single column with the name of the salesperson who completed each particular...

Here is my excel example data: Cell A1 = 26,4,12 Cell A2 = 4,4,5 Cell A3 = 0,3,3,3,6,5 I'm trying to get the following results... for MAX: B1 = 26 B2 = 5 B3 = 6 for MIN: C1 = 4 C2 = 4 C3 = 0 for AVERAGE: D1 = 14 D2 = 4.3333 D3 = 3.3333 the number of integers in each cell is variable I've...

Hi, First time poster here and I was hoping someone could explain the apparent anomaly I'm currently experiencing. The Background. We have blackbox program that reads a user defined Excel (office 2010 Excel v14) range and converts it to XML and displays it in Word(2010). While the import...

I need to create a verification list for each employee that contains their assigned roles and the documents asociated with that role. Source Data Table 1: Wherein the supervisor assigns various roles to staff. I have used data validation to restrict the value of each column to either blank or...

I'm trying to average values using INDEX, MATCH where there are more than one MATCH value. For instance (to simplify), in this table, I want to find the average of all "green" values that are "small": <tbody> small medium large red 1 3 5 red 3 5 7 green 5 7 9 green 7 9 11 blue 9 11...

Using a simple column filter I can type in a data value select it and all other content is filtered out. What I would like to do is basically enter multiple values at once. The data has no logical sequence, they're unique SKU numbers on a sheet of about 5000 lines. If I could copy and paste them...

Hello all, I work a lot with urls and I am currently stuck. I'm hoping someone can help! In the example below I have two searches *cart* and *coupons*. I normally use this =IF(TYPE(HLOOKUP(B$2,$C5:$K5,1,FALSE))=2, 1,IF(TYPE(HLOOKUP(B$3,C5:$K5,1,FALSE))=2, 1,0)) to find if either search...

I keep coming across the need for this macro in my work projects, so I would be very appreciate to anyone who can help. I have a sheet containing multiple columns, multiple rows. Column A contains a research participants Subject ID#, and the rest of the rows contain data (gender, visit date...

I have two columns of data. Column A has a category identifier number. Column B has specific item number. Multiple values under column B could fall under 1 value in column A. I need to return all values from column B which fall under a column A category. For example: below you will see in...