# Tagged Questions

**0**

votes

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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 ...