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
0answers
21 views

Excel - How to merge files

I have been trying to see if it's possible to merge excel files of the same name located in the same folder but to no avail? At the moment, I have 9 folders containing 700+ excel files each. Some of ...
0
votes
0answers
9 views

Ratios for Pivot Table

I have a pivot table that looks like this: Band A Band B Band C Dep 1 12 300 17 Dep 2 92 450 23 Dep 3 7 989 121 ...
0
votes
0answers
15 views

Excel: formula is not updated when I paste into a new row

I use Microsoft Excel 2011 for Mac. I put the following formula into a cell: =IF($E2<30,1,IF($E2<60,2,IF($E2<90,3,IF($E2<120,4,5)))) It's basic classifier. Now, I want to use the same ...
0
votes
1answer
14 views

Project asset scheduling

I am trying to create an project asset scheduler in excel but am coming across an issue. I would like to see what project an asset will be used on given the asset number and calendar date. For ...
0
votes
1answer
22 views

How to leave a cell blank when using IF plus AND/OR statement

I am using the following statement and its working but i would like the cell to be blank until S, I or R are entered into G4 and I4. At the moment it states Fail. =IF(OR(AND(G4="S", I4="S"), AND(G4="...
1
vote
2answers
42 views

How to increment same set of numbers in Excel

I have following scenario. I have numbers grouped by 8 same values and then I want next 8 values to raise by 1. Example: 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 I tried few suggestions, but I can't get it ...
0
votes
2answers
29 views

I want the min date for a group of rows and identification of that row

I have input like this: I want Excel to tell me min date for o1, o2... but also give me which row has this min date. Desired output:
0
votes
3answers
34 views

Converting d hr m s to [h]:mm

I have data that is in the format of 'd hr m s' and want to change it to [h]:mm. Where the h is the d*24+hr. For example, this is the data that I currently have: What can I do to format the cell, or ...
-1
votes
0answers
13 views

VBA to pull and display data

I want to pull some data from website and using "Get Data from Website" pulls in more data then what I want. I searched youtube and websites but they all give different way to do this. Here is what ...
-1
votes
0answers
32 views

How to convert an excel formula into macro vba code

How do I convert below into macro vba code? =INDEX(CLASSIFICATION,MATCH(TRUE,ISNUMBER(SEARCH(NAMES,O12)),0)) I have a column (O) in Sheet1 which it needs to be searched from. I have two columns ...
0
votes
0answers
25 views

Excel 2016: All cells dark by default

I have a very weird and annoying problem. Cells in my Excel 2016 are dark by default. Every new document is dark. Every opened document is dark (sometimes with some exceptions). I tried removing ...
0
votes
0answers
12 views

What is the best way to pass an Excel rage to a user defined function?

I pass a big range from an Excel spreadsheet to the parameter ExcelRange of a user defined function (UDF) written in VBA. I can declare the parameter ExcelRange As Range and then convert it to ...
0
votes
0answers
22 views

Get addresses for all duplicates in a spreadsheet

I am trying to analyze output of performance benchmark. My spreadseet consists of multiple Linux top outputs spawned every 0,5 s for about a minute. I need to identify keywords that will help me ...
0
votes
1answer
22 views

Why Are Columns Used for a Single Category of Data?

Background I work on a manufacturing site. As part of my daily routine, I walk through the site and collect (write with pen and paper) data from all the analog gauges our system isn't able to log. ...
3
votes
3answers
200 views

Define a range using a formula

A simplified version of my problem is that on a different sheet called Sheet2 I have data that I want to average: =AVERAGE(Sheet2!$A$1:Sheet2!$A$100) Depending on where the code above is used I need ...
0
votes
0answers
8 views

Automatically create groups of sorted data (currently exist in pivot table)

I work for an IT department (supporting a school system) and we are trying to prepare for a large product refresh. Our user base is spread out across the county and comprised of 14 "regions", each ...
1
vote
0answers
9 views

Application.OnKey only for right ctrl in VBA

Is there any way to apply Application.Onkey method only on right (or left) ctrl (or alt, shift) key. I have been reading documentation and can not find it. Code will be run in Excel 2016.
0
votes
0answers
11 views

Highlight cells along a row based on the last entry of data

So I have the below spreadsheet in which I am trying to create a highlightable warning via conditional formatting that a service is due based on the last time an entry was input into the chart (in ...
1
vote
0answers
16 views

Why do input boxes appear in a different place to a message box VBA EXCEL

I have a worksheet that uses both input boxes and message boxes using vba. However the input box is displayed way above center of the screen, unlike the message box. See images below. Why is this, ...
0
votes
0answers
21 views

Unprotect workbook structure without password

I have protected the workbook structure (not the sheet) with a password, forgot the password and now i cannot get it unlocked. Is there anyway, either via vba code or via converting it to a .zip and ...
1
vote
2answers
31 views

Sum multiple rows on single condition

Suppose I have the following table in sheet month: And the following table in sheet __data: In sheet __data I'd like to sum all the values from column P,R,T,V and X, for the given category name. ...
1
vote
0answers
14 views

Propogate drop down lists along column based on pre-determined cell references?

I have a column of cell references to data in another sheet, without the equal sign (!SheetName$C$2:$C$5). Lets call this column A. These references are more or less in an arbitrary order compared to ...
0
votes
1answer
15 views

Visio Data Visualizer

I am trying to use the Visio Data Visualizer for the first time. I have followed the directions on the process map provided by Microsoft. However, when I select the table in the process map sheet, the ...
0
votes
0answers
14 views

Deletings row based on row number in excel(multiple)

I would to delete multiple rows in my excel sheet. The issue is i already know of the specific rows that i want to delete for example row 5,7,10,12,18,25(no specific order). Is there a vba where i can ...
1
vote
2answers
29 views

How do I freeze columns in Excel?

I don't think I can freeze columns / rows. I want to freeze the first 2 columns in my excel spreadsheet. I have read that I would go to View -> Freeze panes. But I am not given that option. When I ...
0
votes
0answers
20 views

Create several rows from a single row's data [duplicate]

I basically have something like this: ID CreationDate AcceptedDate DeliveredDate 1 Jan-1 Jan-10 Jan-20 2 Jan-2 Jan-10 Jan-21 My goal is to create a pivot table ...
-1
votes
0answers
37 views

multiple table multiple criteria lookup

I'm looking for some help to lookup a value H6 in different tables based on criteria in H7 and H8 It looks up the value from the first table but when I change the value in either H7 or H8 I get either ...
0
votes
0answers
8 views

Excel is corrupted when Attaching it to MailMessage C# [migrated]

I created application that generates excel file from DataTable using EPPlus library. Then I add MemoryStream instance to Attachment. Program works fine, i receive email, but when I open file, i get an ...
0
votes
4answers
27 views

extract text from the last special character in excel

EXample: *AB|USA|California|los angles_backup *AB|USA|California_backup Questions: I need the word after the last pipe(|). In the first example, I need only Los angles and for 2nd example, I need ...
1
vote
1answer
11 views

How to format Excel cells to show only a certain part of the code my scanner scans from certain objects?

For ex: When I scan an qr code it shows: Column A1 vbmsavchjas asdhgaskhdgaskhdg_INX7642854858625 but I am only interest in the last characters: Column B1 INX7642854858625 I can use afterwards in ...
0
votes
0answers
26 views

Extracting all rows based on a value of cell

I am looking to list all the values of a cell that match the criteria. My first Sheet 1 contains the data (refer screenshot), will have 3 columns A, B & C, and nearly 12,000+ rows. In Sheet 2, ...
0
votes
1answer
17 views

Using Excel Solver for conference schedule optimisation

I want to use Excel Solver to optimize the schedule of a conference. The end goal is that every conference session is thematically coherent, and sessions are grouped by subject. I created a ...
0
votes
0answers
21 views

Excel 2016 - dynamically load table data

Need advice on the best way to create a table as shown in the attached diagram. The dataset of this table is "relational". As in (with reference to attached screenshot), department has one or many ...
-1
votes
1answer
29 views

Excel function query

Problem : I have made some risk amount provisions in excel sheet and those provisions are made for more than 60 stores. Now I would like a function that retrieved today's date from Excel and if the ...
0
votes
0answers
21 views

Need help in Excel Macro

We maintain hours worked by each of team members day wise in columns and we have lot of calculations build based on this sheet. One of our client is asking to submit the hours in their template ...
0
votes
0answers
15 views

How can I convert a vertical list of data to a horizontal chart with lists below in Excel?

Is there a way to convert a dataset that looks like this Vertical Dataset to a horizontal dataset with vertical lists like this Horizontal Dataset Note: the first column is turned into the header, ...
0
votes
1answer
34 views

Add Different new values to an existing total as previous but to add to column B not just B1

I Have a Value in cell A1 that I keep changing, but need to keep adding it to existing values in B1, B2,B3 etc. Useing your previous example it managed to get Value in A1 To Add To B2 but not to the ...
0
votes
1answer
28 views

Returning a blank cell (not an empty string) from an IF in Excel

Currently I have an Excel formula which reads: =IF(ISBLANK(F24),"",F24*$C24) However, if F24 is blank, this formula does not return an empty cell. It returns an empty string, which causes a #VALUE ...
0
votes
0answers
19 views

Duplicating Cell Text Formating using Offset/Indirect

I am attempting to create a "GUI" for my sheet with variable inputs options depending on other inputs. This means I have to summon the text from elsewhere using Offset() or Indirect() or similar ...
0
votes
1answer
25 views

Create links to RDP servers in Excel

I'm in the process of putting together an excel spreadsheet that contains a list of windows servers. I would like to create a link which is a shortcut to connect to each server via RDP. Unfortunately,...
0
votes
1answer
34 views

How can i simplify my code using LOOPS in VBA

I need to copy contents from a column in one worksheet and paste it into another (at the same time making a total of 7 copies of each of the variable). There are multiple columns and each column has ...
0
votes
1answer
27 views

Excel fill cell with “YES” if the date is after today (Windows 10, Excel 2010)

I want to use an IF function, to do something like "if date is after today, cell = YES, otherwise cell = blank". I can't quite get my head around the double formula of pulling todays date within the ...
2
votes
4answers
101 views

How to filter column by a single letter?

I have an Excel sheet containing 7000 rows of data. The column that I need to do a filter on is full of job descriptions. Its a lot of words inside a single cell and looks like this: What I'm trying ...
1
vote
2answers
54 views

VLOOKUP multiple values

I hope someone can help with this, I'm trying to find the wage in the tables and return what the percentage would be based on filing status.
0
votes
0answers
24 views

Strange behavior with Boolean variables

I am trying to calculate the number of closes above opens using the sum function with range selections and Excel is having difficulty getting the correct answer. A simple demonstration as shown below ...
0
votes
0answers
21 views

Toggle hidden columns

Given an excelsheet with e.g. 5 hidden columns I can select the complete sheet and press Ctrl+Shift+8 to unhide the columns (at least that's the combination on a german excel). Well, now I can view ...
0
votes
1answer
67 views

Add different new values to several existing totals

Below is the answer to a previous question. You can achieve what you wish to do using VBA Programming. In your worksheet default named say Sheet1 you have say cell A1 that shall be overwritten every ...
1
vote
2answers
49 views

Excel: Getting sum total based on date input

Thanks for the previous help, now I have another issue that I cant figure out. If you look at the image, I have the data spread out in groups. I tried "+" and "&" to add additional line to ...
0
votes
1answer
13 views

Excel: The Name of a Named Column

I use named Excel columns to simplify formulas. I would like to have the top cell of each such column serve as the column's title by displaying the column's name. How to I get the string? Edit: @...
0
votes
1answer
30 views

Refinitiv data in Excel - Retrieve Hang Seng Index

I can easily retrieve the Dow Jones (DJI), German DAX (DAX) or Nasdaq (NASDAQ). But I am unable to find the Hang Seng Index. "HSI" does return unrelated results only.