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
0answers
17 views

Get information from one worksheet and move it to another worksheet [on hold]

Basically, I could do this manually, but I have a lot of information and it would take me a lot of time. I am trying to find the right formula. I have 8 worksheets in Excel. Details Date ...
2
votes
2answers
113 views

Combine Data in Multiple Rows into Single Row

I have a table with information about people (Name, HP No., Home No., Email etc). However, they are in different rows, and not all rows have all information. How do I combine all information about ...
0
votes
1answer
25 views

Date formatting from a derived/computed column

I have a column(A) in excel with data like "20141024X000000". First part before x is a date. In another column(B) I want to format the date to become like "14-Oct-24" What I did was use this function ...
1
vote
0answers
26 views

Percentage increase between two data points - bar chart / Excel

Please forgive me but I simply do not know how to include these arrow lines displaying percentage increase/decrease between two points on a bar chart in excel. I wish to replicate what is showing in ...
0
votes
0answers
17 views

Ideas on how to automate the export of cell values from 300 different excel workbooks

I have 300+ excel workbooks, containing some informaiton. I need to construct a dataset, containing information from each of the workbooks. To clarify, let me give you an example: -WB1.xls contains ...
-1
votes
0answers
16 views

Why is Index and Match Formula showing incorrect value?

I am trying to pull some value from 2 combined column using this array formula. {=INDEX($E$27:$E$35,MATCH(1,(H27=$B$27:$B$35)*(I27=$C$27:$C$35),0))} The problem is the value shown is always ...
0
votes
1answer
24 views

A chart where the line between points does not interpolate

I have an Excel spreadsheet showing the balance of a bank account over time. Each data-point is the balance of the account immediately after a transaction (so there might be several per day, with the ...
0
votes
0answers
11 views

Highlight Track Changes

customize excel 2010 highlight track changes The macro above thread doesn't have the option to undo. How to revise this?
0
votes
0answers
20 views

Years on the X-axis on a Gantt chart created in Excel 2010

I'm trying to create a gantt chart in Excel 2010 but I have problems with the x-axis. The chart shall show when 6 different steam engines were in service, at the workshop for revision between ...
0
votes
1answer
15 views

Validating the “results” of the scrollbar in Excel

I have searched high and low, but found nowhere something that could help me. Here is my problem: I need to set a range of dates with two sliders. One slider sets the starting date of the examined ...
1
vote
1answer
76 views

How to draw an excel chart from two columns?

Consider the following table: 1970 - 4705 1980 - 4771 1990 - 4998 2000 - 5181 2001 - 5195 2002 - 5205 The left number is x, the right is f(x). (The numbers are in separate excel columns) I need to ...
-1
votes
0answers
17 views

VBA macro doesn't work after reopening the Excel file

I have a sheet in my Excel where I made some "groups". I want to protect the sheet and still be able to open/close the groups (+/-). So therefore I have inserted this VBA code: Private Sub ...
0
votes
0answers
22 views

I am trying to make a pie chart that uses the most current quarter results and does not use previous quarter results

I would like to be able to display the most current quarter result for "Compliant, Non-Compliant, and Partial." That way I can feed the numbers into a pie chart for the most current status of each ...
0
votes
1answer
13 views

can I create a PDF form that will export the questions and answers to an excel sheet

I want to create a form for my office that asks new clients several questions. I then want to export the filled out form to an existing excel sheet that has all of my clients' names and contact info ...
0
votes
0answers
35 views

Convert Excel To Text Using Office and Command line

Is there any command line option to pass to Office's Excel so it can convert .xlsx files into .txt files without showing Excel's GUI?
0
votes
1answer
40 views

Is there a way to autofill cells in Excel 2013 with keyboard shortcuts?

So very shortly, I want a shortcut equivalent to dragging the little handle in the right-bottom in a cell-selection portion in Excel 2013 (for Windows). There is many similar questions on the site, ...
1
vote
1answer
22 views

Excel file printing forcing margins

When I set my margins all to 0cm, and I have a portrait oriented page, the first top left cell in excel is like 2-3 mm from the top left corner of the page which is perfectly fine. However when I turn ...
1
vote
1answer
28 views

Macro: Insert a new row above a cell containing a different numbers

I have an excel with two columns. Column A contains numbers and column B contains text data. Numbers are continuous like 1 2 3 with several blank cells between them as shown below. For example: 1 ...
2
votes
2answers
33 views

Excel formula to populate from one column only if another is empty?

I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not ...
1
vote
1answer
27 views

Excel links on rota [closed]

I have to do a rota that is currently done on two spreadsheets. One shows the member of staff where they are working the other tells us that where they are working has cover by a member of staff. ...
1
vote
1answer
27 views

How to export full data from excel as a csv using macro?

I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data? Here's my code: Sub CSVFile() Dim My_filenumber As Integer Dim ...
0
votes
1answer
23 views

Excel 2013 Display Values From A Table As Column Headers

I have a list of employee names in a one column table. I would like the values from the table to display dynamically as column headings on a single row in a different table.
0
votes
0answers
8 views

How do I configure the plot area to display my entire series of data?

The simplest way to describe my question is to view this image: When I click on the series (i.e. the bars, you can see that the "shadows" of the non displayed bars are displayed outside the plot ...
0
votes
1answer
19 views

Hyperlinks in Cell Not Emplying Full Use of HTML

The following is on Excel 2013. I have a spreadsheet that, through a VBA macro, takes a numerical input from a cell and appends it to a hyperlink to a PDF document on a website immediately after ...
0
votes
0answers
46 views

Microsoft Excel Starter 2010

I have multiple columns/tables of data that I want to use in what I think would be an if/then formula BUT I have more than 2 options ie. I want to be able to type in a number (62111) and have it auto ...
0
votes
0answers
23 views

Compatibility between Mac and PC Microsoft Office database

In my new job, we used a mailing service (tralix), and I have to upload a database, my boss had taught me hers way, (I'm working on Mac): I have to go to PC and open excel (she gave me the DB), and ...
0
votes
0answers
24 views

Formula entered in a cell on sheet A referencing sheet B populates in sheet B

I'm seeing an error when entering formulae which reference another worksheet. This typically only happens with large workbooks. Example: I have two sheets, DataSheet and OutputSheet. On OutputSheet I ...
0
votes
2answers
26 views

Most Current Result

I have a spreadsheet that reports 3 number results by quarter. I would like to create a pie chart that will only use the most current information. For example it will use quarter 1 data if no other ...
0
votes
3answers
62 views

Excel VBA or Formula to convert text to Date with Time type

I have a quite a number of data where its date/timestamp has been imported into excel as text. Excel does not really recognize it as date with time. e.g. 25.08.2011 16:17:59 (mm.dd.yyyy hh:mm:ss) ...
0
votes
0answers
14 views

Excel/Google Sheets: NETWORKDAYS() over a filtered range

I'm currently cleaning up a Google Sheet, which due to increasing size needs to be condensed a bit. I'm currently working on removing 14 columns with basically the same formula, but am having problems ...
0
votes
2answers
27 views

How i can calculate row in formula? making a link to specific cell

For example: Link to Cell A1 is "=A1" A - column name 1 - row number Can I calculate row number in formulas to make specific links? Something like =A{some calculations} so =A{1+1} will be a link for ...
0
votes
2answers
54 views

Excel: Output more (calculated) lines based on a single criteria

I want to split a single line of information when it meets certain criteria, into several. In the attached example, I'd like to split the lines with a number of 2 or more in the "Records" column, ...
0
votes
1answer
34 views

Track username and date who opened an Excel sheet

I'm using VBA to display a welcome message with the username. Additionally I want to keep track of the username (taken from environment variables), date and time in one of the sheets. For example: ...
1
vote
0answers
34 views

Text to copy cells with formatting into Excel

I am looking for a way to copy-paste text into Excel, which Excel will recognize as formatted (ie, styled or colored, etc) cells. On the one hand, Excel recognizes tab-delimited text pasted from the ...
1
vote
1answer
42 views

How do I delete " in every cell?

In my spreadsheet there are descriptions that use ". For example 3" plates I need to delete the " in all cells that it's in.
1
vote
1answer
44 views

EXCEL - EXTRACTING Data From Multiple Worksheets where the layout is varied

I have a spreadsheet which contains Bill of material data and Labor costs for manufactured parts. The first worksheet contains the master part numbers for the assemblies Each Worksheet represents the ...
0
votes
1answer
15 views

Refer to another worksheet that has increment in cell number

I have a worksheet (let me call it WorksheetA) that each row has a different information. Then, I want to refer this information per row on my other worksheet (WorksheetB). To explain further, ...
0
votes
1answer
31 views

MS Excel | how-to SUM combination of array/absolutevalue

When using Microsoft Excel you can use the SUM function to add multiple cells, like so: =SUM(A1:B7) Let's say Row-A is an array set of numbers per cell (numbers totalled by formula) and Row-B is ...
0
votes
0answers
15 views

can I save a view of multiple worksheets in excel 2013

The image below is a view of two (2) worksheets in the same excel 2013 workbook. I made it using View--> View Side by Side, and the sizing each sheet, etc. Is is possible to save this view so that ...
0
votes
2answers
38 views

Get Last 5 Non-Zero Values in a Row

I have a large spreadsheet with many rows where the data can have zeros and positive/negative values but all numeric values. I would like to write a formula (or five formulas if needed) to tell me ...
0
votes
1answer
15 views

Excel Chart Object without source data in Word going back to Excel

I have an Excel object chart in word. The chart is a line graph. The data is there because when I mouse over the line, I see each individual x and y value. However, the word file chart was sent to me. ...
0
votes
1answer
30 views

Excel 2013: I need to go to last row in a table, go up 48 rows, then sum every 12th row

I know that I can use an offset/counta to get to the bottom, then go up a certain amount of rows. But if I use this with a sum, for example: =SUM(OFFSET(M1,COUNTA(M:M)-47,0,12)) I will get a sum of ...
0
votes
0answers
18 views

VBA code to paste value to an indexed position from a match on different sheet

I am struggling for days to make this excel formula work from a command button. =IF(‘Machine Status’!E$28=(INDEX('Import Pool'!$A:$H,MATCH(‘Machine Status’!$B$23,'Import Pool'!$G:$G,1),2)) then cut ...
-2
votes
0answers
17 views

Excel 2003 workbook and sheet damaged [closed]

I am facing problem with an excel workbook. Whenever am opening my data workbook am getting the following error: This file is not in a recognizable format Any suggestions please!
0
votes
1answer
33 views

How do I get a hyperlink open only one internet explorer window

How do I get a hyperlink open only one Internet Explorer window? It keeps opening the same thing from the link but in two IE windows.
0
votes
1answer
30 views

excel copy past repeat macro

At the moment I am working on a research project for my university in excel. Now I have a certain range BF1:DJ293 which has to be copied and past for 238 times to the right. So this range has to be ...
-2
votes
0answers
27 views

Add a “Submit” button to an excel sheet

I need to have this functionality in excel, wherein on clicking on "Submit" button in the sheet selects all text from a column and email them to a group of users. For e.g--Column A has the following ...
0
votes
1answer
34 views

Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...
0
votes
0answers
19 views

Excel - How to get list text to display [duplicate]

How do I write this excel cell formula? So I have a RowA which has a list of words and they each correspond to RowB with an "!" or an "X". Row A : This is a list of words Row B ...
0
votes
1answer
30 views

Select text to display based on matching a symbol in another row

How do I write this excel cell formula? In Row 1 is a list of words and they each correspond to an "!" or an "X" in Row 2. Only one word is given an "!". [A] [B] [C] [D] [E] ...