text2

Sorry if the title doesn't make much sense, I will try to explain better. I have a set of data on sheet 1 that looks like the following: <tbody> Column 1 Column 2 A B C D </tbody> On sheet 2 I have data that looks like the following: <tbody> Column 1 Column X A text1 A...

The following code works fine, only I would like to insert a line of code to change the text to Upper case and another line to change the size of the font. Any help would be much appreciated: Dim i As Integer Text(1) = "text1" Text(2) = "text2" Text(3) = "text3" For i = LBound(Text)...

Hello everyone, I have an array that has 100 values. The values are text1 & "|" & text2. I need to split this array into two columns. Text 1 in column X and text2 in column Y. I failed to do it. Can you please help? Thanks!

Hi, I have a list of values where i want to use a formula to fill the last column (Q) with the corresponding value q1, q2, q3 or q4 that is defined in the second table. Can anyone help out with the correct formula to do this? thx in advance list <tbody> name value Q text1 99 q1 text2...

Col A Col B Text1 Text1 Text2 Text1 Text3 Text1 Text4 Text1 Text5 Text2 Text6 Text2 Text2 Text2 Text3 Text3 Text3 Text3 Need a formula in column B to copy data from Col A & increment...

I want to find Text1 associated with Max[Date] (here "cat") and use that to create column Text2 for any matching Text1's <table> <tr><td>Date</td><td>Text1</td></tr> <tr><td>11/1/2017</td><td>dog</td></tr> <tr><td>11/2/2017</td><td>cat</td></tr> <tr><td>11/3/2017</td><td>rat</td></tr>...

Hi, I cannot find a solution for my problem. Is it like this: <tbody> A B C D E F G H AB H1 0 TEXT1 CRITERIA1 A= AB AB J5 40 TEXT2 CRITERIA2 B= J5 AC R5 5 TEXT3 CRITERIA3 C= 40 FG H9 3 TEXT4 AB J5 40 TEXT5 MATCHES= TEXT2 AB J5 20 TEXT6 TEXT5 HZ D5 6 TEXT7...

Hi Forum. Hope all is well. I would like help to count the number of identical text cells in a column A. They all exist in sequence as follows: A K Text1 Text1...