# Tagged Questions

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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:...