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.

learn more… | top users | synonyms (2)

0
votes
0answers
58 views

Regroup rows based on a column value

I have the following data: Last Name | First Name | Division Doe | Jane | A Doe | John | B Does | Michael | B So, every user is assigned to a group. Now what I would ...
0
votes
0answers
15 views

Excel 2010 key board shortcuts extremely slow [duplicate]

I'm using Excel 2010 and I'm getting some strange behaviour when i try to use the keyboard short cuts. For example if I type Alt-E-S to bring up the paste special window it can take anything up to 10 ...
0
votes
0answers
110 views

Excel recover read-only edited file

I needed to edit a file which was sent to me as an attachment in email. I opened Outlook and then opened the attachment in Excel. The Excel window appeared probably in read-only mode which I didn't ...
0
votes
0answers
24 views

LWD, WTD and MTD Split

All, I have a list of data and I would like to do a summary table that automatically calculates entries for the last working day, week to date and month to date. Sample below. So in my summary ...
0
votes
1answer
41 views

Error in importing the numbers in scientific notation

I am importing(copy-paste) values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is not treating them as numbers instead text. How to resolve this ? ...
0
votes
1answer
97 views

How to transpose two cells data at a time from 2 cells to multiple rows

I have Excel data in the below format: Excel Std Row: A B C D E F G H I J 1st Row Data: 1 1 2 2 4 4 5 5 6 6 Now I need output as below: A B ...
0
votes
0answers
77 views

All Data Option Filter Validation

I am creating a dashboard that has five inputs that filters my data by the custom data validation combination. My dashboard updates correctly based on the custom combinations, but I am unable to add a ...
0
votes
1answer
36 views

How to compare differences for multiple possible pairs of cells in Excel

In Excel, I have 7 columns of data (numbers) spanning 100 rows. For each row, I want to check whether at least one number exceeds all other values by a certain value (say 0.2 or greater). If so, the ...
0
votes
1answer
2k views

How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...
0
votes
0answers
124 views

Update Table based on Range start value and end value

I have a set of data that uses a primary key of month of the year by numerical value, e.x. Month 1, Month 3. I am trying to update my table and its values from the raw data set based on a user entered ...
0
votes
1answer
24 views

Excel Formula change and remove

The numbers on the form are for two different references. 2015-##### (five digits after year) is the way it will be entered. When the user enters that I would like to enter in another cell the result ...
0
votes
0answers
113 views

Crash when using Get External Data From Web in a macro

Is there a way to disconnect IE from Excel when using the "Get External Data From Web" and use another browser such as Chrome or Firefox? I've been having problems where IE stall/hangs and the ...
0
votes
1answer
78 views

Google Spreadsheet =Filter in excel

I have this formula in google spreadsheet that uses the =FILTER functionality but I can't seem to find the corresponding syntax in excel. Specifically the formula is as follows: =FILTER(A2:C6,B2:B6=2)...
0
votes
0answers
33 views

Conditional Formatting using Excel writer

In Excel, using Interop dll I have following code. objWorkSheet.Range[objExcel.Cells[intHeaderRowCnt + 2, 6], objExcel.Cells[intCellRowCnt, 6]].Formula = "=RC[-3]-RC[-1]"; ...
0
votes
1answer
43 views

Using filter in Excel

I have an Excel file which contains details of all the school students from A to Z. Out of it, in a separate sheet created FEES DUE FORM for each class that contains only ROLL NO., NAME from APR '14 ...
0
votes
0answers
33 views

Is there a way of 'detaching' a column from the rest for the purposes resizing the cells in it?

Here's an example Excel spreadsheet. Basically what it is an chart for time organisation, and I use the left most column for storing some notes (back log items etc). Now I need to to keep the ...
0
votes
1answer
97 views

Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well. The ...
0
votes
0answers
265 views

Excel - Adding titles to both ends of an axis in a scatter plot

I'm looking for a way to add axis titles to both ends of an axis in a scatter plot in Excel 2016 for Mac. So far I have titles only in the left and bottom parts and want to add the titles on the ...
0
votes
1answer
222 views

Adding time values produces 0:00:00

in-time is 9:36:00 out-time is 18:53:00 hours worked = 9:17:00 required hrs = 9:30:00 (a specification) The difference between hrs req and hrs worked is = -0:13:00. Formula used: =IF(D2>...
0
votes
2answers
2k views

Assign category to data based on range

In Excel, how would I take numbers from one column and assign them to a category in another? E.g., if I set ranges that correspond to certain words 1-10=Beginner, 11-20=Intermediate, etc. How would I ...
0
votes
0answers
515 views

Strange graphical glitches in Outlook, Word and Excel

My coworker is experiencing strange graphical glitches while using Outlook, Word and Excel: When she is composing an email in Outlook and she types in the body of the message, the text often appears ...
0
votes
2answers
327 views

Populate missing entries from one sheet to another

I have two Sheets in Excel. For this example, Sheet 1 and Sheet 2. Sheet 1: 100 records with Name, Location, Gender Sheet 2: 100 records with Name, Location, Age The sources of the data are not ...
0
votes
0answers
36 views

Moving away from nested ifs to allow for more filter options

I'm hoping I can get some help in improving the approach that I'm currently using to Sum and Count rows of data based on filters my users can select. Currently I have 7 filters that I check to see if ...
0
votes
1answer
60 views

Modify Concatenate Formula to add an additional column (Mac Excel 2011)

I would like to modify this formula to ADD another column: =IF(LEN(AK2),AK$1&": "&AK2,"")&IF(AND(LEN(AK2&AL2)>0,COUNTA(AK2:AL2)=2)," _ & ","")&IF(LEN(AL2),AL$1&": "&...
0
votes
1answer
58 views

Excel formula for checking if a string is a substring of another string and if so, creating a hyperlink

So I've been working on this problem at my office now for awhile. I have an excel file with a few thousand lines representing files that the office has either opened, scanned in, closed or destroyed. ...
0
votes
0answers
65 views

Lookup ProductID on another sheet and return the lowest cost and its column header

I have recently been working with formulas and larger amounts of data than usual and need a little help. What I am trying to accomplish is the following. I have two workbooks (which I could make ...
0
votes
1answer
143 views

Concatenate with column header but omit blanks with Excel for Mac 2011

I want to modify this formula: =A$1&": "&A4&" & "&B$1&": "&B4 Sample: Column A: a info & Column B: b info So that if there is a blank cell the Title and the blank ...
0
votes
1answer
282 views

Run Excel macros in multiple files and paths

I need assistance to enhance the method I've implemented. Here are the details. I have multiple excel spreadsheets (xls, originally written on Excel 2007 or 2010) that have 3 main macros that I want ...
0
votes
0answers
24 views

Microsoft Excel 2013 - Decimal Place Errors [duplicate]

Look at the difference of two values!!! The third cell is the difference of the two previous values. First case: 50.58 14.57 36.01000000000000000 Second case: 150.58 114.57 36....
0
votes
0answers
42 views

Heterogeneous Workbook Consolidation – Need Assistance

I have several Excel workbooks, each containing a couple dozen spreadsheets. The workbooks have different names and so do the spreadsheets, and simply mass consolidating doesn't help with the issue I ...
0
votes
0answers
17 views

Excel Popup Blocking Other Spreadsheet Interaction

I have two coworkers that utilize an Excel file that has VB forms built into it. User A has two open excel files on different screens. When they activate the user form for modification, it prevents ...
0
votes
0answers
34 views

Iterating through dozens of Excel Sheets while summing up a specific cell or similiar stuff?

I have dozens of Excel files named very similar. For instance: "I_XXX_YY_ZZZ Surname, Name" the only constant is the I, it doesn't ever change. Every single one of these excel file is made according ...
0
votes
1answer
91 views

Copy range of cells within VBA module

I am trying to copy a range of cells in a specific sheet on the click of a form button Sub Button1_Click() Sheets("Marina").Range("A1:H10").Value = Sheets("Marina").Range("A13:H22") End Sub In ...
0
votes
1answer
307 views

How to write VBA code that looks to a cell for a column header in another sheet, then returns the corresponding column? [closed]

So I have a full spreadsheet of customers as columns and products as rows, the crossing cells indicating how many of each the customer has purchased. In another sheet i want to be able to run a macro ...
0
votes
2answers
107 views

Excel 2013 Sorting alphanumerics with spaces

I have a list of Hebrew dates that looks like this (actually over 200 entries, of course): Tammuz 5 Nissan 7 Tevet 10 Tevet 10 Tishrei 11 Av 2 Adar 1 Adar I 21 Tammuz 14 Tammuz 25 Tammuz 23 ...
0
votes
1answer
61 views

Excel formula for organizing data

I would like a formula that could organize data by: deleting or ignoring the #N/A. give me the cells that have a numerical value and are in order by week number. For example: ...
0
votes
1answer
162 views

Search through an email to find and highlight text

I'm working with Excel trying to automate the sending of some emails. Right now, the code creates an email based on the cells next to the button clicked, forwards the email to the listed in a cell, ...
0
votes
0answers
23 views

Auto Sum Conditioning Statement [duplicate]

Need help with making an autosum statement for the following chart, the final version will be much longer. To Calculate #1, the calculation should be B2-B1 (since it is sold and in red), #2 would be ...
0
votes
2answers
170 views

Prevent formula input in all cells in a column, but allow whole number input

I am in a bit of a sticky situation. There is a public spreadsheet that some of my coworkers are required to use for their job. They all collectively use it during their shifts to track product ...
0
votes
2answers
35 views

How to determine number of rows in data, and use that value in defining a range

In my macro there is a line: Selection.AutoFill Destination:=Range("A2:A86893") but the final cell number (86893), which is the total number of rows in my data, should be changed every time the ...
0
votes
0answers
70 views

Edit Auto Sum Conditioning Statement

Need help editing totals when something is sold, it should subtract from totals. http://i.imgur.com/9G8oTPU.png To Calculate #1, the calculation should be B2-B1 (since it is sold and in red), #2 ...
0
votes
2answers
115 views

Excel - how to stop automatic destructive re-formatting of fields on document load [duplicate]

I am trying to edit a csv file in excel, but am running into issues with its supposedly-helpful automatic format detection, and I don't know how to turn it off. I have a field with an original value "...
0
votes
1answer
81 views

EXCEL: Icon Conditional Formatting Based on Range of Values

I am creating a spreadsheet for work and I need to format cells such that I get a green check mark when the value in the cell is between 100 and 101, yellow ! if it is between 97 and 100, and red X if ...
0
votes
1answer
113 views

How to get a formula to extend to new cells depending on pivot table

I have a pivot table with some formulas using the data from the pivot table to the side of it. My problem is that if I add a filter, say city, so that the pivot table extends down, the formulas to the ...
0
votes
0answers
36 views

Microsoft Excel 2011 concatenate each row in a cell

I am trying to use an if function for each row for a result in a single/destination cell. The if function checks if a row meets a criteria, if it does, it adds the row details to the destination cell ...
0
votes
1answer
27 views

How can i merge 2 sheets into 1 in excel

I have 2 sheets in excel. Some of the rows are common and some of them are different. How can I combine them into 1 spread sheet? Thank you.
0
votes
2answers
58 views

Multiple Formulas in a cell with IF condition

I am trying to figure out how I can insert multiple formulas in a single cell. The calculation pertains to date & time. Below is my questions. If A1 = Date & B1 = Time (military) AND C1=Date ...
0
votes
1answer
321 views

How to keep pivot table from expanding into occupied rows and columns

I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations ...
0
votes
0answers
76 views

Keeping multiple header rows visible while filtering in Excel 2013

I have read several other similar questions to this, however none of them capture exactly what I am trying to do. My table has multiple categories. Each category has anywhere from 2 to 10 items ...
0
votes
1answer
2k views

Create a box and whisker plot in Excel 2016

I asked this question on StackOverflow as well, but I realized that this site may be more likely to produce an answer. My question is: how to create a Box and Whisker plot in Excel 2016? I know that ...