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

19,105
questions

**0**

votes

**0**answers

25 views

### Excel - Matching Two Tables Based On Criteria

I need help with the following:
I am trying to link the output of a table based on if set criteria are met, for example, if the function is listed as business process and the individual has grade A ...

**-2**

votes

**0**answers

26 views

### How to remove “Sorry, we couldn't find [filename]. Is it possible it was moved, renamed or deleted?” prompt from Excel on open

Ever since I've removed SharePoint sync from my PC, I've been getting this message each time I open Excel.
I've tried uninstalling and reinstalling Office, deleting the cache at the upload center, ...

**1**

vote

**2**answers

38 views

### Concat of several cells with custom separator

After applying CONCAT to the range of cells and trying to combine it with custom separators, function returns only the first object of the list.
Function that I'm using - =CONCAT(A1:A3&" "&...

**-1**

votes

**1**answer

23 views

### Excel - Extracting multiple matches into separate rows

Hello I am trying to extract the matches (Item2) for the Item1 column into separate rows, so I have a head with the Item1, and then under it all the matches for this Item1 with the column Item2 . ...

**0**

votes

**2**answers

48 views

### Date filtering in Excel Online

I might be completely overlooking the feature, but i've been trying to filter a range of dates to only display today and future days in Excel Online (365).
At first sight it appears that there is ...

**0**

votes

**1**answer

41 views

### Looking for the mathematical equiv of the PMT function in excel

I have a question which I am analysing for a university paper, which is asking for the monthly payment on an investment after 1 year.
I have plugged the values into Excel and have found the payment ...

**19**

votes

**5**answers

2k views

### How do I get the =LEFT function in excel, to also take the number zero as the first number?

My data contains a column of room numbers. Each room number's first 2 digits is the floor number where the room is located. The =LEFT function works well for data that does not start with zero. The =...

**0**

votes

**1**answer

41 views

### Filtering data for graph in Excel

I have a x and y set of data I am trying to filter for a graph. The problem with my data is there are too many points, and I would like to filter out a significant amount of the data. In my case, I ...

**0**

votes

**1**answer

11 views

### Excel: Strange behavior related to INDIRECT pointed to itself

Using Excel 2013 ...
I was playing around with the INDIRECT function and found a very strange sequence of results. It occurs when I place the INDIRECT function in a cell (for example, A2) and ask for ...

**0**

votes

**0**answers

28 views

### Split row into multiple row based on comma delimited value in one column with excel vba only

A B
1 a,b,c
2 d,e
3 f,g,h
I want this to be as below
A B
1 a
1 b
1 c
2 d
2 e
3 f
3 g
3 h
I need this with excel vba

**0**

votes

**1**answer

43 views

### Excel: Find identical values & return different values from same rows

Ok, I hit a stop here and don't even know where to begin.
The scenario (interface between two student information systems) is as follows:
I have two worksheets W1 (roster comprising all available ...

**0**

votes

**1**answer

38 views

### Excel: how to manually set alternating background color?

In a pivot table, only one column has alternating background color. The other columns have no background color. How do I manually set the alternating background color? So far, I have found no way of ...

**0**

votes

**1**answer

35 views

### Is there any way in excel to show last line of a cell when we reduce height?

I am wondering if there is any method or function to show last line when we reduce the height.
Let's say in a cell there are three lines.
This is line 1.
This is line 2.
This is line 3.
When I ...

**1**

vote

**2**answers

23 views

### How to concatenate or combine multiple cells with header

I am trying to combine columns a2 through to z2 including the column header for each item and then apply to about 3500 rows.
It works when i enter =A1&A2&"----"&B1&B2&"----"&C1&...

**0**

votes

**2**answers

13 views

### Excel formula to sum value in column to the left in array formula based on criteria

I have a row that looks like this:
|52|52|52|_|_|_|_|_|13|B|_|_|_|_|_|24|C|_|_|_|_|_|18|B|_|_|_|_|_|16|A|
The vertical pipes represent columns and the underscores represent blank cells.
I want to ...

**0**

votes

**0**answers

29 views

### ppt vba code stopped working after months of proper work

I have a PPT file with a small number of slides and objects that run macros.
Some of the macros write to an Excel file and some extract data from such files.
I am using Office 365 Business.
The code ...

**1**

vote

**2**answers

51 views

### Excel how to do math with row or column indexes to create cell references?

I have the following values in my excel:
shift 2
data 131 12 55 23 45 11 23 45 119 77
I would like to define a formula which refers to the n-th cell to ...

**0**

votes

**0**answers

19 views

### Formula for recording the changes of a cell, not VBA

Basically, I often use my excel files on Ipad, so there is no VBA support. Then, I can't track my changes during the day (no recording).
I just want to ask: "Is there any formula to solve this ...

**0**

votes

**1**answer

65 views

### How to auto-insert text from a cell into a part of an Excel formula (GETPIVOTDATA, specifically)

I have this formula:
=GETPIVOTDATA("[Measures].[Sum of Daily_Income]",'After-Tax Income'!$A$3)
Above it is cell B2 with "Daily" written into it.
I want to make it so that the "Daily" in "[Measures]....

**0**

votes

**0**answers

23 views

### Chart Data Based On Cell Value

Project Task Chart
Hi, I'm trying to chart the progress of project tasks dependent on the status of the project. I have a table with all projects and the % progress and % remaining for all tasks ...

**0**

votes

**1**answer

55 views

### Excel doesn't accept formula

Another SU thread, How do I change whole number into a decimal number in Excel?, deals with the problem of taking a multi-digit whole number and inserting a decimal point between the first and second ...

**0**

votes

**0**answers

25 views

### Does anybody encounter this bug ? formula should return 0 but return 5,6843418860808E-14 [duplicate]

I got thjis ultra simple formula in cell F2 = F1-E2+D2.
it is simply to calculate balance of an account from debit and credit amounts : old new balance = old balance - debit + credit
But, if F1 = n, ...

**1**

vote

**1**answer

36 views

### Office 365 Security

I have a work based Office 365 account and am looking at working remotely, if I open an Excel file on Office 365 it will open Excel online, however, if I want to work on a more complex spreadsheet I ...

**1**

vote

**2**answers

41 views

### Switching X and Y values for every series in scatter chart

Oy people! My problem is as follows:
My data table:
Selecting the data and creating a scatter chart nets me such a result:
Then for each series I have go and manually edit them, switching X and Y ...

**0**

votes

**0**answers

18 views

### Keep the error bars in foreground in Excel scatter chart

Often in my work I place vertical scatter data inside a graph and overlay a single data point corresponding to the average of that group of data. When I place error bars on that average, the error ...

**0**

votes

**0**answers

28 views

### Excel for Mac gives “cannot open file… format or extension not valid” error for custom add-in when pulling from git

I am currently working on a custom Excel add-in which, until now, was only used on Windows. I am attempting to make it cross-platform. Unfortunately, when I pull my add in from git and attempt to load ...

**0**

votes

**2**answers

35 views

### Special characters not recognize from Google Sheet & Microsoft Excel

I have developed a web crawler to extract some information and print them to an Excel spreadsheet.
However, neither Excel nor Google Sheet recognize some special characters, see below:
The text ...

**0**

votes

**0**answers

28 views

### Color column in Excel based on two cell's values

I have two columns, C and I. which contain data.
Both columns have time stamps in them (ex. 11:00:00 am).
I need to write a logic formula that has C>= to 11:00 AM and I <= to 11:00 AM, and if ...

**0**

votes

**0**answers

15 views

### Excel Macro Module blank

I have been having this problem for a while, all my macro codes just go blank and they don't function and excel crashes when I press the Macros button on the Developer toolbar. Tried searching ...

**0**

votes

**0**answers

26 views

### Macro for Returning Multiple Values into One Cell

I tried using a macro formula from a YouTube video to do this but it came back with an error...maybe a slight adjustment will fix...
Function Lookup_concat(Search_string As String, Search_in_col As ...

**0**

votes

**1**answer

13 views

### How to prevent pivot table from resizing after refreshing data?

I have slicers and pivot tables on a single sheet and would like to preserve the pivot table size after refreshing the data. Any ideas as to how I can achieve this?

**0**

votes

**0**answers

23 views

### Excel IF and SUMIF

I have a formula =SUM(H80/G80) which is giving me a total for the full set of data. H80 and G80 are subtotals =SUBTOTAL(9,G1:G79).
I now need to break it down to 2 text variables from column E. I ...

**0**

votes

**1**answer

22 views

### How to get Slicer to multi select instead of multi DEselect?

Adjusting the multi select setting on my slicer makes it deselect items. However, I'd like to select multiple filters instead. How would I go about doing this?

**1**

vote

**1**answer

24 views

### Excel: Match with value and interval

I have a question regarding a formula in Excel.
I have Sheet 1 and Sheet2
How do I need to write the formula (using Index and Match) in order to complete the blue cells from Sheet2.
I've tried to ...

**1**

vote

**1**answer

31 views

### Mysterious MS Excel error: Cannot find [..]!Local_Close_Sheet, which has been assigned to run each time myfile.xlsx is closed

I receive a mysterious error each time I try to close myfile.xlsx.
Cannot find 'X:\WINFDC[FADRVR32.XLA]FADRVR32'!Local_Close_Sheet, which has been
assigned to run each time myfile.xlsx is closed. ...

**0**

votes

**0**answers

21 views

### VBA - Bing translation, how to copy from Bing to Excel?

Problem: Cell A1 has texts in Spanish. The code opens IE, goto Bing, translate A1 texts into English. Code works great so far. But now, I don't know how to copy the result (English) back to excel (...

**0**

votes

**0**answers

39 views

### How to use a formula to Count Distinct Values in a Range according to multiple criteria (date range) without it taking too long to process?

My question is how can I make the following formula process quicker? Currently, whenever I make a change to date range, it can take up to 10 seconds to process. The data I am sorting through can have ...

**1**

vote

**1**answer

53 views

### Excel: Find doesn't find it

In my spreadsheet, there are three 2,280,000. One of them is a calculated value, 19000*120, the other two are plain numbers.
When I used the Find/Replace function to find 2280000 by formulas, it only ...

**0**

votes

**0**answers

21 views

### Sumifs not working but countifs is for same conditions

I've got a sumifs function:
=SUMIFS(Master!DK:DK,Master!E:E,1,Master!AL:AL,Sheet1!H2,Master!N:N,Sheet1!A2)
that is returning 0 when it should be returning 2.
There is one row matching that criteria,...

**0**

votes

**2**answers

69 views

### adding numbers inside a text

I have cells containing number and text and I would like to sum only the numbers at the end of the cells.
here is an example of my cells :
L4-R4
L8-R9
L11-R11
L12-R11
L12-R11
L9-R9
the answer ...

**-1**

votes

**1**answer

46 views

### Compare multiple cells from one row (EXCEL)

I really don't know if I am at the right place to ask this question, but I didn't find an answer anywhere. I am looking for an Excel formula (no macro or dynamic stuff) to compare the text values of 6 ...

**0**

votes

**2**answers

36 views

### Based on Cell Value matches column with Yes or No

please see the table below. I have Columns like ColA has some value, Store has Store Names. And rest column names defined as unique cell value in Store1 column(Store1 till storeN.
ColA Store ...

**0**

votes

**0**answers

20 views

### The remote procedure call failed. (Exception from HRESULT: 0x800706BE)

While creating the excel file in the server exception as The remote procedure call failed. (Exception from HRESULT: 0x800706BE). In the same server before the exception, the application runs properly. ...

**0**

votes

**0**answers

46 views

### Create a calculation based on previous date and specific identifier

I have an excel table that has a list of measurements and dates those measurements were taken. Each measurement is from a specific location. I need to perform a series of calculations that are based ...

**0**

votes

**1**answer

26 views

### Clicking button causes quick zoom in and out

Sometimes when I click on a button in an Excel spreadsheet I've created, when I release the button, the worksheet quickly zooms in and out. There isn't anything in the VBA code to tell it to do it and ...

**0**

votes

**0**answers

66 views

### How can I stop Microsoft Excel or Word from starting automatically?

When I start my computer, either Microsoft Excel or Word starts automatically with an empty page. I think it's the program I've opened last. I've removed and reïnstalled Office completely, this didn't ...

**0**

votes

**0**answers

30 views

### Excel INDEX/MATCH function difficulty with CSE

I have an INDEX/MATCH function in one of my formulas to look up and match information with multiple criteria. I know that the first time the formula is entered, it is required to use ctrl+shft+entr (...

**0**

votes

**1**answer

20 views

### Excel VBA Copy and paste to different workbook at end of existing data

I am trying to combine data from several workbooks into one master workbook
I have 3 workbooks that all have a tab named company and I want all the data they contain to be pasted to a new workbook on ...

**0**

votes

**2**answers

62 views

### Excel 2016 - Apply Conditional Formatting based on value of a prefix label

Hi I am trying to apply conditional formatting using the following search function: -
=ISNUMBER(SEARCH("S",$C1))=TRUE
My problem is that the "S" has been applied using custom format to insert the ...

**0**

votes

**1**answer

71 views

### Lookup in Excel between tables

The image below shows three parts of my table.
The yellow cell is the cell I am trying to pull information into (cell F18) which is in the Know Your Business table.
The red cell is my drop down by ...