**0**

votes

**1**answer

48 views

### Excel Convert Row into Multiple Columns

I have a very long list of data that looks like this:
User1 Item1 Item2 Item3
User2 Item1 Item2 #NUM! (This is a failed formula)
User3 Item1 #NUM! #NUM!
And I want to ...

**1**

vote

**0**answers

20 views

### Copy multiline formatted text into a single cell in Excel

My question is similar to Copying a multiline text into a single cell in Excel, except that the text I want to copy contains rich text formatting - bold text, colored text, bullet items, etc...
If I ...

**0**

votes

**1**answer

28 views

### Match each row against all other rows

I have 53 rows with 25 columns nand it's all txt values. Is there a formula that will match each row against all other rows? I basicaly need a similarity matrix and am wondering if there is a shorter ...

**0**

votes

**0**answers

10 views

### Copying row from one excel workbook to another based on column comparison

I am new to excel macros. I want have two workbooks, w1 and w2. w2 is a newer version of w1 and it has certain new columns as well as some column header is changed. I know which column headers are ...

**1**

vote

**2**answers

39 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

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

**1**

vote

**1**answer

1k 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

107 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

66 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

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

**1**

vote

**2**answers

456 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

2k 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

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

**-1**

votes

**1**answer

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

**2**

votes

**2**answers

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

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

940 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

368 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

661 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

140 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

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

**4**

votes

**1**answer

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