Questions tagged [microsoft-excel-2013]

The 2013 version of Microsoft's spreadsheet application.

Filter by
Sorted by
Tagged with
0
votes
2answers
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
2answers
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
4answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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 ...

1
2 3 4 5
32