text1

Good morning!! To start, I understand that columns can be hidden/unhidden via the Format function on the toolbar. What I need to have happen is to use IsDate to search F2:F40 for a date, none particular, but a date. If not, in the row containing the False return, look at the contents in column...

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

Hi, I have two spreadsheets with the same columns names with similar data. i am try to find the difference between each sheet vs the other based on if a certain value is the same on each sheet in a another column. See below my example sheets for reference to what i am trying to achieve and the...

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

Hi all, I am trying top use the Index formula to populate a column using matched data from another column. However, the column I wish for the data to be added has merged cells so cannot work out how to find the data from a specific location and then add it to any one of the merged cells. Below...

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

Hi Friends , I am trying to calculate value in a cell as soon as other cell of the same row becomes non-blank. For example : Once the value in cell G1 > 0 then system should auto calculate the value in coressponding cell of H i.e H1. Similarly once G2> 0 then value of H2 should be...

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

Hello, I'm trying to find out a solution (macro/formula) for matching 2 criteria and return multiple rows. I have predefined Matrix table with all data: <tbody> A B C D E 1 Header1 Header2 Header3 Header4 2 Text1 x x 3 Text2 x x x 4 Text3 x x 5 Text4 x </tbody> and for...

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