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)

0
votes
1answer
55 views

Find out the number of months between two dates [duplicate]

I need to calculate accumulating leave for personnel. It grows by 1.25 days per month. What formula should I use to add 1.25 per month starting from the date of employment?
0
votes
0answers
23 views

Excel 2007 Conditional Formatting On Formula Not Updating When Cell Updates

I have set the following conditional formatting rules: =$B97=1 Set Format (Custom) ">" @ On cell =$D97 =$B97=2 Set Format (Custom) "> >" @ On cell =$D97 =$B97=3 ...
1
vote
1answer
20 views

Creating a table similar to pivot table

I'm not sure how to explain it, but I hope this example makes it clear. Data: Yes/No | Place1 | Place2 | Place3 ---------------------------------- Yes | Thing1 | Thing2 | Apple No | Apple | ...
1
vote
3answers
39 views

Excel, Average for a specific column within table

Im trying to calculate an average just for one column within a table of values. It is like this: Hi Hello Hey 1 | 2 | 3 1 | 2 | 3 1 | 2 | 3 And I'm trying to get the average for one ...
0
votes
0answers
52 views

How to disable snap/jump scrolling in Excel 2016 for Mac

I'm desparately looking for a way to disable snap-scrolling in Excel 2016 for Mac. Basically as you scroll Excel will continually try to keep the cell you're focused on in the centered. So when you're ...
1
vote
0answers
21 views

How to transpose repeating groups in Excel

How would I transpose repeating rows and columns in Excel. For example how would I transpose the repeating pattern of rows (Tan color) to repeating columns (Purple). Would I need to do this in VBA ...
1
vote
1answer
42 views

Excel : how to put a literal dot into a cell format

Whenever I put a dot character into a custom cell format Excel will interpret it as if I want a decimal separator in that location of the format. The problem being that decimal separator changes with ...
0
votes
1answer
19 views

Search two columns in Microsoft excel 2013 and set the value of a third column with a specific value

I want to search a specific text which is the firstname_lastname e.g John_Smith in worksheetA. WorksheetA has a column firstname and another column lastname. So after knowing which row has the ...
0
votes
1answer
24 views

How do you prevent corruption of shared Excel files?

I have 10 or so Shared Macro Enabled Excel files that about 30-50 users modify multiple times each day. Over time the files get bogged down and bloated from excel thinking users are still using them ...
0
votes
2answers
31 views

Finding #NA values after Vlookup between two excel

We have two sheets for Jan and Aug. Both consist two columns , one for Client name and another one for no of shares they attain. we have to find out client names which exist in jan but not in Aug ...
0
votes
1answer
19 views

Excel on Mac automatically converts all numbers to thousands

I'm on Excel 14 for Macintosh. It automatically converts all numbers to be representative of thousands. I have searched throughout to change a preference or option and cannot find it. Example ...
1
vote
0answers
20 views

Microsoft Excel 2016 Mac: Smooth cell transition

Changing cells in Excel 2016 Mac by clicking arrow keys results in smooth (i.e., painfully slow) transitions. Is there a way to disable this? (Note: distinguish this, I think, from 'smooth ...
0
votes
1answer
24 views

Formatting time s:mm.00 in Excel (Office 2010) and graphing

My son is a competitive swimmer. I would like to make a stacked bar chart using the various time standards for each stroke. The times are listed in m:ss.00 format. I have several problems I need help ...
-1
votes
0answers
21 views

Why doesn't my formula doesn't copy until the end of an Excel table?

When changing the formula in an Excel table it doesn't copy all the way until the end of the column. I copied information from different spreadsheets to create a new one combining information from all ...
3
votes
1answer
73 views

Extract number from complex string if it falls in a given range

I need an Excel formula (or VBA macro) that will allow me to extract a value from a string. The string is a sequence of words, separated by spaces, in a single cell. I want the word (representing a ...
3
votes
1answer
32 views

Excel - VLookup Example

I am writing a simple list of equities for the various two playing card combinations against a certain range of an opponent. My column A is the first card (A, 2, 3, ..., K), the column B is the ...
0
votes
1answer
24 views

VLOOKUP returning N/A because references contain “.” and “ ” in one table, not in other

OK I am trying to vlookup a table but the problem is the references on one table are slightly different to the references on the other table. I can get the VLOOKUP function working, but it is ...
0
votes
0answers
4 views

Is it possible to autofit a resized row with wrap text?

I want to autofit a resized row that is wrap text enabled. It is wrapping the text but it is not autofitting. Is it possible to auto-fit a resized row (without VBA)? I resized the row to 30 pixels ...
0
votes
0answers
25 views

Exteremly Slow Microsoft Excel operation in LENOVO G550 series Laptop; Shall I add more RAM?

I am doing complex Macro operations in Excel 2007/2013 which generates random numbers and does many multiplications/divisions in each cell value. It also copies data to multiple worksheets and text ...
0
votes
1answer
21 views

How to find number ranges (with text input) in Excel

In column A, I have some numbers, formatted as text due to leading zeros: +------+ | A | +------+ | 0001 | | 0002 | | 0003 | | 0012 | | 0013 | | 0015 | | 0017 | | 0019 | | 0020 | +------+ Using ...
-1
votes
0answers
14 views

Vlookup Advance Help - Extract all different values against 1 lookup_value

Well we all know about vlookup using this we can extract specific value against any one But i want something extra in this like like when i use this i get the only first one value against my ...
0
votes
2answers
18 views

Fill cells with a repetitive Date pattern in excel

How would I create a repetitive pattern of "dates" (e.g. 1-Jan-15, 1-Jan-15, 2-Jan-15, 2-Jan-15 .....) Saw this command in one of the posts =ROUND(ROW()/3,0) which I modified to =ROUND(ROW()/2,42005) ...
0
votes
2answers
30 views

VBA macro to interchange columns

Please could you help me in VBA macro to interchange columns for example There are 4 columns Supplier1, Supplier2, Supplier Score1, Supplier Score2 I want to change columns as below Supplier1, ...
1
vote
3answers
43 views

Remove spaces between characters in cell, but only if the space exists between two single characters

To process in 10,000 lines of excel, to remove spaces between characters in cell, but only if the space exists between two single characters. P J A JACKSON AND SONS should become PJA JACKSON AND ...
3
votes
1answer
57 views

INDEX + MATCH function returning wrong values

I have a spreadsheet in Excel 2013 that uses an INDEX and MATCH function to search by an interval time (in I4) to pull values from the corresponding row where it is matched (in column A). It works as ...
0
votes
0answers
18 views

Sorting data by association?

That title may have been misleading, I don't know quite how to put it. I have a set of data where a number stands for a description. It currently looks like this: 10 Blue 11 Green 12 Purple 13 Red 14 ...
1
vote
1answer
34 views

VBA - Create an array of all table names in workbook

My end goal here is to have a button, that when pressed creates a new sheet with a table on it.. that new table should be added to the PivotTable Wizard list. The error being called is error ...
0
votes
2answers
37 views

IF statement with multiple criteria and multiple possible results

I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...
1
vote
0answers
95 views

Excel 2013 opens files slow in Windows 10 (when not in Safe Mode)

This is a problem that has come up on Google and superuser in the past, although the solutions I have found haven't worked for me. If I run Excel 2013, it opens instantly. If I am in Excel and open a ...
0
votes
0answers
7 views

Connecting slicer to mutiple pivot tables

I am trying to use a slicer connecting multiple pivot tables. When I try to connect to the other tables the list is blank. I try to connect to data sources and it shows no other data sources in ...
0
votes
2answers
25 views

Microsoft Excel 2010 the difference between two times in two different cell

Other answers helped but have a problem with the following Start Time 23:56 End Time 0:32 difference is 36 minutes. Start Time 21:53 End Time 22:05 difference is 12 minutes. What formula can I use ...
0
votes
1answer
27 views

Create a List from two columns in Excel

I would like to create a drop down menu using data from two tables. As this is not possible, I am looking at merging these two tables together and then using this merged table to create the dropdown ...
0
votes
1answer
36 views

Is it possible to use an answer from a calculation in the same cell?

Is it possible to use an answer from a calculation in the same cell? Eg Cell A £105 Cell B 0.05 discount Cell C £105*0.05, ans-£105 = £99.75 I understand I could do it in 2 columns, but wanted to ...
0
votes
0answers
22 views

Is it possible to share a hyperlink in en outlook email to a specific excel worksheet?

I have an Excel workbook which I can shared by sending a hyperlink to this file by e-mail. But I do not just want to share the file, but link specifically to a certain worksheet. I know that linking ...
1
vote
1answer
31 views

Grand total of calculated field of pivot table

My pivot table summarizes the total number of items sold and calculates commissions, say: ItemA 15 $150 ItemB 6 $30 ItemC 9 $45 Total 30 $300 I want to calculate commission to salespersons: For ...
0
votes
2answers
34 views

Fill cell with sheet name Microsoft Excel

I have an excel file which has around 100 sheets in it. Each sheet is for a student, and each sheet name is the firstname_lastname e.g Mark_Hope so what I want to do is that in each sheet there are ...
0
votes
0answers
14 views

Numbers or Excel, Sum data in a column depending on date

I hope to Sum Column Y based on data in column A. That is, If A is in (contains) "July", then sum Y. i.e. "What are the totals for July?
0
votes
1answer
12 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
-1
votes
1answer
22 views

How to extract numbers from duplicates and text

I have a set of data as below: 23 23 23 23 23 False False False False False 10 10 10 10 10 False False False False False False 30 30 30 30 30 30 False False ... Which formula can I use to only ...
0
votes
0answers
25 views

Filter Unique values in Columns or Cell Ranges from Multiple Worksheets in an Excel Workbook? [closed]

Excel 2010: Filter Unique values from Columns or Cell Ranges from Multiple Worksheets in a workbook? Essentially, combining data from the 3 cell ranges/ columns in multiple worksheets Then filtering ...
-1
votes
2answers
35 views

Conditionally Remove Duplicates

So I have column A and column C. Both columns have duplicates. However I only want to delete based on the fact that there are duplicates if combined column A and column C have the same values. ...
0
votes
2answers
34 views

Combine Excel tables

I need to combine two excel tables(Table 1 & Table 2) to result as Table 3. New week column will be added every week with new data. The Table 2 could be added to Table 1 or can be combined into a ...
0
votes
0answers
13 views

How to merge Excel PivotTable results with another sheet?

I have an Excel spreadsheet, where I have a PivotTable where the X is Location & Commodity. The Y is Fiscal Year. The cell data is a sum of Commodity cost. The PivotTable is being generated from ...
0
votes
1answer
33 views

How to generate all possibilities of combination for a set of values or range?

Reference to question and answer below, how to generate all possible 3 digit combination of the numbers 0-6 I have similar case (need to generate all possible combinations) but for set of values ...
-2
votes
0answers
23 views

Excel Nested If Function

I want to compare two columns of values and if the one column is at least 85% of the other column , return the first column value if it is not then return the other column value.
0
votes
2answers
25 views

how to generate all possibilities of combination for a set of number or range?

reference to question and answer below, how to generate all possible 3 digit combination of the numbers 0-6 i have similar case (need to generate all possible combinations) but for set of values ...
0
votes
1answer
35 views

Need macro to transfer Word data into Excel

I am very new to VBA and need help ! I have VB macro in Excel that grabs the data from a Word document and imports it into Excel worksheet. Currently, the code in macro has expression that clears the ...
0
votes
1answer
37 views

Group values in Excel

I have 500 rows of items. I need to enter these in an application where I can enter a maximum of six items at once by creating a unique Group ID for these six items. The items in a group share the ...
1
vote
1answer
40 views

showing negative excel axis without label

I have a graph with one negative value. I'd like to be able to Start the graph from the lowest value (in my example, -1) instead of 0 I'd like the major axis to still show every 10 units from 0, so ...
0
votes
2answers
22 views

How do instruct a cell to display a minimum value?

I currently have the following formula in a cell:- =CEILING(E9*0.85, 1.25) I would like the cell containing this formula to display a value no less than 20 but only when the value of E9 causes ...