column1

Hi, I have some task - that looks like very easy, but... I cannot find solution :( I have data like this: <tbody> Column1 Column2 A No A Yes A No B No B Yes C Yes C Yes C No </tbody> And want to get report showing the percent of Yes/Total: <tbody> Column1 Yes/Total A...

Hello, I would like to compare Table1 Column1 with Table2 Column2. If Column1 value =Column2 value it should be printed "Match" if not "No Match". Both columns are formatted as text. I guess, this should be Custom Column and DAX formula.

i did this years ago, but cant replicate what i did. I have Table1 and Table2 and with a relationship of Column1 = Column1. there is only one column in table1 and two columns in table 2. All i want to do is bring in the value in Column2, called junk, into Table1. There are 500,000 rows in...

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.

Can column A (column1) be somehow referred to as a variable? So instead of range(A1:B1) I could use (variableA,1 :variableB,1) or similar

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

How to Vlookup for the last matching value from another excel worksheet.Suppose,my table looks like this : column1 column2 column3 Apple 1 Mango 2 Banana 3 Orange 6 Peach 9 Apple 5 Another Excel Worksheet from which Vlookup has to be...

Hi, I have the following calculated column, that will calculate correctly and quickly. Column1 = CALCULATE( COUNTROWS(Query1), FILTER(Query1,Query1[STATUS]="LN"), FILTER(Query1,Query1[VALID]="VALID"), FILTER(Query1,Query1[LOGIN_TIME]=Date[START])) As soon as I change the calculated column...

I have the following macro to write the value in column 1 based on the available value in column 2 and 3 Sub ColumnValue() Range("A18").Value = "=IF($B$18=0,0,1)" Range("A19").Resize(Cells(Rows.Count, "B").End(xlUp).Row - 18) = "=IF(C19=1,A18,IF(C19=0,A18+1,""""))" End Sub But I want...

Hi Guys, I have huge amount of data to be copied from vertical (two lines) to horizontal (single line). would appreciate your expertise. Thank you in advance <tbody> Column1 column1 100 2 200 4 150 2 20 1 190...

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 everyone, I would like to ask your assistance on a problem. I have column1 and column2 with the total of 20 cells each. I need a dynamic code in VBA that would calculate all blue cells in column1 * all blue cells in column because the order may not be the same. Also, how do I even detect...

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