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)

2
votes
1answer
28 views

Create a linear trend line in Excel graphs with logarithmic scale

I I have an Excel scatter chart with x and y values. I set the logarithmic scale in x-axis and y-axis. When I add a linear trend line to the graph, the line is not linear but appears like a curve. ...
0
votes
0answers
35 views

Update conditional formatting cell references when conditional formatting is applied to new cell

I am applying conditional formatting to cells on my spreadsheet, using the following formula in cell C6: =INDEX('All Time'!$F$2:$F$550,MATCH(INDEX('All Time'!**$A$7**:$A$550,MATCH("*",'All ...
0
votes
0answers
23 views

Macro to copy values to new sheet and prompt user where they want to save

I'm looking to create a macro in Excel 2007 which will do the following: copy the formatting and values from a sheet called 'report', insert this into a new workbook, naming the file with the value ...
1
vote
0answers
26 views

Is that possible to have a Shamsi (persian) Calendar in Windows? What about Microsoft Office

Is there any solution for replacing the current Georgian Calendar of Microsoft Windows with Shamsi (Persian) Calendar? Although, Microsoft Excel and other packages of Microsoft Office must recognize ...
0
votes
3answers
32 views

Excel - how to rank based on number of occurences?

I have an excel sheet with one column with text strings. I would like to transfer it to a two column sheet where each line appears once and its count in the 2nd column. Ordered by descending count ...
0
votes
1answer
29 views

Excel VBA Insert Character Between Number and Letter

I would like some VBA code that would allow me to detect if a string contains any instances of a number followed by a letter and then insert a new character between them. For example: User enters the ...
1
vote
0answers
13 views

Excel table column validation next row

I made a table with first column formatted to DATE. In the first row I entered the date manually. In SECOND column I entered validation of date >= previous date. I copied this table 8 times. In 5 ...
0
votes
0answers
22 views

Auto Updating Month Over Month and Year Over Year formulas

I have a spreadsheet that has several different sheets (Visitors, Buyers, Conversion Rate, GMS). Each sheet has the data on that statistic monthly from 2013 onward. So sheet 1 shows monthly visitors ...
1
vote
2answers
29 views

Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value

I have rows of possible duplicate employee ID #'s, with another column of different values for the same person. I need a single column of unique ID's with the certifications transposed in the same ...
1
vote
2answers
29 views

summing up numbers when criteria match

I have a range of long dates from Sep 2014 till Dec 2018, and for each month I have an amount. I want to sum up the data of each year in one cell. Example: 2014 : sum of all amounts that are in ...
0
votes
1answer
35 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
3
votes
2answers
71 views

Creating folders and sub-folders with a VBA macro

I'm looking to use a spreadsheet I've created to generate folders and sub-folders based on what is in each column. The first column is the top level, the second column the next level down ...
1
vote
1answer
25 views

Keeping Microsoft from auto starting on Mac

Whenever I start up my Mac Mini (running OS Mavericks) or Macbook Air (OS 10.9), I have to wait while Word and Excel automatically load and open. I've tried stopping this from happening via system ...
-3
votes
1answer
28 views

Different rows in to different columns(special case)

I have a excel sheet that contains hundreds of data like this.. Name 1 Name 2 Name 3 Name 4 A Aa Aaa Aaa Name 5 Name 6 Name 7 Name 8 B Bb Bbb Bbbb I need to ...
-2
votes
1answer
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
1answer
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
1answer
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
2answers
23 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
1answer
23 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
0answers
19 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
0answers
24 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
0answers
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
1answer
32 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
1answer
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
1answer
16 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
1answer
24 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
0answers
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
1answer
27 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
2answers
37 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
1answer
25 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
1answer
21 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
0answers
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
1answer
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
1answer
43 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
0answers
16 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
1answer
38 views

Identify data file type [closed]

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
3answers
15 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
2answers
38 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
1answer
32 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
2answers
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
1answer
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
1answer
16 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
2answers
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
1answer
25 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
1answer
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
1answer
40 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
1answer
15 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
0answers
18 views

How to check if cell contains entry from another column?

So basically I have a column(A) with company names and addresses together. I have another sheet with a column(B) with the company names that are members. I want to check if the companies in A are ...
0
votes
2answers
36 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
1answer
23 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 ...