# Linked Questions

26 questions linked to/from Turn one row into multiple rows in Excel

**1**

vote

**0**answers

48 views

### Excel: Expand list to include duplicates [duplicate]

I am trying to dynamically expand a list to include duplicates. I managed to achieve this without VBA, but after condensing several columns containing intermediary functions I have tied myself in a ...

**27**

votes

**17**answers

175k views

### Display Blank when Referencing Blank Cell in Excel 2010

I have an Excel 2010 workbook that contains a number of individual worksheets. The cells on one of the sheets are linked to individual cells on two other worksheets in the same workbook. I'm using a ...

**9**

votes

**2**answers

72k views

### How do I split one row into multiple rows with Excel?

I have a product database in Excel with several hundred entries, each of which has from 1 to 3 "tiers" of pricing: Standard, Deluxe, and Premium. Each tier has its own SKU (A, B, or C added on to the ...

**1**

vote

**2**answers

10k views

### How to format cells to use hh:mm:ss.000 correctly?

I am working with Excel 2013 and I have a column with time in seconds in the format 0.013, 0.033, etc. I would like to show this information in the the format 00:00:00.013, 00:00:00.033. But I am ...

**0**

votes

**1**answer

3k views

### Excel countif formula that will subtract from another number if cell contains certain values

I am dealing with job applications for 8 different sites. People can apply for any combination of sites i.e 1 of them, 2 of them, all of them.
Some applicants have specifically said they don't want ...

**0**

votes

**1**answer

968 views

### Assigning values to rows based on keywords [duplicate]

My bank statement has a description column which tells me where I spent the money or where I got it from. Based on this information I fill a column manually to be able to catagroize these expenses - ...

**0**

votes

**0**answers

877 views

### Excel: Find duplicates among 2 colums

Giving an excel file with 2 columns:
A: 5000 numbers (some repeated)
B: 525 unique numbers
I want to know if for each number in A there is a instance of that number in B.
Meaning: for A1, is ...

**1**

vote

**1**answer

681 views

### Best combination of values from two columns

I am trying to pick the best scenario from data in two columns:
Column 1 contains values for 20 rows (4, 6, 8, 10.5, 13, etc).
Column 2 contains values for the same 20 rows (1100, 950, 800, 750, etc).
...

**-1**

votes

**1**answer

490 views

### How can I make the value of one cell change, based on the value of another cell?

I am writing an inventory list for my office, which is combined with a borrow list. What I want to do, is change the number of items in the inventory list, once an item has been borrowed. For instance,...

**1**

vote

**1**answer

464 views

### How do I conditionally format a cell based on time?

I am trying to conditionally format a cell based on time.
Two hours prior to a time I want the cell to turn green.
1 hour before the time I want it to change to orange.
30 minutes before it should ...

**0**

votes

**1**answer

111 views

### Microsoft Excel and Google Sheets

The formula in Microsoft Excel is not any different than in the Google Sheets. But, I get different results
(left) Microsoft Excel, (right) Google Sheets
The Google Excel formula ...

**0**

votes

**1**answer

226 views

### How to compare and sumproduct two cells value and use multiple criteria in IF in Excel 2013

I want to compare the month value (=TEXT(A1,"MMMMMM")) from sheet A with a cell value (JULY) in sheet B using an IF statement.
If the months are same then I need a sumproduct of the cells in sheet A.
...

**0**

votes

**1**answer

168 views

### Obtain a row number from 2 criteria (with 1 fuzzy search)

I am attempting to create some graphs with dynamic cell references as indices. These graphs are based upon time stamps generated from a testing machine. I have a column of Boolean values (0 or 1) that ...

**2**

votes

**1**answer

116 views

### Is there a way to add and/or logic into the criteria field?

Using LibreOffice Calc with the expression SUMIF, is there a way to make the criteria field look for 2 types of values using OR logic? Or do I have to make 2 separate SUMIF's and just add them up?
A ...

**0**

votes

**1**answer

123 views

### having trouble making a special work calendar in excel

This is the setup:
1. work days
Mo
Tu
Wed
Thu,
Fri different hours
2. shifts daily MO to THU:
early 5:15 - 13:30 = 8:15
Late 13:30 - 21:30 = 8:00
night 21:30 - 5:15 = 7:45
3. Friday hours
...