I have a question control txt file.

One file contain 4 column and if I want to cut rows except maximum values in the columns

1.Check First Column Name
2.Check Last Column Values.
3.Remove depends on First Column and Last Column.

Test1 500 400 200
Test1 499 400 200
Test1 499 399 200
Test1 498 100 100
Test2 600 200 150
Test2 600 199 150

I have a worksheet with 2 columns of numbers (column A and column B) and I want to populate a 3rd column (column C) with values that only appear ONCE in both columns. That means any value that appears in column A and does NOT appear in column B, and vice versa. I've been looking for a solution all day and can't seem to find one.

I have two columns in MS Excel/LibreOffice Calc/Google Spreadsheets with numbers. I would like to count the number of rows which have identical values in both columns.

In the following example:

Column A | Column B
1 | 4
2 | 2
3 | 5
3 | 3
5 | 3

there are two rows with equal numbers: rows 2 (2=2) and 4 (3=3).

So there are 2 columns that I want to check for specific values and then add the values from another column in those rows.

So something like this:

Search all of column A for "text"
Say it finds "text" in A1, it will then check B1 for "text2"
If both of these conditions are met it will take the value of C1
It will search all rows in the worksheet for these conditions and give the sum of the colum

Hello to all.

This is first post. Kindly excuse me if I do not adhere to any rules and regulations of this forum.

I have a file containing some rows with three columns each per row(separeted by a space). There are certain rows for which first two columns have same value but the value in third column is different.

New to Hbase, don't have hive or impala configured. :-(

wanted to scan rows of a table based on multiple column values let say having Table A with 4 columns aa, ab, ac, ad. I wanted all rows of the table which satisfied the values condition of column ab & ad.

And other query is how to query on multiple tables assuming have external key are presents in the tables.

I have two columns in a spreadsheet both with text values and over 30,000 rows. I need to highlight the cells in column B if the text from column A exists in column B. So, if the text in A23 is found in B23, highlight B23. I need this done to all the rows in a single formula.

I have the following columns:

bonus1 bonus2 bonus3
1 2 3
4 1 2
3 4 0
0 0 0

I want to count each row once if the any of the columns is greater than 0, and count only once.
So the result for the above data should be 3
(because the first three rows contain positive numbers, but the fourth row doesn't).

I want to use a formula without creat

friends, experts and excel pros!

i have the following:

column D ( 300 values representing the average of three cells, A1:A300 & B1:B300 & C1:C300)
column H ( 50 values )
column E & column F & Column G; they are to be filled

What i want is:

To compare the values of column H with the ones in column D for matches.