Search results

Please see attached file. I would like to create a Copy/Multiplication Vertical with the logic explained in row 4 (example 1) or row 5 (example 2) I want to insert a text in a column, a number of times with a specific row gap Explanation better in attached Thanks all

I have attached the file with explanation. It is difficult to explain so maybe someone will understand

I want to combine two spreadsheets like in attached file

Looking to Extract/List data for Name1 in F1, list all

Thank you. I the formula above, I would like to ask this : If texts are one word, like Text100 then Wrap is great but if is more then one word like if I replace cell B2 with : Text 100 115 then Wrap will do this : Text 100 115 and so one with others, which I do not want So in formula I would...

If the cell with number is Red, can the associated text to be red ? If cell with number 4 in F2 is formatting RED, can the cell with Text300 in K3 be red

Thank you again !

Like : =IF($E2=VLOOKUP($E2,A2:A7,1,0),VLOOKUP($E2,A2:B7,2,0),"") ...but is to complicated

If blank cell, Nothing, then for 1 say the Description of 1 which is in B2, Text100, then number 4, say description of 4 which is Text300 ,......

In Column A are Numbers, in Column B are Description/Meaning of Numbers. A and B are given. From D2 to J2 I have these Numbers 1 4 19 and I want in Column K the description/meaning of them

I have attached a file. In Column K, I want the description of numbers defined in A and B If cells are blanc, nothing and if numbers are not in A then Error message

So far no, it work for me only if I convert to numbers at extraction, so in $E2 I have numbers. But text number and using the formula , no

Yes, one more info please. How would you change Formula : =IF(ISERROR(MATCH($E2, $A$2:$A$9, 0)), 1, IF(INDEX($B$2:$B$9, MATCH($E2, $A$2:$A$9, 0)) <> "X", 1,)) knowing that in E2:E9, so in $E2, I have not Numbers but Extracted Numbers from Text so my numbers are Text, and formula is not working...

Thanks for all responses. I have attached another file regarding formatting This time I have simplified the requirements, there is a single Criteria (not multiple like 1,2,43. I wonder if the formula is much simple now

Yes, thanks a lot

I do not want to clear rules ! Formatting should apply if there is data in D.

I have one more question here : In Column D12:D18 (where the formating is), if I delete all (so column is clean), cells are still formatted RED so I believe there should be something like, if cells are empty then nothing.

cell red, not text (for second option)

Ok, but the second option, could be done, no ? Meaning, if there in string is only one not Recognized, then RED

I would like to apply a Conditional Format to TEXT in CELL not to CELL, see attachment. If it is too complicated then I want to apply conditional format to cell.

I am back again, something is not right, please see "RED"

YES ! Thanks a lot for all

Like I said, I have started bad, saying Text 0 for Process 0, so in your formula you keep the "Text" and then add after the number from process

Right now, in Table 1 for Process 0, if I change the Meaning 1 from "Text 0" to "abbbacddd" it still show "Text 0" in Meaning 2. And that because "Text" is root and number change with process number.

Well, I found that I may not explained well, sorry for that. Formatting is OK, and thank you for that but Meaning 2 formula, NO. Meaning 1, can be any text, it is a description of criteria. I have induced you in error, saying Text 1 for Process 1 or Text 2 for Process 2. Should be much simple I...