**1**

vote

**1**answer

35 views

### How can I write only certain rows of an Excel worksheet to CSV?

I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...

**2**

votes

**1**answer

38 views

### Creating a line graph in excel with changing/result cells

For a project we are creating care packages for the homeless. I am trying to figure how many kits to make for the least leftover material as the things we are putting into the packages are sold in ...

**1**

vote

**1**answer

131 views

### How do I add new row in Excel *below* the current one?

The Insert > Insert Sheet Rows command in Excel always inserts a row above the current row. However, it is quite a common scenario for me to want to insert a row below the current row, like this:
...

**1**

vote

**1**answer

24 views

### Full page background for Excel

Is it possible to set a background image in Excel that extends to the whole page and not only the region with cells?
In principle I would like to cover the maximum possible printable area.

**0**

votes

**0**answers

35 views

### Losing decimal places when exporting to csv

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...

**1**

vote

**0**answers

70 views

### Excel workbooks pinned to taskbar on Win 10 disappeared

My question is two fold:
Can I change the order of Excel workbooks pinned to the taskbar on Win 10? In Win 8.1 I could just drag them in whichever order I wanted.
I saw the similar question ...

**0**

votes

**2**answers

28 views

### Excel Countifs date column not empty

I am trying to count number of external employees.
There are two columns,
Column F with values EXT for external and INT for internal employees
Column G with date.
Now, if date column is empty ...

**0**

votes

**1**answer

43 views

### Excel - display amount in a different currency on mouse over / cell selection?

I am working on an Excel spreadsheet that uses a currency other than my native and I'd like to see quick and convenient currency conversions, possibly in the status bar (like when you select multiple ...

**-5**

votes

**0**answers

35 views

### How to calculate the cheapest way to use transit tokens or monthly pass or combination between two dates

I need to find out if it is better to pay for transit using tokens or monthly pass or combination of both between two dates, for several hundred people. I know how to determine the fare if they use ...

**1**

vote

**1**answer

12 views

### Forcing formulae stored in table linked to SQL database to evaluate

I have a table in a spreadsheet linked to a SQL table elsewhere. There is a column which has a formula in it, akin to ="string1" & CHAR(10) & "string2". When linked, this column displays the ...

**0**

votes

**1**answer

98 views

### Stacked column chart in Excel with the label of x-axis between the bars

I want to draw a stacked column chart in Excel and I want to put the label of the x-axis between the bars; for example:

**0**

votes

**1**answer

22 views

### Count unique values in column by month with blanks

I have 2 columns I am comparing. One column I want to count unique numbers. I want to quantify this unique count by month. (Work Orders per Month).
I'm using:
...

**0**

votes

**0**answers

17 views

### Excel: How to make certain cells “constants” so that they are not incremented when pasting a formula? [duplicate]

I would like to make cell A1 an input, column B an input, and column C to depend on A1 and column B, for example,
I have the value 5 in A1, and I want to set C1 = A1*B1, C2 = A1*B2, C3 = A1*B3, etc.
...

**1**

vote

**0**answers

25 views

### Excel: Freezing first column horizontally and first row both horizontally and vertically [duplicate]

I have the following challenge in Excel 2010: I have a pivot table with several (4) slicers, and want to keep all the slicers and the first column of the pivot table visible at all times.
Using ...

**0**

votes

**1**answer

15 views

### Excel - Scatter plot does not connect all data points

in Excel I have a chart with 5 scatterplots. The x-axis is always the same column. However, the last added scatterplot does not connect all data points (see figure). There are some blank cells in the ...

**0**

votes

**0**answers

17 views

### Excel go to / highlight precedents / dependents shortcut on German keyboard

Are there German equivalents for the
CTRL - ]
CTRL - [
CTRL - SHIFT - ]
CTRL - SHIFT - [
Shortcuts?
If not, any workarounds?

**0**

votes

**1**answer

23 views

### moving file names to excel

How can I select just the title of a photograph and transfer it to an Excel cell and do a batch of 100 at a time moving each title to the next Excel cell?

**0**

votes

**1**answer

32 views

### Excel to count cells between specific dates

I have daily sales record throughout the year. so column A showing date from 1st Jan to 31st Dec. Column B is having sale amount. Some of the days having zero sale value.
I want to count number of ...

**0**

votes

**0**answers

27 views

### Excel show drop-down list based on selection from second drop-down list

I have a drop-down list, let's say, for example, you have the choice to select between fruits and vegetables from cell A1
When you select fruits, the drop-down list in cell B1should show a list of ...

**0**

votes

**0**answers

34 views

### Excel formula to find a particular sheet of a workbook from another workbook

I am looking up one workbook (Figuresmaster) to pull financial figures into another workbook (AreaBudgets). I have the below lookup formula working (in AreaBudgets).
=IF(ISNA(
...

**-1**

votes

**0**answers

46 views

### How do I filter a Combobox via VBA the way the Filter box works?

I'd like to use VBA to sort/filter a Combobox on a Userform so that it works the same way a Heading Filter pull down works on the worksheet.
For example, I would like the items to filter as the user ...

**0**

votes

**0**answers

8 views

### How to copy list of values to grouped cells so that one value gets copied to one group in excel

I have a column with names in one excel file, one name per row. I have another excel file where 5 rows are merged to one so that it represents one pseudo row.
when i copy paste the name column i want ...

**0**

votes

**2**answers

43 views

### Is it possible to have an Excel formula dependent on value input?

Is it possible to have Cell G24 recognize the number in D24, and do its math depending on the size of the number, using the in Cells B37 through B42?
I have a basic spreadsheet for cataloging sales ...

**0**

votes

**1**answer

9 views

### Copying entire field to another worksheet

I created a table in the first worksheet, where row 1 are the headers and row 2 onwards is the data.
I want to copy the first field [ProjectCode] into a second worksheet, i.e. copy EVERY record. In ...

**0**

votes

**0**answers

28 views

### Macro, Formula or Code? Copy data to new sheet based on specific criteria?

I have tried pulling this together with various formulas but A. A lot of the didnt
work and B. it was very messy.
For the example of this question lets use a Music CD with 2 Disc.
The information is ...

**0**

votes

**0**answers

38 views

### Calculate peak width for multiple peaks [duplicate]

I have a wave shape of data that goes up and down. How do I find the width of peak for each peak.
I marked the peak and bottom value for each wave
0.522460938
0.52734375
0.537109375
0.537109375
...

**-1**

votes

**1**answer

25 views

### Microsoft Excel 2010 [closed]

I need to change a batch of cells containing specific letters to another specific letter. The bulk of cells is so many that I would like to change it only once. Any one knows how I can do that?

**0**

votes

**1**answer

28 views

### Sum up values from two lines but keeping some columns seperate

I want to sum up the values in Column C for rows with same Column B value.
In my example the values for A Dunn and G Birch should be combined, with the bottom line going blank
But column A (account ...

**-2**

votes

**0**answers

41 views

### Google sheets/excel array formula return row of values based on =TODAY()

I am collecting data from a Google form to a spreadsheet and then capturing that information into a 2nd spreadsheet for manipulation. From here I want to display the same information on a 3rd sheet ...

**-1**

votes

**1**answer

78 views

### Finding a value base on an “ID”

How can I assign a "CityID" in "Customer Table" using customer's Address and a given "ProvinceID"?
(Province Table)
ID . ProvinceName
1 . . Ontario
2 . . Quebec
3 . . Nova Scotia
4 . . Quebec
(City ...

**1**

vote

**1**answer

39 views

### How to automatically sort random numbers

I've got 2 columns in a spreadsheet.
Col. A contains a formula that generates a random number:
=RANDBETWEEN(1,100)
Col. B calculates the rank of the random number in A using
...

**1**

vote

**2**answers

38 views

### How to convert cells of a column to text in Excel 2007

I have a column consisting of cells (from 1 hundred to over 100 thousands) with values like :
5
12
78.456
1235.78510
AFT780.963
ZFLQ
57180.004
...
I want a way to rapidly change the format of the ...

**2**

votes

**2**answers

49 views

### Raise matrix to power without VBA

I need to raise a matrix to a large power (say 200), and I can't use VBA because it is for a final user whose IT doesn't allow macros to run.
Also since the power is large, it won't suffice to write ...

**3**

votes

**1**answer

29 views

### Excel: bulk changing format

I have received an Excel report which features a column of cells that contains date (dd/mm/yyyy) and a time code (hh/mm/ss).
However only the time code is required and I cannot, for the life of me, ...

**0**

votes

**1**answer

19 views

### How to extract part of a filename in Excel

I saw a post about using the CELL function to return and extract the filename as ABC.xlsx. The formula used was:
...

**0**

votes

**0**answers

22 views

### Excel 2007. 2nd Formula wont accept result of 1st formula on a different work sheet

I have a rather frustrating problem that it seems others have had also but I have yet to find a solution that works.
I have simplified things below as I tend to give too much information.
Basicly I ...

**-3**

votes

**1**answer

26 views

### Subtraction of time formats in Excel

I want to calculate the difference between hours. I tried using the formula mentioned above which uses the ABS function with the TEXT function and the IF function, but that didn't work. I also tried ...

**-1**

votes

**1**answer

15 views

### Sequence ID numbers in excel

I need a sequence number added to similar values:
In the same column:
1DR I am trying to number 1DR001
1CP = 1CP001
1CP = 1CP002
1DF = 1DF001
1DR = 1DR002

**-1**

votes

**0**answers

17 views

### Excel Auto Fill Date

I am using Excel to keep track of my finances. I have created a column for the date (Column A) using the today() excel function. How can I automate it for multiple entries for the same day? So for ...

**0**

votes

**1**answer

51 views

### (Subscript out of range) Error 9

Below is a modified version of a code (i found on Stack Exchange) that I am currently using -
Option Explicit
Sub Main()
Columns("E:E").NumberFormat = "@"
Dim i As Long, c As Long, r As ...

**-2**

votes

**1**answer

37 views

### MS365, Excel 13 - New row added not auto updating formulas

I have a table in Excel I made myself not an inserted one - though I have tried that too it didn't do anything. The problem is at the end I add a new row and none of my formulas are in the new row. My ...

**0**

votes

**0**answers

21 views

### How to combine multiple worksheets into one, with one key column

I am trying to combine three worksheets into one, with a key column. Each worksheet has the names of people in the first column, followed by columns of data and information related to the person, each ...

**4**

votes

**2**answers

73 views

### How can I parse a string from a cell multiple time in excel?

I have a column in my datasheet that often contains a string that I want to place in another column. This string may occur multiple times and I want to place ALL instances of it into the other column. ...

**1**

vote

**2**answers

48 views

### Formula substitution excel

is it possible to do formula substitution easily in excel?
I have a worksheet similar to below example (albeit more complex, hence the need for some function in excel if there exists one)
What I ...

**1**

vote

**0**answers

27 views

### Combining distinct patient ID with patient characteristics

I'm trying to use Excel to analyse a large set of patient data (>16,000 entries). Each patient is identified by a numeric patient identifier and is recorded each visit. This means some patients are ...

**1**

vote

**1**answer

30 views

### How to view only a single line from multiple line chart diagram in Excel

How to view only a single line from multiple line chart diagram in Excel.
Example: As shown in the image below, I'm having 3 separate lines, one for each user. I want to see each line separately (as ...

**-1**

votes

**1**answer

92 views

### Exporting Excel sheet to CSV - but exclude first 10 rows

[![Sheets in yellow I wish to ignore when I do the export, the Ws.rows command deletes the first 10 row but the vba script still exports all the sheets as CSV which I don't want, all the sheets have ...

**0**

votes

**5**answers

88 views

### Can I run this Macro faster? [duplicate]

I am using this macro for over 1000 entries. The code itself works the way I want it to.
Option Explicit
Sub DoTheThing()
Dim keepValueCol As String
keepValueCol = "H"
Dim row As Integer
row = ...

**0**

votes

**0**answers

23 views

### Excel linked data formula turns to #REF upon opening workbook Office 365 ProPlus

Open File A with vlookup formula referencing File B. File A will show fine. Open File B and File A will change to #REF!
I correct the #REF! and make sure to update formulas (calculate) to file B. ...

**1**

vote

**1**answer

26 views

### Excel: Comma separated values inside a cell - explode into more rows made with every combination

I want to go from something like the first table to the second table:
...For the sake of using in a pivot table. I would like the first table to be on one sheet, and the second table to be another ...