comma separated

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

Hi, I have a column which contains several text separated by commas. I'm trying to see if it would be possible to have a formula which looks at the values in-between the commas and if that value is found on sheet 2 it will display its corresponding value from column two I don't even know if...

Hi there, I was wondering if would be possible to use a cell with comma-separated values that have suffixes (i.e. iterations or repetitions) that in turn translate into the full value in the lookup table. The dataset we use is frankly ugly, but it would be nice if there was a way to make the...

I have a set of data which is hyphen separated as follows: 1-3-4-6-7-8-9 A4 3-4-6 A1&A4 6-8-9 A1&A4 1-3-4-6-7-8-9-0 Not Found My objective is to find the cell location(s) in which I can find the cell string as a subset. If the string is not found as a subset on any other cell...

Can someone help me on my below requirement please. My data looks like this and I want to check the rows matching or not but they are comma separated.. I've A,B columns and want to get the result(Match or not) in column C. ABC1Data 1Data 2Result2abc, bccbcc, abcMatch3xyz, mnoabc...

Maybe I'm going about this the wrong way, but I'm trying to take a cell with comma-separated text in it and expanded it to multiple different cells in a column using formulas. I realize that I can use Data > Text to Columns, but I'd love for this to be automatic by formulas. The whole...

In my excel sheet, I have data like "","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595","" I want to delete the comma within the number, for example in the above example the...

Can you people help me with below query using a VBA code or excel formula (if it is feasible and doestn't take time). I have data in sheet1 where there is ID in column "A" and category in Column "B". category will have multiple text separated by commas. Possible categories are - Production...

Hi In Cell E2 below I have the formula =SUMPRODUCT(SUMIF($A$2:$A$5,MID(SUBSTITUTE(D2,",",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(D2,",","")))),4),$B$2:$B$5)) and it works a treat. However I need the same in G2 to J2 (the ?'s), where it pulls out the values based on the Heading in G1 to J2. Thanks...

The question is in the title, but I've attached a screenshot\edit to sort of get at what I'm trying to do. Let me know if you need any clarification on what I'm trying to accomplish!

Good morning, everyone! :) I have a frequency/sum formula that looks at individuals who meet multiple criteria and then provides a unique number of those individuals. For example, 72 line items match my criteria but only 63 are unique users based off the member ID field. I am running in to a...

1st table/report has cells with single values as well as multiple values separated by comma. <tbody> Identifier AA XY,AA,YX BE RE,WX,EW,XT AB,ER, </tbody> if any of the values in the cell is there in the 2nd table I need to filter the 1st report. 2nd table/report <tbody>...

I have a row of data from B3:B11. Each cell contains a list of names seperated by a comma. To make things more complicated though, the names are grouped by department. For example, the text in B3 looks like this: <tbody> All: John Smith, John Smith, John Smith LOB: John Smith, John Smith...

Hi Friends, i Have a difficult question to explain.:confused: As you see in below table, columns in green i have, column in red i am trying to get as result. Problem statement: Values of B column it should search in range (B2:B5), if a comma separated string is occurring in the range then it...

Sorry if that's a bit long winded...Here's how it breaks down. I've been just hired to an office where they have some cells with several values in them, separated by comma. Something like that: <tbody> ID Companies Names 1 A Albert, Bob 2 A, B Charlie 3 B, C, D Albert, Charlie...

Hello, everyone. Thanks for taking the time to read my post and to try to help. I have one column of comma delimited names (ie, "Bill, Sue, Carla-S, Dave") that I would like to search against another pair of columns -- one that has a single name per cell, and its neighboring column with an...

For every number in Column A, I have a separate list. I would like to check if in next 4 rows, any number came from this list. <tbody> COLUMN A COLUMN B COLUMN C 4 12,1,3,9,4 TRUE 1 1,33,54,99,33 FALSE 26 45,76,88,1 FALSE 4 12,1,3,9,4 FALSE 2 2,51,31,45,67 TRUE 31 22,17,19,9 TRUE...