**0**

votes

**0**answers

6 views

### Comparing two strings in two columns in Excel Sheet

Can anybody help me to correct this data? There is a long list of this type of data:
If there are columns that are exactly matched, like in row 5 (Harley- harley) it should return 1 or 'true' in ...

**1**

vote

**2**answers

4k views

### Workbook doesn't find macro

I created a macro in a workbook which is being used by several persons on their own computers. For some of them, it seems to work fine, but for other a message appears that it can't find the macro on ...

**3**

votes

**1**answer

4k views

### Macros in Excel 2010 hangs

I have a spreadsheet with several macros. Generally, when previously using Excel 2007, a user clicks a button and everything works as expected (calculations, some email sending & file I/O). ...

**0**

votes

**0**answers

4 views

### How to stop excel copying adjecent formatting

Excel seems to be determined to copy the format of an adjacent cell. For instance, when I have a cell that has a green background with a number in it, then when entering a number in an adjacent cell ...

**2**

votes

**3**answers

15k views

### Filtering data in excel with embedded pictures

I have a data table with product images that I want to filter depending on who I send the spreadsheet to. The pictures are still visibly stacked on top of each other.
How do I set up my sheet so ...

**0**

votes

**0**answers

9 views

### checking for record duplicates in Microsoft excel

for example if cell a1(surname), b1 (first name) and c1 (salary amount), are all tied up with sumproduct to check for duplicates. I can do this easily but if the value of a1 and b1 occur in a4 and b4 ...

**0**

votes

**1**answer

27 views

### Microsoft excel collaboration [on hold]

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

**3**answers

3k views

### Excel saves a file in .csv but it keeps the columns and the rows as they were in the original sheet

I have a problem converting an Excel sheet in a *.csv file. I've searched all day for solutions, but nothing seems to work.
After I select the sheet and save it as "CSV(Comma delimited)", pressing OK ...

**-2**

votes

**0**answers

15 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

8 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

**2**answers

48 views

### Excel: What can cause manual calculation / F9 to stop recalculating?

What can cause manual calculation/F9 to stop recalculating some cells properly in Excel 2010 ?
I've Googled this problem and ruled out all the explanations I can find:
Calculation settings are ...

**0**

votes

**1**answer

19 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

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

**2**

votes

**2**answers

956 views

### How to remove the tell me what you want to do search box in Ms Office Excel 2016

Is it possible to remove the annoying search bar in Excel 2016?

**0**

votes

**1**answer

12 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

28 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

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

**2**

votes

**3**answers

48k views

### Unable to insert rows or columns in Excel 2013

I'm using Office 2013 on Windows 7. Few times, I have not been able to insert rows / columns in a some of the Excel spreadsheets. I tried the following before searching on the internet.
Use ...

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

**7**

votes

**6**answers

3k views

### How to increment string like AA to AB?

I have strings in Excel like AA or XA.
I need to increment them like this:
For AA in cell A1, it will be AB in cell B1, AC in cell B2 and so on.
For XA in cell A1, it will be XB in cell B1, XC in ...

**0**

votes

**2**answers

24 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

**8**answers

21k views

### Duplicating a row with formulas, without changing cell references

i have a large financial spreadsheet with a ton of formulae. i'd like to duplicate a row such that it retains the same formula and coordinates as the source row (basically duplicate a summary row and ...

**1**

vote

**3**answers

2k views

### Color scale for text values in Excel

I would like to apply color scale on text values. But unfortunately, it works only on numbers!
I’m doing this to easily identify the repeated values sorted by other column.
This image explains the ...

**3**

votes

**4**answers

20k views

### How to find broken links in Excel that can't be broken with 'Break Links'?

I have an Excel workbook that complains about broken links every time I open it:
I've tried using 'Find' to search for:
[.
as suggested in Microsoft's guide. I've also tried searching for ...

**0**

votes

**3**answers

2k views

### Force external link in Excel to break if the file can't be found

I have an Excel spreadsheet that has an external link to another spreadsheet. What I want to happen is if
Main_Spreadsheet.xlsx
Secret_Data.xlsx
When someone opens Main_Spreadsheet.xlsx and they ...

**0**

votes

**0**answers

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

**0**

votes

**1**answer

5k views

### Change numbering language of the Excel context by changing the Windows language

How could we change the numbering language of MS Excel 2010 by changing Windows language
In version 2007 as I can remember we had an option in the advanced options tab that allowed us
to do that with ...

**-1**

votes

**1**answer

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

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

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

**71**

votes

**12**answers

88k views

### Open Excel files in new window

When I have Excel running and I double click an Excel file in Windows explorer, I'd like it to launch in a new window by default so that I can move documents to separate monitors. Is there any way to ...

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

**7**

votes

**4**answers

52k views

### Dynamically reference a Named Table Column (via cell content) in Excel

How do I reference an Excel table column dynamically in Excel 2007?
I want to reference a named column of a named table
and the referenced column will vary with the value of a cell.
I have a table in ...

**1**

vote

**4**answers

37k views

### Compare multiple columns for any two or more cells within the same row having the same content

I need a formula to compare multiple columns for any two or more cells within the same row having the same content. If that is true, then display "TEXT A" (can be anything such as "TRUE"). If all of ...

**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", ...

**0**

votes

**2**answers

171 views

### Why does excel tables break VLOOKUP formulas

I have a worksheet using raw data that Excel does not identify as Tables (ie. plainly putting values in adjacent cells), and on another part of my worksheet, formulas doing lookup in that data, like
...

**73**

votes

**8**answers

87k views

### How do you view the bottom of really tall cells in Excel?

When there are very tall cells in Microsoft Excel, trying to scroll via mouse or even via scrollbar (clicking on "<-" "->" pointers) just jumps below to the next cell, hiding the bottom content of ...

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

**2**

votes

**2**answers

4k views

### Cyrillic export from Excel to CSV

I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.
I use Save As » CSV in order to make a CSV file, but it is not ...

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

**0**

votes

**1**answer

173 views

### How to select only the first max value in excel? [closed]

I need to make an operation on a cell and I choose the one with the maximum value.
If it happens that there are more than one cell with the max value I need to do the operation only to the first one, ...

**6**

votes

**5**answers

10k views

### Increase size limit of data import from csv into Excel

I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...

**72**

votes

**9**answers

147k views

### How do I join two worksheets in Excel as I would in SQL?

I have two worksheets in two different Excel files. They both contain a list of names, id numbers, and associated data. One is a master list that includes general demographic fields, and the other is ...

**0**

votes

**1**answer

32 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

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

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

**1**

vote

**1**answer

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

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

**10**

votes

**3**answers

9k views

### Move open Excel document to separate window

Related (but not the same): Open Excel files in new window
If I've got an instance of Excel with multiple documents open in the same window. Is there a way to "tear off" one of the windows in ...

**-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?