Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

0
votes
0answers
16 views

How to take a set of values and compare it to multiple criteria rows

Example of what I would like to achieve: A B C D E F 1 1 <= 2 2 1 2 2 <= 4 23 8 3 4 <= 7 5 3 4 7 <= 10 40 10 5 10 <= 12 7 3 6 12 <= 17 8 4 7 17 <= ...
0
votes
1answer
21 views

Formula to get a sub table where the values in a column match a certain criteria

I'm looking for a formula to get a sub table out of the main table, of the rows in which the balance column has a value greater than zero. NameClass Date Pre Balance July Van Fine Total ...
0
votes
0answers
23 views

Excel - how do I filter multiple tables without header?

I want to filter if any of the H I J columns contain fields greater or equal to 10.0. I don't want to use no Advanced filters because there are multiple tables across the way but I want to sort all ...
1
vote
1answer
22 views

Excel MIN with nested IF statement — Trying to ID a date closest to 30 days after a date

I have 16K plus records with an Auction Date. I need to find the date and amount that is closest to the Auction Date BUT more than 30 days later. I have calculated a row that shows the difference ...
0
votes
1answer
18 views

Excel - Every combination of column a and column b into column d and e

I'm not really sure how to even ask this question. So I took a screenshot of what I'm trying to accomplish. I'd like to output every combination of columns a and b into column d and e. I've seen ...
0
votes
1answer
14 views

How to prevent #REF errors appearing in formulas when referenced workbook is opened

In my workbook A, I have formulas that reference my workbook B. Once I open workbook B and enable editing, all of the formulas in workbook A show workbook B's worksheet name as #REF (but the filepath ...
0
votes
2answers
37 views

Excel, I want my workday function to always pull the next Monday

I have a simple calculation =workday(b12,1) However, If this date lands on any day other than Monday, how do I make it show the date for the next Monday?
0
votes
0answers
19 views

Clustered Column with same row values

I can't seem to get a good clustered column when the row values are the same. How do I create a chart that has the same row value title but a different x axis title? For example, in the image below I ...
0
votes
0answers
16 views

How to apply advanced filter and keep one column unfiltered?

I have a spreadsheet of the following format: Email Breach1 Breach2 Breach3...Breach13 I need to filter it down to only users affected by certain breaches (spread across all breach columns and ...
-1
votes
1answer
31 views

Excel, “You've entered too many arguments for this function”

=if(C15=0,(B14+(VLOOKUP(C16,,'Locks and Readers per day'!D:E, 2, false))),(B15+(VLOOKUP(C16,'Locks and Readers per day'!D:E, 2,FALSE)))) What am I doing wrong?
2
votes
2answers
20 views

Excel - How to return different match values with other formulas?

I have the following table and resulting formulas: First I have the sales person and the number of sales. Then in columns D and E, I want to know who are the best salesepeople. The formula in E2 is ...
-2
votes
0answers
22 views

Exel VBA Absolute and Relative Path

Excel 2016. I have an application with a Path Desktop to open, display and export files. Below are two lines to code running well: sExcelWB = "D:\testing\" & "qry_task.xls" sExcelWB = "C:\Users\...
0
votes
1answer
21 views

How to calculate Q1, Q2… but for a given date and not 01 Jan

I have been trying to calculate the Quarter period but not for a year that starts on 01 Jan but for a date that denotes the end of year which could be 03-22 for example. There are a lot of examples ...
1
vote
1answer
21 views

Excel: Keyboard shortcut to add a worksheet to the right of the current sheet

Clicking on the "+" near the worksheets tab on Excel 2016 adds a new worksheet to the right of the current worksheet. However, hitting Shift + F11 adds a worksheet to left of the current worksheet. ...
-1
votes
1answer
18 views

In MS Excel, how can I create a bubble chart where the color of the bubbles match the color of a cell?

I would like to illustrate a fourth variable (x axis, y axis, bubble size, bubble color), but do not want to artificially split the series into pre-defined groups based on a set of thresholds. Rather, ...

15 30 50 per page