Questions tagged [microsoft-excel-2013]
The 2013 version of Microsoft's spreadsheet application.
1,611
questions
0
votes
0
answers
16
views
Creating a formula on Excel for my table
I would like to create a formula that will auto update when more information is added to my table and when numbers change. I have created a table that shows how many licences I have and their annual ...
0
votes
0
answers
36
views
Microsoft Excel not recognizing cell data as date
I'm working with a set of dates that need to be utilized in an if function. In the event the date is more than 365 days from today, it is false and vice versa for under 365 days. My problem stems from ...
- 1
0
votes
2
answers
31
views
Excel SERIESSUM won't accept array of cell references as coefficients
The Google Sheets version of "SERIESSUM" function accepts an array of cell references for the "list" of coefficients as in this example:
=SERIESSUM(O8549,0,1,{K8549,K8538,K8526,...
- 3
0
votes
0
answers
26
views
How to Sumproduct with SUMIFS from another sheet without making extra columns
I am trying to get the SUMPRODUCT (total specific cost) for projects (with employees' code and employees' cost, projects' code from a sheet and a sheet of working hours in month with employees' code, ...
- 1
2
votes
1
answer
43
views
Populate cell with value from 4 possible cells
I want to populate one cell based on the text value of one cell out of 4 possible choices. The other four cells will not have any values. Only one of the 4 will have a value I want to populate in the ...
- 21
0
votes
1
answer
170
views
Can anyone please tell me how can I convert 1M, 1B, 1K to number format in excel? [duplicate]
Can anyone please tell me how can I convert 1M, 1B, 1K to number format (like 1K = 1000) using formula in excel.
Advance thanks for help.
2
votes
1
answer
93
views
In Excel 2016, how do I link a CSV where you can specify the file to import like I could in Excel 2013?
In Excel 2013, I used to be able to specify a sheet to Data Refresh and at the time of creating a linked csv file, I could prompt for the location or file with every Data Refresh. In Excel 2016, I am ...
- 6,192
0
votes
1
answer
23
views
Text comparison in Excel - What formula should I be using and how to do it?
I have 2 sheets, the first sheet contains a coulm of Emails and the second sheet contains 2 columns ( Some Emails & Status). How to make excel get the status of each email from sheet 2 into sheet ...
- 1
0
votes
1
answer
53
views
Excel 2013 - cannot enter numbers
I open a blank sheet. TYPE numbers into cells. Excel does not recognize the numbers as number. Even if I select and FORMAT as number. What is wrong. existing sheets work fine.
- 1
0
votes
0
answers
32
views
Excel formula to look at a Row
I wrote an excel formula to return(true and false) if three criteria's matched in the row.
For ex) If the Row contained
Name , D, and 1 then it is true
This is the formula created:
=IF(AND(COUNTIF('...
0
votes
1
answer
100
views
function LOOKUP() don´t return result expected
I'm trying to use lookup function with a simple list of text, but in one sheet in my pc is not function,i write =LOOKUP("Zapatilla 4",A28:A34) in the table
description
other info
Zapatilla ...
0
votes
2
answers
84
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
0
votes
1
answer
40
views
Format of Excel drop down list
When choosing from a drop down list in Excel, is it possible for the cells to change the format when you choose a specific subject?
Each subject has a different format for the cells.
- 1
0
votes
0
answers
34
views
Excel not showing the full page contents
In Microsoft Excel 2013 under Microsoft Windows 8, for a Letter 215.9 x 279.4 mm Page Size with zero margins (0 mm, 0 mm, 0 mm, 0 mm), and set at 100%, and cells set as 10 px Column Width x 10 px Row ...
- 647
0
votes
3
answers
95
views
How to create a list of items in an Excel cell, and be able to data filter this column?
Can we have a list of items in an Excel cell, such that the rows can be filtered with Data Filter?
Exemple: how to filter by column B and keep only the rows that contain [item4]:
?
Notes:
we could ...
- 1,481
0
votes
1
answer
34
views
count unique with multiple criteria, what should i do?
Problem
I want to count uniquely in multiple criteria but it seems the formula isn't working
The count should be 6 instead of 3.5
what should I do?
0
votes
2
answers
148
views
Index Function with error "You've entered too many arguments for this function"
=index(_70Rain,1+int((row(b4)-1/columns(_70Rain)),mod(row(b4)-1+columns(_70Rain),columns(_70Rain))+1)
I just followed the code given in https://www.extendoffice.com/documents/excel/1172-excel-...
0
votes
1
answer
311
views
In Excel my formula is skipping the first two cells of a table
Hi I have an Excel Spreadsheet and I'm trying to convert a table with multiple rows and columns into just one column for sorting and filtering. But the issue is that it doesn't start at cell A2 where ...
0
votes
0
answers
127
views
Excel: How to match substring to another string and return the matched result?
When doing data dump for time log activities, the data comes out to simply the name of activities in one column and a string of one or multiple labels in another column (column B in image).
Then I do ...
0
votes
2
answers
476
views
Excel Custom Ribbon Separators
I was looking for a way to insert vertical separators into a custom ribbon in Excel 2010, which seems to be problematic for everyone. I've searched the planet and been told it can't be done!
- 1
1
vote
1
answer
39
views
My IF function isn't working when I try to pull out a specific word
I am trying to have the cell populate if the word CAT|I is in a different cell. I am using the following function:
=IF(ISNUMBER(SEARCH("CAT|I,",F12)),"CAT I","NO")
...
- 11
1
vote
2
answers
336
views
getting Max/Min value in range based on a cell's condition
Greetings to all Excel gurus..
I've got the dataset shown in the image attachedenter image description here..
I'd like to show the MIN and MAX value of "Price/Oz" based on the condition if ...
- 13
11
votes
2
answers
2k
views
How can I identify zero values, but format non-zero ones?
I have a column in an Excel spreadsheet that contains monetary values, most of which are zero. I want to hide the zero ones, but keep the non-zero ones formatted as currency.
This Microsoft page shows ...
- 463
0
votes
0
answers
19
views
Office 2013, 2016 QATs remove padding at right
Can anyone help with how to remove the blank padding at right of the QATs?
This is happening in both Word and Excel, 2013 and 2016.
- 542
0
votes
2
answers
73
views
Append string to an Excel-cell, but ignore appended value when referenced in calculations?
I am wondering if there is a way to append a cell with a string value (for better/readable presentation), but ignore this appended value in formulas when referenced?
For example, lets say
A4 has the ...
- 333
0
votes
0
answers
319
views
how to add multiple hyperlinks in image placed inside single excel cell?
i have an image inside excel 2013 as shown below:
i want to make multiple body parts hyperlink or behave as a button insight this single image.
any help would be appreciated.
Thanks,
0
votes
1
answer
276
views
Excel: Take on the value of a formula cell when other cell is equal to x?
I know that title isn’t great but essentially:
Let’s say
A1 = some number
And
A2 = some formula involving A1
I want to store values of A2 in a column for different values of A1 so like a function ...
- 1
0
votes
1
answer
59
views
Excel 2013 fails to record macro correctly
So, i want to create a macro that will set selected cells' format to 0,0 ¥.
However, if you record the steps and then try to run the macro it will set format to 0,0 ?. Is there a way to fix this?
- 3
0
votes
1
answer
86
views
How to get numeric month from date (the date format: both D.MM.YYYY and DD.MM.YYYY)?
I would like to get a numeric month to the next-to cell from Date text of previous cell. Example: 1.3.2020 should result, in new cell, as 3
I cannot use MID function due to two reasons: First is that ...
- 1
0
votes
1
answer
67
views
Excel Hyperlink within the same sheet
I have an excel workbook with 2 sheets. Sheet1 and Sheet2. I want to stay on sheet1 and create a hyperlink to sheet2 but I want the information that is available in sheet2 to be displayed in sheet1 ...
-1
votes
1
answer
53
views
Excel Count Different Values With extra if
I have a large amount of data. I want to count every different data. I've found that part of my formula but I want to add ab extra if; For example, I can count different data with this formula;
=SUM(...
- 1
0
votes
1
answer
74
views
excel 2013 conditional formatting is forcing absolute
I am trying to use relative cell expression but when I do it automatically makes it absolute no matter what I try.
before apply
When I hit apply it changes the value to =$A$5
after apply
0
votes
1
answer
424
views
Highlight all the cells if the keyword in the cell matches to any value of a list
For one of my excel sheet, it is required to highlight the cells that has specific keyword in it.
To solve this, i have created a list called my_list which contains value1, value2 & value3.
I have ...
1
vote
1
answer
279
views
how to check for returning customers in Excel 2013?
I have the following sales data, split by customer and year:
2015
2016
2017
2018
2019
2020
2021
expected result
customer 1
100
0
0
100
0
0
0
2018
customer 2
100
0
0
100
100
0
0
2018
customer 3
100
...
- 123
0
votes
1
answer
762
views
How to I get Excel to take a user id in one table, match it in another, return only the most recent value, and ignore older values?
I need Excel to take the userID from Table A, match it to Table B and return the most recent SaleDate only,
and ignore older SaleDate entries. In addition, I need to also return the corresponding &...
- 1
5
votes
3
answers
459
views
Excel: Get range address from single input (looking for compact formula)
I'm trying to get an absolute range address from single input. Something like this.
Formula
=SOME.MAGIC(A1:B10)
Output (string)
"$A$1:$B$10"
Attempt 1
I'm able to get this result but using ...
- 835
0
votes
1
answer
86
views
Excel Power Query - M Language - Reference to "ThisTable"
As total Power Query newbie I'm trying to create Power Query function which adds an Index Column to the table. But I'm struggling with passing a table reference to AddIndexColumn function
What I tried:...
- 835
0
votes
2
answers
262
views
Excel - (Column) chart - Z-index of data series according to actual value
I have a column chart with multiple data series. For example:
I don't want to have columns next to each other so I set reduced Series overlap and Gap width in Format Data Series...
Now the Series ...
- 835
1
vote
0
answers
1k
views
Excel (2013) Power Query: [Expression.Error]: The key did not match any rows in the table - what files(s) is source of this error
I have tens of Excel files with similar table (means: same name, same headers, different content). I'd like to merge all data from these tables to one big table for future processing.
I did it many ...
- 835
0
votes
2
answers
2k
views
Merge Excel rows based on common column values
I have a table similar to the image below. Column A has repeated values, while column B has values corresponding to column A. e.g. a single customer can have multiple orders.
What I would like to do ...
- 141
0
votes
2
answers
3k
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 ...
- 5
0
votes
1
answer
2k
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 ...
- 121
0
votes
1
answer
92
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
123
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 ...
- 121
0
votes
0
answers
42
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 ...
- 835
0
votes
0
answers
81
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 ...
- 1
0
votes
1
answer
506
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 ...
- 1
0
votes
1
answer
33
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 ...
- 3
0
votes
1
answer
481
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 ...
- 121
0
votes
1
answer
647
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 ...
- 3