column2

Guys, Hello Can anyone provide me proper syntax for searching through multiple worksheets. I got Sheet1: Column1 and Column2 Sheet2: Column1 and Column2 My question is How to search just through the Column1 in both sheets. And oh Sheet1 has space between number and letters so its "Sheet 1"...

<tbody> Column1 Column2 2 150% 3 100% </tbody> How do I write, get the MAX value from column2 and Display the name for column1 to another cell in a formula? So the answer should be (2) This is only based on the max value and nothing else.

Hi Folks, I was given an excel sheet today that contained data that was missing a few fields. Sheet1 <tbody> Column1 Column2 Column3 Column4 Column5 Column6 Unique Key1 Data4 Address City State Zip Unique Key2 Data5 Data8 Data11 Data14 Data17 Unique Key2 Data6 Data9 Data12 Data15...

Dear Experts, Sheet1, Column1, Column2, Column3, Column4 Values keep changes live data every 10mins in same one Row2 of 4 columns like below Column1, Column2, Column3, Column4 Row2 = 1, Row2 =,1 Row2 = 1, Row2 = 1 (10 mins) Row2 = 2, Row2 =,2 Row2 = 2, Row2 = 2 (20 mins) Row2 = 3, Row2 =,3 Row2...

Basically I am working with two columns and I want my code to: 1) Check column1 so it knows which row to stop on first (the end), then 2) Change the name in column1 on the condition that there is nothing in the same row in column2 (because we are filling the column2 in with the changed name)...

Hello friends, I have a code which is working good for column1 criteria, but i need to drill down further for column2, column3 filtering.. and then copying those filetered records into another sheet(sheet2). my query is to filter custom rows based on criteria of columns like column1...

In my TABLE, Column1 have this type of Strings: A10 B15 A21 G33 B121 A1000 (THIS IS TEXT) I would like to SPLIT these Strings to Corresponded Columns, so 10 goes to Column A, 15 to Column B, 21 to Column A, 33 to Column G, 121 to Column B, 1000 to Column A, THIS IS A TEXT to Column2. So in...

Hi, I'm looking for a way to concatenate vertically based on column A and B and put it in a new tab: Basically my data looks like this: Column1 Column2 Column3 A 1 DataXx A 1 DataAA A...

Hello all, I am completely new to this forum - so apologies in advance for any redundancies within my question, and thanks in advance for any and all help given. I currently have two columns in two separate sheets: Column1 (Sheet1) contains random numbers (cusips), while Column2 (Sheet2) has...

Hi All, I have access this forum multiple times as a guest and I have found many answers to my issues; however, I have now one problem that I cannot figure out a solution. I would like to ask for your help since I am not a VBA guru and I am new in the forum. Here is my issue: I have one sheet...