**0**

votes

**1**answer

23 views

### Excel, how to subtract time to span before midnight

I am trying to subtract hours to a time that is close to midnight, but excel is outputting all hash (#) symbols complaining of the operation.
Adding time is easy and possible, as described by this ...

**0**

votes

**0**answers

14 views

### Excel - Updating a .xlsb file when saving a .xlsx file

I work on Excel for Mac 2011.
Sometimes, for no apparent reason, I can't open one file I saved in .xlsx. I did some research and found it was a bug. The only workaround I found is to save the file ...

**0**

votes

**1**answer

17 views

### Tableau workbook [closed]

I'm new to Tableau, and I don't know how to add more than one dashboard in my visualization. How can I present all my visualizations and not dashboard by dashboard?
I need help with this issue.
...

**0**

votes

**1**answer

21 views

### How do I use custom formatting to change number from ########### to #####.##.##.## in Excel?

I have a very large list of numbers that range in size from 9-17 characters. I need to add periods to make them compatible with a specific program.
Example:
1000409180201 --> 10004.09.18.02.01
Is ...

**2**

votes

**1**answer

47 views

### How to Make a PivotTable out of “hierarchical” Excel spreadsheet data

I would like to create a PivotTable out of "hierarchical" data contained in an Excel 2010 worksheet. The data is hierarchical in the sense of a parent/child relationship in a database where, ...

**2**

votes

**2**answers

20 views

### Same time value in two different cells, different decimal value, no match possible

I'm trying a index match function on two different cells in which is the time value 08:30:00. I never got a match and after long searching I found that there's a minuscule difference in value between ...

**2**

votes

**1**answer

36 views

### Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple.
Suppose the following example:
There are two tables, one containing animals, and the other one ...

**-1**

votes

**1**answer

54 views

### Excel Password Recovery [duplicate]

I have forgotten my Excel password the file was in Win 2003 version. I tried many tools for recovering back the password but none of them helped me. Please help me…

**1**

vote

**1**answer

26 views

### How do I sort and merge data (in Excel) with hexadecimal codes?

I take attendance in large, lecture classes. Each student inputs a vote on a multiple-choice question with a "clicker" (a hand-held, remote control device), and each clicker has a 6-digit, ...

**-4**

votes

**1**answer

53 views

### VBA for “IF formula” with multiple results in a single cell [closed]

How can I convert this to VBA? Using this formula, it cover 6 rows only and the formula is already too long. My report has 600 rows.
=IF(AND('Risk & Issue Log'!$K$2=$D5,'Risk & Issue ...

**-2**

votes

**0**answers

27 views

### Windows 7 Pro, Office 2010, Excel bug in VLOOKUP and INDEX

These two lookup functions return a false 0 value when
The cell being looked up exists
but is EMPTY - i.e. if the cell is displayed in VBA, it is shown as "EMPTY", not blank or zero or a string
...

**-1**

votes

**1**answer

35 views

### Excel function to return values in Array1 but not in Array2

Array1 = {1,2,3}
Array2 = {3,4,5}
What function will take these two arrays (as ranges on the worksheet) and return the values that appear in Array1 but not in Array2? In my example, the desired ...

**0**

votes

**1**answer

34 views

### Data from different months into one chart, colored differently?

I have three sheets with pivot tables in one Excel document.
These table different slightly from month to month:
table 1 - Jan
bike 100
scooter 20
table 2 - Feb
bike 20
skateboard 2
...

**0**

votes

**1**answer

46 views

### Excel: How to clear all renamed PivotTable labels

When using PivotTables in Excel, it's often useful to overtype certain PivotTable labels with new names.
If you have a long list of items you've relabelled, it can be easy to lose track of what the ...

**0**

votes

**2**answers

19 views

### Cells apears blank but cannot be replaced

I try to replace blank cells by Ctrl+F function, however, there is one cell that cannot be replaced, although it appears empty. But when I use data filter, it is shown as "blanks".
Could anyone ...

**0**

votes

**2**answers

34 views

### MS Excel using multidimensional lookup

Hi am trying to assign a value given that if I have a some value that matches column 1, it will search try to check if for that specific row my my product variable is lesser than specified.
So let's ...

**0**

votes

**1**answer

30 views

### What function to use in Excel?

Working on an Excel project and can't figure out what forumula to use. Any help would be awesome!
B39 has the transportation costs for 2013. C39-F39 have transportation costs for 2014-2017. C20-F20 ...

**0**

votes

**0**answers

24 views

### Reduced Row Echelon Form in Excel

I was wondering if there was a way I could enter some matrix in excel like ...
1 -1 -1 0
15 5 0 -5
0 -5 10 8
With each number in a cell, and then have excel transform this matrix into reduced ...

**0**

votes

**2**answers

22 views

### Referencing text from one cell into an equation in Excel

I have text in a cell (A1) that is also the name of a worksheet within my workbook. How do I go about referencing a specific cell on that sheet? I want it to look like the formula below without having ...

**0**

votes

**1**answer

22 views

### How can I visualize resource demand in an Excel diagramm?

I have a table that contains a list of projects.
Columns include project start date, and the efforts for different platforms needed for that project. So for example projects starts 1st of april, and ...

**0**

votes

**1**answer

26 views

### Grab data in excel from an excel that will be downloaded tomorrow

I have set up a way to automatically download my Google webmaster tool data every day. Now, I have a main excel sheet which holds all that data, that I normally update manually. However, I'd like to ...

**1**

vote

**1**answer

50 views

### Excel How to make Text Qualifier editable or add a new entry in the existing list?

I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote.
Example:
"col1","col2","col3"
...

**0**

votes

**1**answer

28 views

### Nesting the IF Function in Excel when there may be #Value! errors in the target cell

I'm trying to get some help to change a formula:
=IF(S4>8000,3,IF(S4>6000,2,IF(S4>4000,1,IF(S4<4000,0))))
So that it returns a value of 1.5 if the target cell contains an error value. ...

**0**

votes

**1**answer

15 views

### Excel: Stop watch format without seconds

How to achieve a cell format like 26:30 (meaning 26 hours, 30 minutes), without seconds? Such format is not predefined. There is only 26:30:00 or 26:30,0 in the program settings available.

**1**

vote

**2**answers

34 views

### MS Excel Column content replication across two sheets

Microsoft Excel functional Question
How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...

**1**

vote

**2**answers

23 views

### What's the best way to cut out all text before or after a matching string with excel or open office?

I have a column of naughty data, that needs to be standardized. Its a single column, so I'll just include a snippet of it it here:
pop_density_2010
7002854600000000000854.6/sq mi (329.97/km2)
...

**2**

votes

**1**answer

26 views

### Counting Text Cells

I need an efficient way to count the number of cells in a column containing text. The formula:
=COUNTA(A:A)
gives a result, but that result includes cells containing formulas returning "", which I ...

**1**

vote

**1**answer

27 views

### How can I summarize cells based on date in other cell?

I have one Excel sheet with columns "project name", "project date", and "effort estimation".
On a second sheet I want to summarize those projects according to the months of the year.
So I have ...

**0**

votes

**2**answers

57 views

### Can MS Excel use non-printable characters as field separators in CSV files? If so, how?

I've just discovered that many of the character encodings have non-printable characters designed to separate different pieces of information, e.g., ASCII character 31 is the "unit separator". It ...

**1**

vote

**3**answers

38 views

### Excel combine rows dollar amount with matching row values?

I've ran into a problem with Excel, I have the below table
Basically, I'm trying to figure out how to make all rows that have the same product key combine, except calculating the dollar amount for ...

**-1**

votes

**1**answer

39 views

### Calculating Dates Backwards in Excel

I am trying to calculate 6 Fridays before a certain date, as well as 4 Fridays before a certain date, in order to establish deadlines for several departmental responsibilities. I would like the dates ...

**0**

votes

**1**answer

16 views

### How do I copy data to another sheet over multiple columns?

I have a 2 sheet Excel book. The first sheet has a number of columns,filled with data including 2 columns with peoples names (surnames and Christian names).
The second sheet has 6 columns in which I ...

**0**

votes

**0**answers

32 views

### Conditioning Format

I have two worksheets in one workbook. I have two columns of numbers and texts in the first worksheet that I want to duplicate to the second worksheet if there is a dollar value in a cell on the ...

**0**

votes

**3**answers

41 views

### How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...

**0**

votes

**1**answer

36 views

### Using Dynamic Repeating Formulas in Excel Templates

I have an Excel merge template that compares Actions to Results. It is used by many different sales people. For that reason, the length of the spreadsheet can vary. The users have limited Excel ...

**0**

votes

**3**answers

39 views

### In Excel replacing a column with another column

I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...

**0**

votes

**2**answers

16 views

### Combine two excel documents with imported data and pivot tables

I have two excel documents. Each has a sheet with imported data from web and a sheet that contains a pivot table based on the imported data and chart summarizing that pivot table.
I want to combine ...

**0**

votes

**2**answers

27 views

### How to highlight strings that match pattern in Excel?

I have a large set of data that needs to have some visual formatting cues added for visual review. Essentially the particular matches are phone numbers that have to be matched and when found the row ...

**1**

vote

**1**answer

46 views

### Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...

**0**

votes

**1**answer

52 views

### How to delete entire row when A1:A100000 columns are duplicated

I have to filter quite big data (102858 rows, 9 columns).
The idea is that between these rows (URL addresses) are a lot of duplicates. A1:A102000 contains URL addresses with and without comments. For ...

**-2**

votes

**1**answer

36 views

### How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging:
Date
Running (minutes)
Pushups
Pullups
Crunches
and the rest of my workout entries.
I insert my achievements each day.
How can I script Excel to ...

**0**

votes

**2**answers

31 views

### How do I make a button to add new fields in Excel?

I have a formula which uses a constant. Every time I copy and paste the cells for a new day, I want the constant to update to the new one.
I was thinking I could create a button to copy the fields ...

**0**

votes

**2**answers

36 views

### Formula update no longer working

I have the same formula update problem as others posted on this site.
I have a formula =SUM(B1+B20). I'm trying to enter dollar amount in B1 and updating the dollar amount in B20, thus increasing ...

**0**

votes

**1**answer

22 views

### Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...

**0**

votes

**1**answer

12 views

### Fixing numeric cell in a formula in excel on a Mac

I would like to use repeat a formula with some constants noted in an assumption table how do I do so in Excel on a Mac. In Excel on a non Apple device the formula would be something like this ...

**0**

votes

**3**answers

57 views

### Excel documents will open excel with blank window

When opening any excel document it will only bring up the excel window. To open the document I will have to goto file -> open.
I am using Office 2013 on windows 7 64bit
Only started happening the ...

**1**

vote

**0**answers

40 views

### Office 2013 can't open office 2010 protected file,vice versa

I couldn't achieve to produce an interchangeable protected file between Excel 2013 and Excel 2010.
Excel 2010 can't open 2013s protected one and 2013 can't open 2010s protected one.
I think their ...

**0**

votes

**3**answers

35 views

### One Excel file, multiple editing users, live updates

I have an automated program which is working on Excel workbooks. When someone opens the workbook currently being processed, they will get a read-only message. If multiple users/programs try to open a ...

**0**

votes

**2**answers

28 views

### How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?

How do I limit Entry in a range of cells to be numeric (whole #) max length 9 chracters, no leading zeros and no duplicates?
I also want to limit another range of cells to maximum 24 alpha and "-" ...

**0**

votes

**1**answer

13 views

### Excel leaving formula when selecting another sheet

I am attempting to reference a range in another workbook in a vlookup. I type "=vlookup(a1," and then go to the other workbook to select the range, but alas, I am no longer in the vlookup formula. I ...