**0**

votes

**0**answers

10 views

### Excel for scheduling

I have an excel workbook calendar with 4 different worksheets for scheduling my staff. One sheet for each position. Some staff members have multiple positions. If I schedule someone for one position ...

**-1**

votes

**0**answers

5 views

### Need help in sorting a column in a file

Unable to sort an excel file. I need to sort based on a data in column M which has v look up formula. I copy that column & paste the value in column N. I then shade the rows/columns of the file ...

**0**

votes

**1**answer

10 views

### Microsoft excel collaboration

Is there a better way for multiple users collaborate on the same excel file? I am looking for something like google doc, so users can work on the same file at same time. I know something called ...

**0**

votes

**1**answer

18 views

### Creation of an IF formula that will return a 1 or 0 for times between a range

I am trying to create a spreadsheet that will calculate total number of patients per hour. I have an arrival time and a discharge time. What I was thinking is to organize my spreadsheet with times on ...

**0**

votes

**1**answer

16 views

### Microsoft Office 15 Applications display errors when attempting to preview in Windows Explorer

In Windows Explorer (WIN 7 Pro SP1, 64-bit), if I click on a file belonging to any of the 3 Office programs that Explorer will preview in the Preview pane, I get an error, and no preview is generated.
...

**0**

votes

**1**answer

10 views

### How can I get the secondary horizontal axis to the left and primary horizontal axis to the right in MS Excel 2013?

How can we get the secondary and primary horizontal axis to the left and right side respectively?

**0**

votes

**1**answer

21 views

### Automatically determine number-of-decimals in Excel list based on data?

Let's say I have a list that looks like this:
4
1.5
6.333425
When I put a list like this into something like ListPro, the program understands that these are numbers (not string) and yet ...

**0**

votes

**0**answers

9 views

### Excel macro to copy rows with unique name in column A to accordingly named wosksheets

I am an Excel novice, and would appreciate help with a macro which does the following.
There are a total of 58 genes (column A) with 2 entries for each gene. The image only shows 4 genes.
Upon ...

**0**

votes

**2**answers

23 views

### Excel document missing

I use an excel document every day. I closed it out on Tuesday.
This morning when I turned on my desktop it was gone from my desktop.
I ran Superantivirus and Malwarebytes to check and make sure I ...

**1**

vote

**0**answers

30 views

### Put parentheses around sold items in Excel Formula

I would like to add parentheses to several columns in excel that will show items sold and will be subtracted from the finals column. Not sure what the formula would be.

**0**

votes

**0**answers

20 views

### Assign a value to a cell based on another in that row (please see explanation)

I have searched far and wide, and I see many things that come close, but nothing that solves my problem...
I work for a police department, and our city is broken up into reporting "districts." Every ...

**-1**

votes

**1**answer

25 views

### How to use non-contiguous range arguments in Excel's XIRR?

The XIRR requires range arguments. I would like to know how I can somehow use 'split' ranges which are in different locations. Perhaps the picture explains it better. What do I enter in F7, if I want ...

**1**

vote

**1**answer

32 views

### How to “Round half to Even”?

I need to "Round half to Even" (Bankers' rounding) a number in Excel. So:
4961,25 => 4961
9738,75 => 9739
4934,5 => 4934
4935,5 => 4936
How can I do it? It must also work "online", ...

**-3**

votes

**2**answers

62 views

### Excel date formula

Could someone look at my formula and assist me with a resolution? The formula must have an error since my amount is going into column AD instead of AC like it should. See highlighted cell.
For ...

**0**

votes

**2**answers

29 views

### Excel pivot: count of items across multiple columns

I thought this would be easy but I'm really struggling.
I have items across different columns and I need a count of all the items across each column.
Data:
Desired Pivot Table:
What I'm trying ...

**0**

votes

**0**answers

18 views

### Solver causes error “Excel has stopped working”

I want to use the Excel-Solver-Add-In to solve the following simple calculation:
1 2
A Revenue Variable of solver goes in here
B Costs A ...

**0**

votes

**1**answer

32 views

### Return Non Null Cookies And Count

I have two worksheets in my workbook. The first worksheet is titled SalesPerson and should show a rundown of the salesman that is entered in cell B1 and the type & quantity of cookies sold. ...

**1**

vote

**0**answers

15 views

### Excel Pivot chart with a legend summary table having SUM and COUNT of values

I have a pivot chart display some data I'm interested in. Using a summary table below the chart I can plot the SUM of the values. This works great for me since the data rows contains a 1 if I want to ...

**-1**

votes

**1**answer

51 views

### Open Password Protected Excel File [on hold]

How can I open password protected excel file.
I have seen many links but didn't get sufficient solution.
Can any body give me the best solution or reference link in this case?

**0**

votes

**2**answers

40 views

### Enhanced Excel formulas to be used

Products PD1 PD2 PD3 PD4 PD5 PD6 Summary of Purchases
Customer A 2 2 3 5 6 PD2, PD3, PD4, PD5, PD6
Customer B 2 2 1 PD2, PD3, PD5,
How do I summarise the ...

**0**

votes

**1**answer

31 views

### How to explode BOM(Bill of Material) in excel

What I Have in Microsoft Excel(2010)
What I want to see when I Click the (-) sign
So to Conclude the (+) sign is to show all the Level 0.1-0.3 While the (-) sign could choose to either Show ...

**0**

votes

**1**answer

32 views

### Compare two unordered lists in Excel and return differences

I have two Excel files, with customer data. I need to compare the two.
I have copied the username column from both into a new sheet. Now I want to go through, and if the username is in the first ...

**-3**

votes

**0**answers

9 views

### Excel 2010 Macros - Automation Error [duplicate]

When I upgraded to windows 10, a few macros I use in excel 2010 seem to have broken. They crash immediately when I run them and I receive an "automation error". They do not reference any outside ...

**3**

votes

**1**answer

36 views

### Sorting data without mixing rows

I have three sheets. First sheet renamed General:
Dave Henderson 21/05/2014
Elton Rus 22/06/2014
John Smith 20/05/2015
Second sheet renamed ...

**1**

vote

**1**answer

27 views

### Running Parameterized Stored Proc From Power Query

I have been following the tutorial HERE but anytime I try to refresh the workbook, it gives me an error of:
DataSource.Error: Microsoft SQL: This database function doesn't support the query option ...

**0**

votes

**2**answers

32 views

### Row sorting in excel

Please how can I highlight certain cells(one each/row) that are in rows?
For example I have a list of quotes from different suppliers and I want to select only the min/least price of each item and ...

**0**

votes

**0**answers

31 views

### Create multiple files based on one column of master sheet in Excel and copy paste information, Do the same for other tabs

Title does gives me suggestion for the questions which already might have an answer but they, Don't i have tried some modification to the code but they do not seem to agree. Here is my problem. I have ...

**0**

votes

**2**answers

27 views

### Extract a worksheet from Excel retaining data values not references

I have a workbook that contains about a dozen sheets. One sheet is called "Summary", and most of the data in it is either a reference to another sheet ( ='Pre-Survey'!C10 ) or a label ( =ShipName ).
...

**0**

votes

**1**answer

28 views

### Mirroring formulas to multiple sheets in Excel

I have an Excel Workbook with multiple Sheets each using the identical layout, but with different sets of data. From time to time, I need to vary the way the values are calculated, but I don't want ...

**0**

votes

**1**answer

27 views

### Excel search for substring and display count

This is an extended question from this one.
Suppose now I have a following table with strings:
A
1 CHI111
2 SEA222
3 SEA333
4 LA444
...
I also plan to have a table to keep count of ...

**0**

votes

**1**answer

18 views

### Excel - Reference cells with same value and SUM

The excel data sheet I have takes this form:
XGTI, 10
XGTI, 12
BIOC, 5
BIOC, 5
BIOC, 1
BIOC, 10
XGTI, 5
BIOC, 1
MGT, 2
MGT, 4
I would like to total all the values separately from each other.
e.g.
...

**0**

votes

**1**answer

23 views

### Excel Formula that autofill an array with a list, based on an array

I'm trying to do a formula that within a range makes a list based on info on a specific array.
What I need is an array that aufills this list based on the following conditions:
1)It has to be the ...

**0**

votes

**1**answer

16 views

### Excel search for string in multiple cells, compare and display string with most counts

Excel 2013
I have a table as follow:
A
1 CHI
2 SEA
3 SEA
4 LA
...
How do I write a formula that can check cells A1 ~ A4 and display on another cell the string with most count? In this ...

**0**

votes

**0**answers

25 views

### Find the number of points between two “scatter with smooth lines” series in excel

I've attached an image that shows the scatter plot I've built in excel. I need to know how many points are between the dashed line series and the solid line series just to the inside of the dashed ...

**0**

votes

**0**answers

17 views

### cell matching in two different sheets

I have a worksheet which requires two outcomes.The worksheet retrieves data from a database structured: code, description and price. Now on the worksheet, I have included an extra column for a special ...

**0**

votes

**0**answers

20 views

### How to use colored cells along with multiple criteria data in formulae

I have an issue where I need to use SumIf/SumIfs formula to accomplish the following:
- Find cells within the spreadsheet filled with different colors which indicates a specific product and test for ...

**0**

votes

**4**answers

68 views

### How would I calculate the number of pay days before a date?

I'm working on a budget spreadsheet and I'd like to calculate the number of pay periods before a certain date (including that date if it's a pay day). I'm not really sure how to begin.
My pay periods ...

**1**

vote

**1**answer

28 views

### SUMIF based on multiple criteria

I want to get the sum of a range, but I want to change how the sum us calculated based on critera.
Say I have a table as follows
Name | Value
DP | 2
DP + BC | 4
DP | 4
DP + BC | 6
So ...

**0**

votes

**0**answers

11 views

### In Excel 2016, how can I force Worksheet scope when creating names using “Create from Selection”?

Problem summary
In Excel 2016 (Windows), when using "Create from Selection" to create names constructed to be Worksheet-scoped, the Worksheet-scoping character ! gets converted to an underscore, ...

**0**

votes

**0**answers

85 views

### Run function manually on selected cells

How can I resolve the type mismatch error I am getting for the argument being passed to ExchangeRatesCalc (which should be a string)?
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal ...

**1**

vote

**0**answers

41 views

### Upgraded to Windows 10 - Macros Broken

Problem:
I finally upgraded to windows 10 and a few macros in excel 2010 that I use frequently no longer work. They crash instantly when I run them and all I receive is an "automation error". They do ...

**4**

votes

**2**answers

126 views

### Sort by Formula (without VBA)

I am attempting to sort a short column of values (descending) by using a formula in a different column. So if A1 through A10 contain numbers, in B1 I enter:
=LARGE($A$1:$A$10,ROWS($1:1))
and copy ...

**0**

votes

**1**answer

12 views

### Auto replace ID with name (excel/google docs)

I'm looking for some way how to do this. So let's say that I have a table where I have IDs and items, next to each other. And next to this table I have another, where I'll put these data again, but in ...

**0**

votes

**1**answer

29 views

### Formula to reference a cell value that contains text and retain the cell refences formatting

I have a bunch of cells containing text. The text in those cells have multiple font sizes and styles. I need to replicated those cells in a different order further down the worksheet and if I make ...

**0**

votes

**1**answer

63 views

### Excel formula to find lowest value above a given number and return the column name

I'm trying to write an Excel formula that will look at 5 columns of data (for example, labeled SEL1, SEL2, SEL3, SEL4, and SEL5) and return the column name of the lowest column with a value above a ...

**2**

votes

**2**answers

210 views

### Excel vlookup reference purposely missing shows #N/A - stop it

I have a cell which does a vlookup.
But the table to which it refers is always changing and when the specific value is there is shows fine.
But when the value isn't there it shows #N/A - how can I ...

**-2**

votes

**0**answers

22 views

### Why data is getting copied in the same row?

Found this coding online and tried to use it for one of my workbook. This is not the exact coding as I needed to tweak as per my data.When I click on the button(Macro) 1st time it's correctly moving ...

**1**

vote

**1**answer

22 views

### Calculating percentage change over a range of 5 cells where a different two will be populated on each row

I have 5 columns for 5 consecutive years.
I need to calculate the percentage change between the first value present across the column range and the second value present. The other three columns will ...

**-1**

votes

**1**answer

28 views

### advanced if excel formula

I want to write an excel formula that calculates cell x divided by cell y, but if the resulting value is between 0 and -.3 return a value of 0, but if less than.-.3 then return the inverse square of ...

**1**

vote

**0**answers

12 views

### Excel “Removed Records: Formula from” log file does not identify what was removed

I modified the range of a formula within the spreadsheet's sheet6.xml file using the regular expression change/replace feature of EditPlus, using this regular expression:
Find: (SUM\(J.*:)(S)(.*\))
...