# Tagged Questions

**0**

votes

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**3**answers

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

**0**answers

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

**0**answers

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

**3**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**3**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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 ...