multiple values

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...

Hi I'm doing a project in college and I really need some help. I have to make a system for a crazy golf company on excel. Basically, I have one worksheet with a bookings form on it and another with a food and drink ordering form. The ordering form works by you selecting a customer ID on a list...

The issue I am having has me perplexed and I can't seem to get it right. Maybe I have just been looking at it too long. I have a list of cells that are item numbered. These item numbers range from 1000 - 10000. Each item number contains data relevant to that item. What I am trying to do is...

Hello, I'm trying to write a formula that passes or fails a value. example: The user types into a cell "ABC 123" The ABC is a constant therefore it is just a matter of IF=(D10="ABC","pass","fail") however the 123 must be equal to another cell (d4) so the formula I'm trying to write looks...

<tbody> I'm trying to extract everything after the L or R (at the end) of the cell below into another cell. <tbody> Column D GL 480+32.2L32 GL 489+01.3L32.1 GL 2+00R32 GL 3+00R32.5 so that Column E will show L32 L32.1 R32 R32.5 </tbody><colgroup><col></colgroup>...

Morning, I'm new to the Mr Excel forums but am in a bit of a loggerhead with a searchable/filterable database I am trying to set up. I have a rough understanding of VBA (mostly I record macros to see what the code looks like then edit it it suit my needs). I'm trying to set up a a spreadsheet...

I need a formula that will calculate the average from a list of numbers in a single cell. These numbers are entered as individual percent values, and separated by commas. An example would be: A1 = [55%, 60%, 7%, 92%] For the above example list, the formula I require would spit out 54%...

Hi, I'm a very lightweight user of Excel and until now have been able to do everything I need to do using the help files and whatnot. Now I need to manipulate my data in a way that is not simple. I have to create a one-to-many relationship and return the multiple values concatenated into a...

Hi I'm used the code below in the past to select from a set of an array (same variables) to copy / paste into the last line it works as it suppose to do it. Nevetheless now the one single rule change, I have to choose from a set of variables within the same range, where the variables are...

I have a workbook with two worksheets in it. In one worksheet called Materials List I have multiple rows that when selected, automate into the other worksheet named BOM. In the Materials List tab, I need columns H and I to combine (not sum, just combine descriptions) into column C in the BOM...

First of, hello to all.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am trying to improve a few excel forms that contain lists of applications and situations. <o:p></o:p> <o:p></o:p> What i am trying to achieve is to have a user select...

Hi, We are trying to create a schedule for our big annual outreach event our non-profit does each year. I am trying to do vlookup which returns data on our judges. However, judges will be judging multiple teams at the same time. For example, judge group 7 will be judging teams 8 & 9. How do...

Hello All, i am working with a database of different products which originate from different countries and i would like that the Vlookup function would return multiple results into one cell. I put an example link below. http://www.2shared.com/file/nDcyCh-2/example.html Thank you all in advance.

Hi, I'm trying to apply conditional format to any row that has textbin one column and no data in two others. ....................Col C.............Col J.........Col K Row 1...........Text a............1...............1 row 2............Text b.............................. Row...

Hi, I have a spreadsheet set up similar to this: <TABLE style="WIDTH: 148pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=197 border=0 x:str><COLGROUP><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 841" width=23><COL style="WIDTH: 43pt; mso-width-source...

Hi. Developing a scoring program for a test with multiple scales with corresponding T-Scores (Mean 50; SD 10). For most of the scales, a single raw score (lookup value and corresponding lookup array) is linked to a single T-Score (index array value) which I have nailed down and done. What I am...

I have a spreadsheet that has a list of products in column A, with date ranges for sales in column B. The way it is now, products with multiple ranges are listed multiple times in column A, and each sale date range is in a separate row, like this: Item 111 | Jan-Jun Item 111 | Sep Item 111 |...

Hi everyone, I have searched all forums and I can't find the answer to this question, at least not one I understand. I will try to make this as clear as possible, so bare with me and please ask if I need to explain something further. I have multiple columns, in the first column "Date" the...

I have a column that has multiple values in each cell separated by a comma (i.e. Z2_2,Z2_3,Z2_4). All of these are in sheet 1, column A I then have a reference sheet (sheet2) of products... (i.e. z1 - received as gift) in 2 different columns (A, B) reference table is B2:C261 . I want a...

Hi, I have given a search on this forum for this matter but I didn't find any solution. I have 4 coloumns (IN, OUT, IN+OUT, IN-OUT) and N rows. I need to know how can I be able to make a SUM & DIFFERENCE between the IN and OUT values. These values, both in IN and OUT, come into a single...