Linked Questions

1
vote
0answers
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
17answers
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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 ...

15 30 50 per page