# 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,119
questions

**0**

votes

**1**answer

24 views

### Excel Scatter Chart

I am try to create a chart that shows the difference in pay between male and female. I want pay at the top/bottom, sector on the left, and a male/female icon and the pay points. I can not seem to ...

**0**

votes

**0**answers

59 views

### Unable to install Micro Focus ALM Microsoft Excel Add-in

Unable to install HP ALM Microsoft Excel Add-in.
I am using ALM 12.60.
I need to upload test cases from Excel to ALM;
for that I have to install HP ALM Microsoft Excel Add-in.
Please find the ...

**6**

votes

**4**answers

1k views

### @ in the beginning of a formula

I have seen @ in the beginning of some formulas in a workbook, for example: =@SUM(A1:A10), =@VLOOKUP(3;F9:H12;2;FALSE).
It seems that it is a new feature of Excel.
Does anyone know what this @ ...

**0**

votes

**0**answers

21 views

### Creating a repeating formula using cells

I am required to add two cells together and subtract another in order to get a number.
Example: (D2 + B3) — C3 = D3 (the answer would be put in D3).
The columns are always kept the same, it is just ...

**0**

votes

**0**answers

18 views

### Export Excel template with no meta data or special characters

We have a template that we are using to allow people to enter data in Excel, we then export that data to add to a database.
We need to use Excel for this because we have tens of thousands of users ...

**0**

votes

**1**answer

41 views

### Is Excel VLOOKUP the best choice for my application?

I have an Excel file that tracks the maximum elevation of the sun throughout the year, one row per day, given a specific lat/lon. If I edit the lat/lon the daily maximum elevation changes.
I'd like ...

**0**

votes

**0**answers

5 views

### NVivo-exporting a matrix to excel

After creating a matrix coding query with cases down the rows and coding categories across the columns, NVivo allows you to filter the matrix by row or column values, which is very helpful. However, ...

**0**

votes

**0**answers

7 views

### Link x2 Tables in Excel with Name Column in Second Table updated from Name Column changes in Table 1

I have a problem in linking name changes and alphabetically sorting the Name Column in Table 1 with the name column in Table 2. I shall be extremely grateful for any help: I am pretty much an ...

**0**

votes

**0**answers

23 views

### MS Excel with error messages

I have MS Excel spreadsheet with lots of tabs and 1 tab with workbook connections linking to other spreadsheet. It was working fine and after I have done the update, this message error appears:
This ...

**0**

votes

**0**answers

18 views

### Varying Chart Range Based on Drop Down Lists

I'm hoping to get some help with automatically updating the chart range in Excel based on what's selected in a drop down list.
I have 3 selections for my drop down list: All, Alberta and Saskatchewan....

**0**

votes

**1**answer

46 views

### Excel Chart with Different Series Lengths

I run a pool league and I have a chart of player handicaps over time. Handicaps change over time based on performance. Since not all matches are played on the same days, I chart against the ordinal ...

**0**

votes

**0**answers

11 views

### How can I set up a bar chart to have two bars for each product on different axes that don't overlap?

I am trying to put together a Pivot chart and would like to have two values associated with each of our products, each displayed on a separate bar. One of these bars is Sales (Tonnes), and the other ...

**0**

votes

**0**answers

21 views

### Column “skipped” when opening file in Excel

When opening some shared files in Excel, some columns are "skipped". They are not hidden but they are not visible in the window.
For example, Column A is not visible. At first look, it seems that the ...

**0**

votes

**1**answer

12 views

### Excel - Pivot table from multiple Tables with the exact same columns

So I've got Datasets from multiple third party sources, which have the exact same layout.
I put them into excel into 2 Tables like this:
Table 1 from source1
Year Month InfoType Source ...

**0**

votes

**0**answers

28 views

### Relative references

I'm trying to achieve this:
If Cell N2 contains a number (say 12), I want to add 12 columns after column EN with the formatting from column EN.
There is a formula in cell EN3 which is =IF(EN5>'...

**0**

votes

**1**answer

30 views

### Create dynamic copy of filter list in Excel

I have a list with names in column A Sheet 1. Each name appears several times. I would like to list each name once in Sheet 2. Basically sheet 2 is a copy of the filter list in column A sheet 1, but I ...

**0**

votes

**1**answer

31 views

### Excel open very slow if file located in sub-folders

Sames size of Excel files, it's much slower opened if it is in sub-folders,
For example:
C:\folder1\folder2\folder3\folder4\folder5\folder6\file.xlsx.
It takes 30 seconds to be opened.
When the ...

**-1**

votes

**0**answers

33 views

### Formula range is changing when I copy cells

I have numbers in cells C1, D1, E1, numbers are 1,2,3 respectably. Formula in cell A4 is =sum(C1:E1) and it's returning 6. When I select cells C1 and D1 and cut and paste in cell B1 formula is ...

**0**

votes

**1**answer

17 views

### Need formula to vlookup comma separated values in a single cell

I'm trying to do a vlookup on a cell with comma separated items in it for the lookup_value, referencing another file that has 1 item per cell. My example below has 6 items in the csv cell, and i want ...

**0**

votes

**0**answers

20 views

### Can't get over #VALUE error in SUMIFS() where 2nd criteria being < given date

I have made a home budget spreadsheet where I got a main calendar view and tabs for 'Standing Orders', 'Income' and 'Expenses'.
In the main view I use a forumla that returns sum of all payments at ...

**0**

votes

**0**answers

25 views

### VLOOKUP - return multiple values/columns for each row/match of data

This question is related to this one: VLOOKUP - return multiple values/columns for one row/match of data
Let's say you have a column of values that you want to use as lookup values. I referenced the ...

**0**

votes

**0**answers

20 views

### Excel drop down list

In excel, I am trying to create sheets that grab data from the master sheet based on which drop down is selected in the master sheet.
Example would be I have monthly stats sheets. On those monthly ...

**0**

votes

**2**answers

22 views

### How to remove gaps in between an excel graph

I have a table that contains time (date) and speed values. However, the values only exist in clumps, meaning there are dates that do not have corresponding speed values. Is there any way to remove the ...

**0**

votes

**1**answer

98 views

### How to reverse a string in Excel?

Is there an Excel function (or macro) I can use to reverse a string. i.e. to turn these words into sdrow eseht?
Here is why I need that:
My strings are similar to John|XYZ Street|215|USA and I need ...

**1**

vote

**1**answer

59 views

### Can't figure out multiple IF function

I have been fiddling with this equation for a while now and can't figure out where the mistake is.
Can anyone help?
I am using Excel in Denmark and it requires that I use commas instead of periods ...

**1**

vote

**0**answers

25 views

### VBA Code Enhancements

I have been using the following macro, which works very well indeed, but it has come to the point where it needs some enhancements:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myMail As ...

**0**

votes

**0**answers

12 views

### How can I see a reference on all tables in a SQL database that is for Aptean Made2Manage ERP software?

The ERP program Made2Manage works from a MS SQL server and has at least a hundred tables, all with cryptically short names and even shorter field names inside the tables. I can get access to the SQL ...

**0**

votes

**2**answers

633 views

### Excel, Creating sum, every 144 values in a row

So I have an excel file over some years with 10min values [A2;A181441].
I want to SUM every row of 144 values into [C2;C1261].
Looking forward to your answers!
edit: Thanks @Rajesh S for update: ...

**0**

votes

**2**answers

53 views

### how to split cells like Jan to Aug As Jan,Feb, Mar, Apr, Jun,Jul, Aug like this in excel using vba

I have like 1000 of records with cells like below
Jan To Mar
Aug To Dec
Mar, Oct To Dec
Nov
OCT,NOV,DEC
like this I have of 1000 of record with case sensitive letters,
i want cells with range to ...

**-1**

votes

**1**answer

34 views

### Generate Unique List from Table

I have a list of names in the leftmost column of a table, and between 1 and 4 languages entered into their own columns (lang1, lang2, lang3, lang4). I would like to create an area where names can be ...

**1**

vote

**1**answer

61 views

### Excel Conditional Format duplicate rows with mismatched record

I have employee records where an employee can have more than one row based on his rate, I want to format the rows where the employee Id is not unique to the employee
if the id is duplicated but his ...

**0**

votes

**1**answer

12 views

### Amend VBA code to hide empty columns in whole workbook

I found the below code in this thread (Excel - any way to auto hide empty columns when filtering rows?) which hides columns with only a header in them but no data. It works fine for what I'm doing, ...

**-1**

votes

**1**answer

27 views

### Adding specific data in one column and comparing with another column

I have the below open reservation SAP report that has reservations corresponding to materials and the total available stock in warehouse. How do i add the total quantity required for a particular ...

**2**

votes

**3**answers

55 views

### count number of times a date is shown in a column

I have a list of dates in a column in Excel and would like to show a total for each unique date.
So say this is the original list:
03/05/2019
03/05/2019
03/05/2019
03/05/2019
03/05/2019
07/05/2019
...

**0**

votes

**0**answers

17 views

### Unable to copy text from IE browser and paste to an Excel cell

I am trying to copy the text (G1 RADAR) from the website opened through IE browser and paste this into an pre-specified excel cell, but unable to do so . can anyone help me out.
<span style="left: ...

**0**

votes

**2**answers

21 views

### How can I cut and insert paste multiple rows in excel?

I am trying to cut and insert multiple rows in excel. Below is the error message that I am getting.
The command you chose cannot be performed with multiple selections. Select a single range and ...

**0**

votes

**0**answers

17 views

### SQL Deadlock Troubleshooting and Statistics

One of my company's SQL database generates a lot of deadlocks per day recently (someday >100)
I'm trying to troubleshoot the causes of these deadlocks, i noticed that many deadlocks occur at the same ...

**0**

votes

**0**answers

40 views

### Excel - One conditional formatting rule to apply to columns with different conditions

I have an excel sheet which has a number of courses along the top and people down the left hand side.
Underneath the course name, I have the deadline for the course to be completed and in each person ...

**0**

votes

**0**answers

30 views

### Three way grouping in Excel

I have data in a pivot table that I need grouped in such a way that I'm not certain is possible.
My data is formatted in such a way
No. Document No. Jan Feb Mar Apr May ...

**0**

votes

**1**answer

20 views

### Vlookup or index/match to match a value to the left side of the numbers in a column

I am trying to figure out a way of performing a vlookup for a given value. The value I am looking up in correct in its form (six character number). But the values in the column that i am trying to ...

**2**

votes

**1**answer

32 views

### What formula in macro can I use to show a value as dd:hh:mm, exceeding 31 days?

When using the format for dd:hh:mm Excel gives us, it is not possible to show an amount of days greater than 31.
Using the following formula in macro is not possible
=INT(C5)&":"&TEXT(C5,"...

**0**

votes

**0**answers

33 views

### MS Excel 365 : Comma Delimited data to rows for multiple columns

I've comma delimited values in two columns like in the image here.
Main data:
After using power query and splitting them in rows , I'm getting data as:
But the expected data format is:
How can I ...

**0**

votes

**2**answers

24 views

### SUMIFS with Date range and Category column

I am newbie in using Excel functions. I have an excel file as shown in the following screenshot. I used following formula for getting total sale amounts for the sale happened between 02/01/2019 and ...

**-1**

votes

**0**answers

15 views

### Excel - Transposing information from multiple rows to columns with their respective answers

I have a file which has the column headers Full Name, Question, Answer.
I need the data in such a way so that the column headers are Full Name, Question 1, Question 2 and so on.
Each questions column ...

**1**

vote

**2**answers

47 views

### Format Excel Column as a Date based on numbers

I have an excel file and a column of what are meant to be dates in the format of the first 4 digits being the year and the last 2 being the month. Is there a way to format this column in "mm-yyyy" ...

**-1**

votes

**2**answers

71 views

### Auto populate a column to a different sheet if a condition is met

I have been trying to Auto populate a column onto a different worksheet only if an action is Ready.
If a file is marked as 'Ready' for scanning, it should auto-populate to a different worksheet with ...

**0**

votes

**1**answer

31 views

### Using conditional formatting to identify formulas (Excel 2010)

I have a long sheet where some cells have typed values and some other cells have formulas. And i need to have a visual identification of the kind (number or formula) of each cell.
Is it possible to ...

**-1**

votes

**0**answers

33 views

### How to work with Excel COUNTIFS?

I'm working on a team project where I need to formulate the status of active users in the past month. For that, these are the variables I would be using - the user's name, their status (active or ...

**1**

vote

**1**answer

21 views

### Sorting Complicated Data

I have an Excel spreadsheet of data and I'm not sure the best way to sort it.
It is for an insurance plan. The data includes subscribers, spouses, and children, each with their own row. Each ...

**0**

votes

**1**answer

26 views

### Does Excel auto-refresh run when the excel workbook is closed?

I am currently connecting to a SQL database from Excel and am trying to refresh that data at set intervals and to do so am using the auto refresh option located under connection properties. The ...