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.

learn more…| top users | synonyms (2)

0
votes
0answers
4 views

How to sort data for payroll by piece completed?

I need to come up with a way to track how much employees should be paid every week based on what stages of a job they completed. I currently have a Google spreadsheet in which the job number, who ...
0
votes
0answers
3 views

Microsoft Excel Userform combobox to hide and unhide columns

Below is the current code from what I have seen on other posts, but the ComBobox is not populating and I'm unsure on how to correctly/efficiently do the Case selections. I would appreciate any ...
0
votes
0answers
10 views

prompt user to select a folder on any users desktop and loop through excel files using code below

I have code below, that prompts any user to browse for a workbook "Wb1" and then performs the code below...how can I change this so that it prompt the user and the user selects a folder called "...
-1
votes
0answers
28 views

I need to calculate all the extra working hours in a month in excel

Hello I need to calculate the extra working hours of a month but there is a twist:spreadsheetIn the first row we have the dates of the month (01=01/01/2018, 02=02/01/2018) in dd/mm/yyy format. ...
0
votes
1answer
24 views

Excel: Data across multiple columns and rows

Currently have a table like this:How can I consolidate and count the hours per person spent on each day. Need to be on seperate lines due to working on different tasks but want to bring in all ...
12
votes
3answers
1k views

How does Excel handle composition of functions?

I was trying to use functions to get today's day as a number in Excel. For example, when I wrote this question I should have obtained $18$. I tried to use:the function TODAY() which returns today'...
0
votes
1answer
21 views

Filtering Pivot Tables with filter criteria on multiple fields

I am creating a marketing spreadsheet for the office. There are two main things I am having difficulty accomplishing:1) Creating a dashboard of pivot charts from source data (~3000 lines)2) ...
0
votes
2answers
21 views

use a drop down list to copy paste values from a table.

I have a drop down list called Ted_ID that contains ID's I want to write vba code that says if a user selects an ID from the drop down then it will look into the table and find the corresponding Ted ...
-2
votes
0answers
19 views

Create a floating table in excel with circular references?

My question is actually 2 parts:Is it possible to create an EDITABLE table (not just a dynamic image) that floats in the same spot while scrolling up/down in excel?Is it possible to reference cells ...
-1
votes
0answers
15 views

Reducing Excel displaying memory which is showing unnecessary intermediary results for multiple formulas

Hello: I am doing formulas into column A and resulting in column B, then doing formulas in column B and resulting in column C, and so on, until it arrives to column J, and as the chart has several ...
-1
votes
1answer
32 views

Partial texts conditional deleting in Excel

Hello Below are some cells in which the texts are random sized separated with * or with % or with both % and * or with * and % or with more than one % or with nothing and some points.Cell A1: ...
0
votes
1answer
17 views

VBA to check and see if information in one sheet matches information in another

I need a VBA macro to do the following:I have two sheets, in sheet1 there is a list in column A that has part numbers. On sheet2 column A i have a column where part numbers can be entered. What I ...
1
vote
2answers
26 views

Start application minimised from command prompt

On startup, I load a "TODO" Excel spreadsheet using the following batch command:start \min PATH-TO-SPREADSHEET\TODO.xlsThis works except that Excel is not minimised, only "Restored" in the middle ...
1
vote
1answer
19 views

Is there an Excel function that works the same as filter() from Google Sheets?

I have a list of names that each have a value (C:C, D:D). I want to generate a new column (A:A) that only shows the names that have the values I want, without any spaces.In Google Sheets it's ...
0
votes
0answers
18 views

Excel combine rows horizontally

I have data with the structure:ID TimeStamp TextA 08:22 FooA 08:24 BarB 08:30 FooB 08:45 BarTrying to get to:ID TimeStamp Text ID TimeStamp TextA 08:22 Foo A ...
-2
votes
0answers
17 views

how to Return a sum value using multiple conditions in two or more columns [on hold]

I am trying to find a formula to resolve the following:Column A has three criteria and Column B has five criteria. I would like to have the summed value in column C for each criteria in Column A ...
-2
votes
1answer
16 views

I am looking to have a cell automatically fill from a different cell within the spreadsheet [on hold]

I am trying to make a spreadsheet that will allow me to keep better track of information (dollar amounts) I pull directly from a system without having to manually enter it.For example: I will say I ...
0
votes
1answer
17 views

Excel - How to subtract cells and add columns

So lets say I have 2 columns, A e B, like for example:A B C -----------------------------1 | | A | B |-----------------------------2 | ...
0
votes
1answer
26 views

Deleting part of the cell in Excel

How do I write the formula in Excel to delete everything after the * including it? Both texts before and after the * are random sized.Cell A1: adlkjadflaskd*kljadkfjasdkfjhasCell A2: ...
0
votes
1answer
18 views

Relative paths to images Excel

I have a question. I'm working on a sheet which contains links to a folder of images in my computer. This sheet will be sent to a colleague. My aim is that being able to do a relative path, that when ...
0
votes
2answers
33 views

Simplifying Multiple Substitute Formulas in Excel

How do I simplify this formula to delete all repeated - in Excel?Cell A1: text---------------text-text---textCell A2: text----text--text---textI need it to be:Cell A1: text-text-text-text...
1
vote
1answer
20 views

Substitute character " in Excel Substitute Formula

how do I substitute character " for : using excel substitute formula?Cell A1:"Formula I am trying to do:=SUBSTITUTE(A1,""",":")It comes with a mistake because " cannot be inside the " ".How ...
1
vote
1answer
25 views

Excel displays #VALUE! as 0.0 in chart

In this Excel sheet I have a data range where values are calculated from a formula=INDEX(...). That formula returns #VALUE! in some cases. I thought Excel would not plot those and maybe it doesn't. ...
1
vote
3answers
67 views

How to split words in Excel

In Excel, how do I split a word from cell A1 in all possibilities of 3 sequenced letters?Example:If cell A1 contains word university, I need that it generates following text in the other cells:...