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.

-4
votes
0answers
25 views

Excel Time Card Build

I'm looking to have excel calculate the overtime for a time card. To do this, I only need it to display the overflow of the regular hours column. How would I achieve this. I have tried SUMIF equations ...
-2
votes
2answers
22 views

Numbers helps cells

I need to add 2 cells to keep score in a game.Like add 2 + 3=5.The next round could be +4 added the cell with the number 3 (cell value now 7) so I will get a total of 9
1
vote
0answers
7 views

Window Resize event not triggering when snapping windows to the edge of the screen with the mouse

This question is in relation to this Stack Overflow question, but I felt the issue at heart is less about programming and more about the limitations of the program, which is why I'm asking on here.I'...
0
votes
1answer
22 views

Identify first login and last logout entries

I have a spreadsheet that needs to determine the first time a user logged in to the system and the last time the user logged out.The login and logout report comes from another system from which I ...
3
votes
4answers
19k views

How to change a single character in an excel formula for 1500 rows

I have over 1500 rows of information with formulas such as,='3'!$AH$6 , where each column contains information from another sheet within the workbook. In the example, the sheet labeled '3' is ...
0
votes
1answer
1 view

Getting vlookup result of multiple row and multiple column

As title, I am stuck where I would like to get all the result for name "A" with formula.Below is all the value that has been given. However, I would like to get just the name "A". and below is the ...
1
vote
1answer
35 views

Excel 2016 restart itself when I try recording a macro

I wanted to make a Macro in Excel 2016 (under Win 10). I chose the "Record Macro" button. After opening the floating window and making a name for the macro, I click on the "OK" button. After that, the ...
0
votes
1answer
12 views

How do I automate upper case formatting for select columns in excel with VBA?

I am trying to automate formatting keyed in text into uppercase for Columns B and C and I am having trouble in setting column targets correctly. I found this piece of code on an excel help forum but ...
0
votes
0answers
4 views

Excel pie chart for over time

Hi,I was just wondering if I can have "single" pie chart on Excel, which I can choose a specific date (row) and dynamically shows me the relevant pie chart.In the picture, you see three different ...
0
votes
1answer
8 views

Index match finding the first value only

I have a list of employees with duplicates and each employee has a number which represents the number of sales. I'm trying to use the following formula to extract the highest sale for a given name, ...
-3
votes
0answers
12 views

Cross-book conditional formatting in Excel 2010

How can I apply conditional formatting that tests value(s) in a separate Excel workbook?I've been able to get conditional formatting to work between separate worksheets, but the document needs to be ...
0
votes
1answer
85 views

Alternative to SUMPRODUCT part 2

For two durations that are in the same row (just different columns) and two whole numbers that are also in the same row, I'm trying to compute the equivalent formula as in my previous question which ...
1
vote
1answer
4k views

Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...
0
votes
1answer
21 views

Auto-populate one table from another table if a criteria is met

I have two tables: Information and List.The Information table has two columns: Name and Gender.The List table also has two columns: Male and Female.I'm trying to auto-populate the List table ...
-1
votes
1answer
28 views

Excel, can't create hyperlink within a cell without text

I have created SEVERAL hyperlinks in blank cells in this workbook i'm working on, and then all of a sudden now, when I try to create a hyperlink within a cell, it automatically puts the link name in ...

153050per page