Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

2
votes
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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 ...