**-2**

votes

**1**answer

30 views

### Two lists of same figures showing different totals

Have two columns of the same numbers like for like but when you add one column up manually and the other auto sum and using sum function - it gives a different figure. Can anyone advise as to what ...

**1**

vote

**1**answer

11 views

### Excel for Mac - references in formula toolbar

My formula toolbar displays wrong - instead of for example showing in the cell where the formula is entered (A1 in this case ) =+B1+C1 it is almost like it is directing - it shows =+R1+R2. So ...

**0**

votes

**1**answer

26 views

### Finding most repeated names

I have multiple lists ranking people. I have put them in an excel spreadsheet, each list occupying 1 column
A=washington Post
B=Yahoo
C=Fox
D=NFL.com
These lists are ranking the same individuals, ...

**0**

votes

**2**answers

20 views

### Subtract a value from previous cell with sum and offset function

In Excel, I have a column with different values.
In this column, I want to subtract the value in A1 from the value in A2, the value in A3 from A4 and so on. I then want the result to show in the B ...

**0**

votes

**1**answer

21 views

### Excel: how to link cell from one sheet to another

could you please, help me?
i would like to find out how to do this:
i have a sheet 1: with columns: number, name, color.
i would like on sheet 2 to have 3 cells, where after entering the number, two ...

**1**

vote

**0**answers

12 views

### run-time error 1004 Application Defined or object-define error

I have this macro that I wrote:
Dim lastColumn As Long
lastColumns = wkbWorkbook2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'this is the highlighted part in debug
SourceRange.Copy
...

**1**

vote

**0**answers

17 views

### MS Excel 2013 Basic Help, While Offline, Not Responding

Until about a week ago I could get basic help in Excel 2013. I could search for something like "text functions" and got links to those pages. Now I get no response at all after pressing enter or the ...

**0**

votes

**0**answers

8 views

### How to enable excel-style table headers in Numbers in Mac?

I'm used to using excel for wading through large data sets using the "table headers" feature, which looks like this:
How to do something similar on a mac using iWork's Numbers?

**0**

votes

**1**answer

25 views

### Excel 2010 vlookup formula - Using variable table array as input

I been trying to find out if its possible to automatically expand the table_array on this VLOOKUP formula:
=VLOOKUP(B2,Sheet2!$F$4:$G$965,2,FALSE)
I'm calling the values from Sheet2 to add into a ...

**0**

votes

**1**answer

20 views

### Get data from another Excel file

I have an Excel spreadsheet that contains a list of usernames
Each user will have the following code. I just need to find a way to substitute First.Last with the names in the Excel spreadsheet. There ...

**0**

votes

**1**answer

14 views

### EXCEL Sum amount based on matching order numbers in another column

I am working on a spreadsheet to track our general ledger account for inventory in transit. There is a debit to the account when the order is shipped and a credit when it is received. Column C is ...

**1**

vote

**1**answer

23 views

### How to omit returning the rows for “false” values

I have a worksheet with multiple tabs. The first tab is the master sheet and columns A-G contain identifying data. In the second tab I have created a formula to return the value in column A of the ...

**0**

votes

**0**answers

29 views

### If Blank is Greater than 10% of Blank - Need Formula

I'm having trouble figuring out a formula. I need to find out if the number in Cell B is greater than 10% of the number in cell A. If it is, I want Cell C to say Yes.

**1**

vote

**1**answer

20 views

### Excel Error Bars From Pivot Table

When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...

**-1**

votes

**2**answers

33 views

### Excel Macro Sum of a Row

Sum of row, stop when the first result is positive. The rest of the row values will be converted/replaced with 0, and the last with positive result will have the final sum.
Eg.
Row A1:F1 = -2, -3, ...

**-1**

votes

**1**answer

24 views

### Excel: Averaging Sensor Data by Time Stamp

I have a device that collects temperature measurements from several sensors at discreet time intervals. This data is dumped into a .csv file with each row formatted as: [time] [sensor name] ...

**0**

votes

**1**answer

17 views

### How can I use COUNTIF and TODAY functions to identify work deadlines in multiple worksheets?

I've been playing with our spreadsheets at work and have been able to create a basic formula that will identify when there is a deadline on today's date that needs completing. The issue I now have ...

**-1**

votes

**0**answers

19 views

### Find next largest value that is closest in time

I have a table with the daily change in the price of Brent. I would like to be able to find out the next largest value that is closest in time. I have tried sorting by two columns but it doesn't work.
...

**0**

votes

**1**answer

19 views

### Merging two spreadsheets using record numbers in Microsoft Excel 2013

I have two spreadsheets, one that would be considered the header and another with the details for the headers. What I need to do is merge the two spreadsheets so that the rows show the header then ...

**1**

vote

**1**answer

41 views

### Excel One cell to many formula (I realize this may not be possible)

First of all I want to start by saying I know this is either extremely difficult or impossible.
I have data (from wikipedia, on any airport in the airlines and destinations list), in one column is ...

**0**

votes

**0**answers

14 views

### Opening Numerous Closed Workbooks into One Workbook with multiple tabs/worksheets for each closed worksheet

I have a folder with 20 worksheets each worksheet conatins a scorecards which is (protected/ no password) and not in your typical table format. I want to have a macro to open all 20 of these ...

**0**

votes

**1**answer

37 views

### Identify data file type [on hold]

I have a huge 1.9 GB data file without extension I need to open and get some data from. The problem is this data file is extension-less and I need to know what extension it should be and what software ...

**0**

votes

**3**answers

13 views

### Separating address and phone number into two cells in Microsoft Excel

So, I have many cells that have an address and a phone number in this format
78 North Oak Street Philadelphia PA 17545 610-634-2452
And I want to remove the phone number from this cell and place it ...

**0**

votes

**2**answers

34 views

### WHY are my formulas suddenly not calculating on Excel?

I understand how to fix the issue (switch calculating option from manual to automatic) but I am curious as to WHY it went to manual. Could it be some kind of update? I have been using these ...

**0**

votes

**1**answer

30 views

### Insert new rows and autofill with formula

I am trying to insert new rows if a particular condition is met. I want to drag the formula from the last row to the inserted row, but I am getting an error doing so. Below is my code:
For i = 1 ...

**1**

vote

**2**answers

15 views

### I need to match multiple columns in Excel

I'm having a little bit of trouble figuring out how to solve the following problem. Any help is appreciated! Thanks in advance.
I have 4 columns (A through D) with data that looks like this
A B ...

**0**

votes

**1**answer

18 views

### Need to select every 4th cell in a given Column ( Column E)

I have over 1200 cells in column E.
This was originally a quiz with 4 options, so for each question there are 4 answers now. I need to select every 4th cell, then every 4th starting from the second ...

**0**

votes

**1**answer

13 views

### Extracting information in Excel spreadsheet between specified date ranges

I have a master spreadsheet of data that includes the following fields: date, name of worker, amount paid. The spreadsheet is sorted by date. It looks something like this:
01/01/2014 ... John ... $25
...

**0**

votes

**2**answers

17 views

### Excel Formula Edit to Autofill

I've got an Excel spreadsheet that I'm working on, and I'm stuck with this problem.
This is the current formula for one of the cells:
=CONCATENATE($A$32,"",$B$32,"",$C$32,"",$D$45)
All the data ...

**0**

votes

**1**answer

19 views

### Use an user defined function for data validation

I created a named range which is the result of a user definer function.
Let say my rage is named List and has three items, if I select three cells and enter =List and press Ctrl+Shift+Enter, I get ...

**0**

votes

**1**answer

21 views

### How to check for duplicates among separate excel files

I have multiple (~20) Excel files and I want to check if there is duplicate data (e.g. name). Is there a way I can do this without going through every name of each file? Thanks!

**0**

votes

**1**answer

36 views

### Excel filtering multiple columns with common header and common criteria

I have made a Book Archive in Excel 2013 that has the data sorted like this.
Book's Owner ¦ Book Cover ¦ Book Name ¦ Author ¦ Edition ¦ Language ¦ Topic ¦ Index
Since those are ...

**0**

votes

**1**answer

14 views

### Microsoft Excel - How do I total the values when a specified item is picked from a drop down list?

I am trying to create a stock control sheet where 3 different teams use the same stock. I have created a drop down list with each team name and used a formula to work out remaining stock, what i ...

**0**

votes

**0**answers

12 views

### How to check if cell contains entry from another column?

So basically I have a column(A) with company names and their adress together. I have another sheet with a column(B) with the company names that are members. I wanna check if the companies in A are ...

**0**

votes

**2**answers

31 views

### How to automatically select a non-consecutive range of rows/columns

I have an Excel document in which I want to select a few hundred rows (not necessarily consecutive), in order to then copy them into another document (which will incidentally serve as a source ...

**1**

vote

**1**answer

22 views

### How to switch the “input field” between “formula mode” to “numerical mode”?

In the below link, I have made a simple example where A1=1, A2=2 and A3=3 and then at A5 the formula "=A1+A2+A3" is written.
What I now wonder, is there any special keyboard shortcut or icon-shortcut ...

**0**

votes

**1**answer

30 views

### How to display the Last value in another Cell

I use this formula in E5 to E25
=IF((C9=""),(""),IF((D9=""),(""),E8-C9+D9))
Now I want to display last value of E in G3

**0**

votes

**1**answer

36 views

### Excel: Count visible cells in table with specific value

I have a task tracker in Excel, formatted as a table so I can filter it.
Column A in my table tracks priority (table is filtered based on status).
How can I count how many VISIBLE lines are set to ...

**0**

votes

**0**answers

9 views

### How to format the number category in chart tags?

Hello fellow Excel users:
I have 3 desktops at home. One has Excel 2007, other one Excel 2010, and the last one Excel 2013.
As a heavy Excel user, I prefer to have 3 different versions in order to ...

**0**

votes

**1**answer

21 views

### Why won't this Excel autoformat work: =“$G5<max(I5:AB5)”

I want to make the cell change color when any one of a range of cells is greater than its valve. This seems like pretty simple code to me, but when I test it out, the cell doesn't change color. It ...

**0**

votes

**2**answers

26 views

### Excel: Random select within table that meets two criteria

Here is an example of my data:
Name: Office: Years:
John Smith Canada 1
Bob Smith Canada 1
Jake Smith Canada 1
Sarah Smith Canada 1
On another sheet I want ...

**3**

votes

**2**answers

27 views

### How to delete a certain string from every cell in Microsoft Excel

If I have four cells like this:
hello greg
hello nick
hello eric
hello jenny
and I wanted to remove the "hello" from every cell (without going through manually, of course) to get this:
greg
nick
...

**0**

votes

**1**answer

20 views

### Generating Joint Density Function in Excel

Is it possible to have Excel calculate a joint density function based on two sets of descriptive statistics generated by the Data Analysis tool? To explain further, suppose I have two means a and b ...

**-1**

votes

**0**answers

16 views

### Excel 2010: file is corrupted [duplicate]

error: Excel cannot open the file in .xlsx
file might be corrupted or file format or extension is not valid
please help me with this error
i have tried unzip, repair,rename & recovery tool
but ...

**-2**

votes

**1**answer

32 views

### sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...

**1**

vote

**1**answer

27 views

### Adjacent bar charts with different scalings

I have this chart created in Excel 2013:
using this data:
Last 4 Weeks Last 12 Months
No. of Accounts 36 186
Net Revenue 149,562 ...

**0**

votes

**1**answer

24 views

### Get result of formula as text

I have an Excel doc which populates a matrix using formula, for example;
| A | B | C
1|=1+2 |=2+2 |
2| | |=4-1
would display as;
| A | B | C
1|3 |4 |
2| ...

**1**

vote

**2**answers

23 views

### Need to add missing iteration id numbers to a series in text or excel. How to get this done without coding?

I have a text, csv or excel file that looks like
||--ID-----||--Name--||--Date of birth--||
1 Jo 1/1/11
32 Mo 2/2/12
3382 Ro 3/3/10
...

**1**

vote

**1**answer

19 views

### How to return the text left of line break

I have a Excel sheet, which contains a cell with this content:
Text1: "abc" linebreak1
....
Text31: "mno" linebreak31
Text 32: ... linebreak32
...
Text50: "xyz" linebreak50
No I will ...

**2**

votes

**0**answers

27 views

### Shortcut to move to next new content (Excel)

I'd like to know if there is a shortcut to move to and select the last cell in a row or coumn with the same content as the current cell. I.e. ctrl + arrow moves to the edge of the data array, but I'd ...