**0**

votes

**1**answer

20 views

### Getting “Application Defined or Object Defined” error '1004"

So I was trying to copy data from different sheet and paste on current and I am getting this error:
"Application Defined or Object Defined" error '1004"
Can someone help me with this ?
Option ...

**0**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**3**answers

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

**0**answers

53 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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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