# Questions tagged [microsoft-excel-2013]

The 2013 version of Microsoft's spreadsheet application.

1,575
questions

**0**

votes

**2**answers

36 views

### Excel: How to graph a multiple line chart by date and country

I have the following dataset that I would like to graph in excel.Dataset
The data is from OurWorldInData.org if you need the full dataset. It has a country, date, and new cases columns. I would like ...

**0**

votes

**1**answer

26 views

### Excel: Drop down with month instances

Is there a possibility to have a drop down with months inside, when choosing one month to show me all instances that are within that month?
Something similar has Excel format Tables, when you choose ...

**0**

votes

**1**answer

12 views

### conditional formatting SEARCH and LEN

I just want to ask a help for my excel formula.
I was having a hard time by trying a conditional formatting and formula these scenario:
To Search and highlight a cell that doesn't start with "S&...

**0**

votes

**2**answers

33 views

### Excel: Return all matches in columns using one criteria (from drop down)

I am having two tables, one table is main data, separated into many columns and blocks per 10 rows in one, this is fixed. In Column A are unique numbers that will be used in drop down.
Table 1
On ...

**0**

votes

**0**answers

27 views

### Excel matrix formula has to return matrix (vector), but returns single (scalar) value

Yes, I read: Excel: Matrix formula - Why isn't matrix (vector) returned? but this is not the same.
Basically I can't figure out why is formula like this: {=MATCH({1,2,3},{1,2,3},0)} which usually ...

**0**

votes

**0**answers

27 views

### Corrupted excel files are zero-byted

We have an issue at work with specific Excel files which seem to have been tampered with.
Well, those Excel files are stored in a folder which is accessible on the work network.
We are not sure about ...

**0**

votes

**1**answer

28 views

### How to find specific cell containing data

I have spreadsheet A that is very large (10,000 cells for example).
I also have spreadsheet B.
I want to use a formula that can locate the specific location of data I enter in a specific and store it ...

**0**

votes

**1**answer

23 views

### Hide all columns except the one which has a header matching a specific cell value

I want to see data of the only branch which I selected in C2, except all remain hidden. I have different branches' data e.g. ABT, BWP, and SWL. In cell C2 I have made a drop-down list by using the ...

**0**

votes

**1**answer

35 views

### Conditional formatting for specific group of values/rows based on cell value(s)

I am having some data table that is separated in lets say "blocks" of rows. As you can see on the image, starting from Column D (A1) there are some values in first row, and then 5 rows empty ...

**0**

votes

**1**answer

17 views

### IF FORMULA FOR EXPIRE-NEAR EXPIRE AND FRESH

Hope you all are doing well.
I need a formula for one of my sheets having data of different medicines. I have to bifurcate products by their expiry status. Fresh, Near Expired, Expired. Here I get to ...

**0**

votes

**1**answer

19 views

### Sum first values of non-unique data in different category

I have a table consisting of 3 types of costs and each type of these costs has several cost IDs, as below:
Cost ID
Amount
Cost Type
IT01
100
Direct cost
IT03
300
Indirect cost
IT04
400
Indirect ...

**0**

votes

**2**answers

41 views

### Get last value of Excel sheet

I want to get the last value of the excel sheet. An excel sheet having almost 100+ columns and I need its net total, the last figure of the report. I have attached the image and also highlighted the ...

**0**

votes

**0**answers

64 views

### Checking Whether Two Columns Match any Numbers from a Different Column

I was wondering if anyone knew the best way to use one column as a sort of "criteria" column by which two other columns are searched for any numbers that match that criteria column. However, ...

**0**

votes

**2**answers

32 views

### Excel group row if value less than number specified

I have a sample data as following:
| Item | Qty |
| -------- | -------------- |
| A | 18 |
| B | 18 |
| C | 7 |
| D | 20 |
| E | 13 |...

**0**

votes

**1**answer

27 views

### How can I get SUMIFS to start over when there is a change of identifying data in a row? (to sum by “groups”)

Currently SUMIFS calculates as intended for 200,000+ rows. There is one exception I can't figure out, when data is the same for 10 rows, then the 11th row changes and then row 12 through 21 contains ...

**0**

votes

**1**answer

45 views

### Excel - count unique days in a start-end date range

Happy new year!
I have an Excel filled with start-end dates (A2:B7).
My interest is to try to get unique days in an interval.
I've made a research but I can't seem to find any solution to this, most ...

**0**

votes

**1**answer

49 views

### Excel formula with identifying %change on repeated sites and multiple years

I'm looking for an Excel formula to drag down on a large dataset. My issue is I have a couple hundred repeated sites with various numbers of years (see subset Excel table example). In the first years' ...

**0**

votes

**1**answer

22 views

### Excel formula for repeated sites

I'm looking for some help with a formula. I have a dataset with repeated sites but with different number of visits per year. I could just do a simple formula for each separate site however, I have a ...

**0**

votes

**0**answers

57 views

### Cannot connect to OData with Excel 2013 without PowerQuery

I need to connect to Odata sources using Excel 2013 in an environment where we are not able to install PowerQuery on most user machines.
Excel 2013 has an option for getting data from Odata feeds, but ...

**0**

votes

**2**answers

313 views

### Remove duplicate character in row in Excel

I'm trying to make it possible to only type "x" (without the quotes) once in every row.
I would rather use data validation, but if that's not possible, I also could use VBA. I have tried ...

**0**

votes

**1**answer

39 views

### How can I use filters on specific header row?

Probably I can not express it, let me upload a screenshot this is my table and I do not want to use filters at Ch. section but when I delete filters, excel does delete all filters.

**0**

votes

**1**answer

51 views

### How to fix lag when using Office shortcuts (Alt + )?

Everytime I press Alt + any shortcut (ex. Alt + HOI), it takes Excel about 5 seconds to actually perform the function. I'm not sure what's going on, but it seems to be arising from the fact that each ...

**0**

votes

**3**answers

638 views

### Excel - Merging date and time cells

I have an Excel spreadsheet with two cells in each row that I'd like to merge. Cell A contains Date and Cell B contains Time, so I'd like to Merge both cells all the while retaining both values.
...

**0**

votes

**1**answer

37 views

### Excel: Array formula which returns vector {1;2;3;…;n} of given lenght (n)

I'm creating a complex array formula and want to get rid of dependency on area which represent vector {1;2;3;...;n} where n is same number as row number in other area used in the formula.
Basically I ...

**0**

votes

**1**answer

44 views

### Word: How to link data from Excel (as plaintext)?

I have Excel table with some data and want this data to be linked in Word. BUT only data (no-formatting).
So embeding an Excel object doen't work for me.
Thank you for suggestions!
Example Excel ...

**-1**

votes

**1**answer

31 views

### Conditional Formatting filling in merged cells using text (Excel 2013)

So, the issue I am running into is conditional formatted merged cells. Right now I am able to get part of the answer with using =$k2="False" but that does not get all the cells I want to be ...

**0**

votes

**1**answer

64 views

### COUNTIFS, number, wildcard, formula

I am using this formula.
=COUNTIFS(EXCEL_TAB!$A$1:$A$999999", "*"&"#_CELL_VALUE"&"*")
How can I specify that that for #_CELL_VALUE, this can be any number ...

**1**

vote

**2**answers

43 views

### Excel: How To Write A Potential “IF” Formula With 3 Outcomes (For Work)

I am looking to potentially create an "IF" formula (might be a different one) for my workplace. I'm not the best at excel, but not terrible either but am having trouble with this.
My ...

**0**

votes

**0**answers

33 views

### Excel: Raising a value in one cell based on a value from another cell (For Work)

I have tried using a few formula examples I found online, with no such luck. I am looking to create an easier testing sheet for my workplace to perform temperature tests in Fahrenheit based on ...

**0**

votes

**2**answers

38 views

### Excel combining text results -> #N/B if referred cell isn't deleted

I have a list with Vlookup. But when I want to combine less than 4 answers in a single cell, i get #N/A. I have to delete the Vlookup cells in order to get this right.
I have a range of 1 to 4 answers....

**1**

vote

**4**answers

55 views

### I want to remove leading spaces in a numeric cell in MS Excel

I want to remove leading spaces in a numeric cell in MS Excel e.g i have a value {' 169,207.00} which i want to convert into numeric as {169,207.00}, Please guide me which excel formula is ...

**0**

votes

**1**answer

20 views

### Excel Pivot Slicer & Unique List in one Column

What I wanted to achieve is to get Unique values list (Y1,Y2,Y3,Y4) in one column (same as on picture 2) so that I can have it for Slice and Dice when using Pivot Tables/Charts. I wanna have "Y's&...

**0**

votes

**1**answer

9 views

### Excel sum on multiple conditions one logical

Column A has prices, B has names, C has a number. I need a sum of the prices next to my name if C>0 but SUMIFS doesn't seem to work with logic operators.

**0**

votes

**1**answer

66 views

### Excel Font Text to Match Cell Background with Conditional Formatting

In excel 2013, when I use conditional formatting, the font sometimes does not match the background of the cell, which causes this problem:
Some numbers are difficult to see if the background gets too ...

**0**

votes

**0**answers

8 views

### Excel 2013 Move PowerPivot data into normal excel sheet

I have added PowerPivot via AddIn in Excel 2013. Now I have data inside PowerPivot. How can I paste these data inside normal excel sheets so that I can share this data with others that don't have ...

**0**

votes

**2**answers

38 views

### Date to Appear If Same Month

This might be a simple problem for you :)
I need a formula that will recognise if the month ends or a new one starts in order to stop showing the next month. So, for example, if the month ends in 30, ...

**0**

votes

**0**answers

9 views

### COUNTIF occurrences of a posterior date (dynamically defined)

I need to count the occurences of «new inscriptions», per person, after a «cancellation date» different for each person.
I have two excel 2013 speadsheets, one with all the inscriptions of each person ...

**0**

votes

**0**answers

30 views

### Excel 2013 Pivot Chart: wrong day-count on y-axis

I'm making this pivot-chart where the orange series shows the average count of days (gg) with hh:mm:ss part.
Now, as you can see on the picture the pop-up shows the correct value (00gg 23:53:37), but ...

**0**

votes

**1**answer

39 views

### How to reduce multiple tables with different data into a master table (with at least one association)

Lets say that I have have 5 tables, all residing in different sheets.
The tables all contain at least one dimension that can be associated with any other table.
Some of the tables will share multiple, ...

**0**

votes

**1**answer

32 views

### Excel Date Range Cannot Exceed 365 Days

Calculate a % leak rate based upon prior activity date and current activity date, but if period exceeds 365 days, use 365 day maximum period.
Formula is:
=IF(A7="","-",((C7/$B$4)/(...

**1**

vote

**1**answer

54 views

### Indirect Function in Excel

How to use Indirect Function to get data from another sheet from a single cell?
It's very confusing whether to use apostrophe or not. If someone could explain it with the Concept it would be of great ...

**0**

votes

**1**answer

24 views

### Transpose some columns of an Excel table

I am not able to achieve going from this format:
To this format:
I could transpose manually, but there are hundreds of items.

**2**

votes

**1**answer

84 views

### Update an excel list dynamically without using scripts

I'm a bit stuck and could use some help.
I am trying to keep a list in excel updated dynamically, based on conditions in other cells. Something along the lines of (IF both cell values in A1 and A2 ...

**-1**

votes

**2**answers

59 views

### Excel: How to Transpose a column of data into a row using a formula and not using copy and paste transpose

Within the screenshot, I would like to Transpose a column of data (Column A) into a row (Row 7) using a formula, cell referencing and not using copy and paste transpose. Would someone be able to help?

**-1**

votes

**1**answer

503 views

### How to Integrate INDIRECT with SUMIFS

I have several sheets of customers in excel, In summary sheet I want to show sale between date range,
'''
=SUMIFS('Riaz Haider'!$B$5:$B$71,'Riaz Haider'!$A$5:$A$71,">="&B3,'Riaz ...

**0**

votes

**0**answers

13 views

### Insert an Emdeddable Link into Excel

I need to insert a website chart (from SAS) that is updated constantly into Excel 2013. Is that possible to insert an iframe embeddable link to excel? (just like what you do in a website for example).
...

**0**

votes

**0**answers

29 views

### Excel: Dynamic change cell with Date/Time when any other cell is changed in the worksheet

I am trying to decypher a formula which will stamp auto Date/Time or some text when I change any random cell (more instances) inside some certain range (for instance A1:K45).
What I did is for one ...

**0**

votes

**2**answers

83 views

### How do I rank values based on a criteria

I have survey data for 3619 individuals living in 1000 houses. The MID column is the member ID of each individual. For example: H1M1 is 1st Member of 1st House. H21M3 is 3rd member of 21st house. ...

**1**

vote

**1**answer

29 views

### What locale does excel uses when you type ,F as date format?

My company builds reporting tools and one of the export formats is excel. As our customers come from different countries when we generate the excel file we use locale formatting to display the dates ...

**0**

votes

**1**answer

53 views

### How to correct this missing numbering series in Excel?

I deleted a 45th row, but numbering system gone wrong like this:
enter image description here
Now I need correct from 45th row. please help me.
Google only shows results of where to find missing ...