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
2answers
40 views

Excel - What's the best conditional formula when there are lots of conditions?

In Column A on my data set there are group identification numbers. They are integers ranging from 0 to 30. In Column B is my data. The groups form 10 cohorts, and the cohorts don't map onto the ...
1
vote
1answer
41 views

Insert Filename Headers into Numerous XLSX files

I'm very new to the world of VBA, but I need a VBA script to insert the filename as a footer into Excel. Ideally, I would like to insert the first 7 characters of the filename into the footer of each ...
0
votes
1answer
25 views

Add sum for records with duplicate titles

I have a spreadsheet with quantities that I needed added up for school names that are identical. Not all school names are identical and need to be added. My data is 3000 rows long, below is a ...
0
votes
1answer
28 views

Excel - creating a graph based on single column results

I'm using a mac with office 2011 I have a gender conlumn like so: gender ------ male male male male female male male male male female and would like to get a graph that will show 20% females, ...
1
vote
2answers
29 views

Appending Group Labels to Discrete Values in Excel

Is there a way in Excel to, after providing a list of groups and a column of discrete values, map a group label to each discrete value? How can I tell Excel to essentially check which group the value ...
3
votes
0answers
70 views

Excel VBA SQL Query Handles Error

I am a beginner with VBA, but try. I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from ...
0
votes
1answer
49 views

How to keep Excel line graph from incorporating dates that are not in my range

I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only ...
-4
votes
1answer
35 views

Need formula for basic IF statement

I am writing a basic scoring program for racing event. I need the excel function basically to make it as following pseudocode. =If cell B1 =1, then cell C1=5
0
votes
1answer
22 views

Compare to column in excel and return a value from corresponding third column to a new column

for example i have 3 column: I whant the result in a new column as: by comparing C with A return B
-1
votes
2answers
41 views

formula to work percentage [closed]

I am trying to find a formula that will perform a specific function. I have two values, for example 15 and 50. 15 (b6) is the number of questions I have correct and 50 (c6) is the total number of ...
0
votes
3answers
69 views

Need two excel windows side by side, on different monitors [duplicate]

Excel opens all workbooks in the same instance and as a result you cannot place them on different monitors (or side by side). You can extend one window across both screens and then split windows from ...
0
votes
0answers
28 views

How to optimize Excel 2007 cell width for printing?

I have an Excel spreadsheet with 5 columns. Two columns have cells which contain very little text (e.g., dates or prices) while three columns have cells which can sometimes contain several rows of ...
1
vote
0answers
27 views

Gantt Chart Template using dates

I am using the Gantt Chart Template and I have changed all the period numbers to dates and the plan start to dates as well. It works great until I change the periods to weekdays. It continues to ...
0
votes
3answers
54 views

Excel auto fill a column with increment

I would like a column that increments by 1 each row, like this: 1 2 3 4 5 etc. I would like to do this for 20,000 rows. What's the easiest way to auto-fill this column on Excel for OS X? I can do ...
1
vote
2answers
54 views

How to convert Excel file with multiple sheets to a set of CSV files?

I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet? I can do it manually of course, but I'll have to be processing these ...
0
votes
0answers
26 views

Custom sort selection

I would like to be able to sort a selection based on the order of another range somewhere in the same workbook. While I realize I could add custom list and then sort the selection based on this, this ...
0
votes
0answers
30 views

Batch file can't find specified path when run from excel hyperlink

I have an excel file that has a list of IP addresses and I have linked a batch file that runs a simple ping test and outputs the results to a text log. When I run the file from the network location ...
2
votes
2answers
146 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
30 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
54 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
21 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
20 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
30 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
23 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
18 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
93 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
36 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
25 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
16 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
41 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
49 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
41 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
39 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
35 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
29 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
32 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
27 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
22 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
25 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
28 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
27 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
161 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
16 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
29 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
60 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
52 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
38 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 ...