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.

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