**1**

vote

**2**answers

26 views

### Excel: Format rows in sheet B based on value in sheet A

How do I shade an entire row on tab 2 when an "X" is placed in column "A" of the same row in tab 1?

**0**

votes

**2**answers

47 views

### Select a number of rows from a set in Excel

I have a list of users in locations within my company. Vastly reduced from the 130,000 or so in reality, the data looks like the example at the end.
What I need to do is to select a number of users ...

**0**

votes

**1**answer

744 views

### Efficient removal of duplicate records across multiple Excel sheets

I have a workbook with 2 sheets. Sheet 1 has 3 columns (1A, 1B and 1C) and sheet 2 has 2 columns (2A and 2B). Now I need to delete rows from sheet 1 if 1A and 1B match any row in sheet 2 (i.e. 1A=2A ...

**0**

votes

**2**answers

57 views

### Excel outer border around two rows

ID Date Code Price
9202188 04/11/2014 212015 29,47
212026 30,5
9202190 03/11/2014 813012 99,47
814027 60,5
I have ...

**-3**

votes

**1**answer

53 views

### Different rows in to different columns(special case)

I have a excel sheet that contains hundreds of data like this..
Name 1 Name 2 Name 3 Name 4
A Aa Aaa Aaa
Name 5 Name 6 Name 7 Name 8
B Bb Bbb Bbbb
I need to ...

**1**

vote

**2**answers

50 views

### How do I quickly insert many new rows into a table in Word (2010)

I have a table which is 9 rows. It needs to be 59 rows.
I know the trick where you highlight say 3 rows then do insert and it gives you three new rows. That approach obviously does not work as well ...

**0**

votes

**0**answers

15 views

### check for duplicates across rows NOT columns

I have a very large list of names that I need to compare across ROWS - not columns.
Smith, John Smith, John
Doe, John Doe, Jon
As you can see John Doe is spelled ...

**1**

vote

**2**answers

284 views

### Formula to conditionally format a cell if the cell value (text) is not in row above

I need a formula to format a cell if the value of the cell is not in the row above.
I have to compare 100 rows of 10 columns sorted by date with the column above it.
Column A has the date and ...

**0**

votes

**2**answers

1k views

### How to merge rows with same Name merging data of each ?related column

I need to merge rows with same Name preserving data of each column. For example, if we have two rows with the name "Mr Bean" on the first column "Name" then merge data of each column related to rows ...

**-1**

votes

**2**answers

2k views

### Excel 2010 Delete Rows with Locked Cells

I have a spreadsheet that has formulas that I want to lock, once the information in the row is completed, i.e. there is a discharge date, I want the end-user to be able to delete the row and insert it ...

**0**

votes

**1**answer

2k views

### Excel - can't get the formula to copy correctly

Have an excel sheet.
I want B3 = C3 * C2
So far everything is good.
I want B4 = C4 * C2
Did these two manually.
I have a lot of rows so I wanna copy the formula.
The problem is, I select them ...

**-1**

votes

**1**answer

195 views

### Hide rows until needed

I'm sure this has been asked before but I'm really struggling with it. I have a database that lists three companies and compares the prices of several products like this:
Company ...

**0**

votes

**3**answers

4k views

### Move every 7 columns into new row in Excel [duplicate]

I have a very large data set in Excel; all of the outcome scores are in a single column. I need these scores to be separated into rows so that every set of 7 scores (i.e., scores 2-8, 9-16, etc) are ...

**1**

vote

**1**answer

442 views

### Excel singlecolumn to multiple columns based on values

I have 1 column like below:
AAA
999888
BBB
1111
BBB
2222
AAA
999777
BBB
3333
AAA
999666
BBB
4444
CCC
Doit
...
Consider above up to a few thousand rows.
I want to convert it to below 3 column table ...

**1**

vote

**1**answer

2k views

### How can I zebra-format rows in Excel 2010 automatically?

I've got a long list of data (export from MySQL) that I want to print out to tick each row after I've done stuff with it. Is there an easy way in Excel 2010 on Windows to make the table ...

**1**

vote

**1**answer

1k views

### Sorting two non-adjacent columns without affecting any other column

I have two different columns on Excel.
I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...

**0**

votes

**1**answer

1k views

### Combine multiple rows into one

I am trying to combine multiple rows of data into one. Column A contains the value on which the groupings will be based -- rows whose Column A values match will be combined into one row. My range ...

**0**

votes

**1**answer

772 views

### Ms excel 2007, how to Merge rows by removing duplicates

In my case i have a database of more than 30,000
How do i get the duplicates in one row and the last three criteria of puting x in one row of one person
Like
Manmeet abc 000 - - - x ...

**0**

votes

**1**answer

271 views

### Delete rows in Excel based on returned value in row cell

I have a worksheet in Excel with values in some rows in column B that have been returned as zero (0) but still have a formula in the cell. I want to be able to delete just these rows using a macro.

**0**

votes

**1**answer

599 views

### Filter rows with unique values on Microsoft Excel

I have got a set of rows in an microsoft-excel
column_a column_b column_c column_d column_e
r1 200 300 350 400 3
r2 200 ...

**-1**

votes

**1**answer

139 views

### How do I create a range from a cell value?

For example:
A B
7926 3 FROM =COUNTIF(AQ$7926:AQ7970,"=0")
7926 3 FROM =COUNTIF(AQ$7926:AQ7971,"=0")
7926 3 FROM =COUNTIF(AQ$7926:AQ7972,"=0")
7926 3 ...

**2**

votes

**1**answer

300 views

### Adding custom rows to file using a shell script

I have a textfile with an arbitrary number of rows triplets like these:
4 5 2
12 16 6
Now I want to add related rows to the file. Let's say i want to add 4 additional rows per row which have ...

**1**

vote

**2**answers

44 views

**3**

votes

**2**answers

4k views

### Excel row-wise multiplication

I would like to multiply, row-by-row, two columns in an Excel sheet (in order to take the median of the resulting column).
1 3
2 5
4 2
Should become
3
10
8
How can I do that in a formula ...

**4**

votes

**1**answer

297 views

### Set a row to follow my cursor anywhere in Calc

How do I make a whole row follow wherever I am in the Calc document when I scroll down/up?
I'm looking for something that keeps a row from moving, or to make it stay put.
This is so that when I ...