**2**

votes

**0**answers

29 views

### Find string in the workbook in Excel [closed]

I don't want to use the ctrl-F function to find a string; is there a function that I can use to find a (sub)string from a whole column of excel workbook and then save the row number to print entries ...

**0**

votes

**0**answers

23 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

21 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

23 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

61 views

### Protecting a cell, but allowing the drop down list to work

I want to protect a cell that I have a drop down list in, but I still want the drop down list to work.
When I try to protect it, the user is not able to use the drop down list to select other items ...

**0**

votes

**1**answer

29 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

31 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

29 views

### VBA Code Isn't “holding” ThisWorksheet Parameter

I want to retrieve one column of values from another workbook and populate a tab in my current workbook. This will ultimately go into a much longer module I've written that works great. I just wanted ...

**-1**

votes

**0**answers

54 views

### This Operation has been canceled due to restrictions in effect on this computer, Please contact your administrator

One of the user's who has admin rights on their machine is getting the error message "This Operation has been canceled due to restrictions in effect on this computer, Please contact your ...

**0**

votes

**1**answer

28 views

### Excel 2013 - Referencing multiple checkboxes on a different sheet

Good morning, Superuser! I am facing a pretty tough problem at work this morning...my supervisor wants me to do something I have never done before, nor can I find a solution online.
The spreadsheet ...

**-1**

votes

**1**answer

40 views

### Excel Vlookup range or if function

I have been struggling to find a formula that works for the example below (see question mark!). What i am trying to do is merge 2 datasets. The problem is that the common identifiers are not always ...

**0**

votes

**1**answer

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

**0**

votes

**3**answers

61 views

### How to set date format when manually inserting date on excel, without changing regional settings?

In my locale, date is inserted as dd/mm/yyyy or variations of that (including dd-mm-yy).
I made an Excel form (in normal Excel file), already formatted to show date as dd/mm/yyyy, but when I typed ...

**0**

votes

**1**answer

36 views

### What formula would you use to add up a column based on results from two drop down menus? [duplicate]

I would like to calculate a column based on selections from two other columns with drop down menus.
For example :
In one column, "C" you have 3 options (A team,B team,C team), In column "F" you ...

**1**

vote

**0**answers

25 views

### How To find out the Jumping Number in EXcel [closed]

How to Find out the jumping numbers in Excel Like Below,
I Have Like
w001
w005
w009
w015
w069
I Want
w001
w002
w003
w004
w005
w006
w007
w008
w009
w010
w011
w012
w013
w014
w015
w016
w017
w018
w019
...

**0**

votes

**1**answer

38 views

### Want to get the unique combination of data for dynamic number of rows/columns

I have a few rows (the number of rows should be dynamic) of data that I would like to combine, and get each unique combination. I am able to do that for a specific number of rows of data, but when the ...

**0**

votes

**1**answer

15 views

### Assign number values to certain letters in Excel or OpenOffice

I'd like like to know how to assign to some letters a number value for a monthly Hospital schedule. For example:
N for night = 12h
M for morning = 6h
P for afternoon = 6h
CS for day off = 6h
R for ...

**0**

votes

**1**answer

47 views

### Excel not adding decimal numbers correctly

If I have a cell (A1) with a constant of -1.1 and then 11 subsequent cells referring to the first A1, and then to each previous one consecutively, after 11 cells, I'm expecting an answer of 0. ...

**1**

vote

**1**answer

35 views

### Excel SUMIFS based on two criteria

I would like to total a list of minutes based on two criteria to make a graph after the data is calculated.
The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus.
I ...

**0**

votes

**1**answer

23 views

### Current row index in table

How do you get the current row in a table?
I have tried:
This returns the worksheet row
=ROW([@[Column1]])
This:
=Table1[[#This Row],[Column1]]
gets transformed into:
=Table[@Column1]
and ...

**1**

vote

**2**answers

36 views

### Excel formula daily average of weight

I am looking to set up an excel spreadsheet to calculate cattle weight gain per day. We weigh our cattle once a week so column A will be a date and Column B will be the weight on that day(day of the ...

**0**

votes

**1**answer

29 views

### Variables not Initialized in Excel VBA Loop

I'm back with another question in VBA.
Here's the (updated) file I'm working on. When I try to run it, it says
Run-time error '92': For loop not initialized.
The loop is For Each var In accepted and ...

**0**

votes

**1**answer

58 views

### Excel Run Length Encoding

If I have a column of data in Excel that looks like:
1
1
1
0
1
0
0
1
1
Is there an easy way to convert it into a run length list that looks like this instead:
3 1
1 0
1 1
2 0
2 1
(Three 1's, ...

**0**

votes

**1**answer

10 views

### Excel - Signs in different columns

Given I have put by signs in a different column, making my data look something like:
How do I write a function to get the sum of these values (=198) with taking the signs into consideration?

**0**

votes

**0**answers

52 views

### Excel does not update formulas values after filling source cells with values

I do 3 steps:
Based on a template, I create a new Excel file through code (it works fine):
Shared Sub FillExcel()
Dim extension As String = ".xlsx"
Dim sourcePath As String = "c:\Temp\libro" & ...

**0**

votes

**2**answers

21 views

### Initializing Variables

I'm working on a project that involves using Excel VBA. Unfortunately, I'm new to VBA and I think I ended up confusing myself while coding. Here's the file I'm working with.
When I attempted to test ...

**-2**

votes

**1**answer

22 views

### List of dates, need count of each date

I have a list of rows with date and want a count of how many times each date appears in the column. I'm wondering if anyone knows a way to do that?

**1**

vote

**2**answers

51 views

### Creating a chart with two different scalings on the y-axis [duplicate]

I want to create a chart with two different scalings (steps of 500 and steps of 10.000) on the y-axis.
This is needed because there is a fixed cost of 1000 (so a straight line from left to right) and ...

**0**

votes

**1**answer

37 views

### Finding Common and uncommon values in excel 2010 [closed]

I have some values/numbers from A2 thru F8, I need the common values in 1 column (i.e the values which are common in A,B,C,D,E & F)-THIS CAN BE IN COLUMN H
I also need values uncommon only in A, ...

**2**

votes

**1**answer

22 views

### Can you lock out users from editing graphs in Excel

I have a tool written in VBA in Excel but I am having problems with users changing the graph data series.
Is there anyway that when they open their copy of the file, to deny access to graph controls? ...

**1**

vote

**2**answers

44 views

### Subtract milliseconds from Time in Excel

I have a logdata file with an end time, and the operation duration specified in milliseconds. I would like to subtract the duration from the end time, to get when the operation started. How can I do ...

**3**

votes

**1**answer

56 views

### Data transformation in MS Excel

looking for help on converting data from one format to another -
If you want to see data in sheet is here -
...

**2**

votes

**1**answer

33 views

### Excel formula sum multiple rows/column once on cell has reached it's max number and continue to sum

I am trying to come up with a formula that will split three rows of numbers evenly until one cell reaches a max number and then continue to sum the same three rows but split all the new values in two ...

**2**

votes

**1**answer

43 views

### How can I use Excel to monitor my payable?

Here's what I wanted to happen, I have five columns
Supplier Amount Payment Supplier1 Supplier2
When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...

**2**

votes

**1**answer

27 views

### Numerical index structure out of a folder structure

I'm new to this and I will do my best to ask this question correctly. I need to create a numerical index structure out of a folder/document structure as such.
I have this information:
...

**2**

votes

**1**answer

19 views

### Sumif function to add smallest number

I am trying to add the smallest number out of one row 1 in Column O through R. I would then like to add the number found (smallest) to the value in column S. What formula is used? I know its ...

**0**

votes

**1**answer

17 views

### I want to take two columns of cells (not the whole columns) and copy them and sort them into different cells

My Table:
I want to copy the names and scores from the desirability score area into the "Most to least desired rooms area but place them in descending order. How do I do this? Edit: I want the ...

**2**

votes

**1**answer

11 views

### How do I link a filtered range from excel to word?

We are using word to print labels with lists of components; say, sku ABC includes components a, b, c, and d, but sku XYZ includes components a, b, and f. Anyway, we have a master excel file that ...

**1**

vote

**1**answer

8 views

### Sorting data Alpha Numeric value within a field

I have a column of numbers that all start with the first four digits being numeric, then a alpha character, then 6 numeric digits.
What is the formula that I should use to sort this field so that ...

**0**

votes

**0**answers

27 views

### Combining all combinations of data from 8, 9 and 10 columns in excel

I'm attempting to figure out how to run all possible combinations for data in 8, 9 and 10 columns (each on different pages) and would love to have a macro for each.
Below is a macro for three ...

**0**

votes

**1**answer

14 views

### Autofill in a Excel macro

I have the following macro in Excel
Sub IHIAddWeeks()
'
' IHIAddWeeks Macro
' ihi-table
'
' Keyboard Shortcut: Ctrl+Shift+I
'
ActiveCell.FormulaR1C1 = "=YEAR(RC[1])&WEEKNUM((RC[1]))"
...

**-1**

votes

**0**answers

17 views

### How can you concatenate columns based upon the value in the header row(1:1)?

I have a workbook that has dozens of columns and some of the column headers are the same. For those columns that have the same column header, I need them concatenated and the resulting column pasted ...

**0**

votes

**1**answer

22 views

### Is there a way to sort digits within one cell for an alpha-numberic number in Excel 2010?

I have a list of Alpha-numeric values in an Excel Spreadsheet. I would like to sort only a portion of the value, rather than the whole value itself.
For example:
0032A04550
I would like to ...

**0**

votes

**1**answer

24 views

### How do I add a command to skip duplicates?

I have the following macro. I am using it to sample for rows but I want to edit it to skip rows that have already been selected. Can anyone provide a solution?
Sub GenerateSample()
Dim all As Range
...

**0**

votes

**2**answers

29 views

### How can I return the second last text value from a row?

Could anyone tell me the Excel formula to return the second last text value in a row?
I managed to find this formula for last text value: =INDEX(U2:Y2,MATCH(REPT("z",255),U2:Y2)), but not sure how I ...

**1**

vote

**1**answer

37 views

### Budget planning with Microsoft Excel

I have an Excel worksheet which is regularly populated with daily expenses:
Then to extract a report on the amount of money spent on each category, I simply use a pivot table like below:
I am ...

**2**

votes

**1**answer

32 views

### Excel - How to include a count of blank cells in Pivot Table?

My Pivot Table totals the occurance of various strings in my column. Some of the cells are blank. I want the "blank" category to display a total count. How is this done?
Similar unanswered question
...

**1**

vote

**1**answer

21 views

### Excel - Updating Month For 2 Fixed Days Each Month

I want to fix 2 days and update the month for every new month. E.g.
1/10/15
1/22/15
2/10/15
2/22/15
3/10/15
3/22/15
and on and on. I want to do this in one cell in Excel 2013. So after a certain ...

**1**

vote

**1**answer

36 views

### Find the previous Row with a specific value at in column A

Given the above sample sheet, which has semantic 'header', 'subheader' and 'subtotal' rows, I am trying to determine a formula to locate the previous subheader row relative the current cell. For ...

**0**

votes

**1**answer

14 views

### Find missing values on spreadsheet 1 when compared to spreadsheet 2

I have the following scenario:
I have a list of ID's on a spreadsheet generated from a web app that has to be compared to our internal system. Any missing values from SP1 have to be alerted since ...