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
34 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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
95 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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
45 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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
0answers
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
1answer
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
1answer
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
5answers
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
0answers
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
1answer
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 ...
-1
votes
1answer
84 views

Correct way to write or even better combine these two Excel 2007 formulas

I have two formulas. As an example for this question let's assume I have a workbook that is basically a CD Database. It contains all the usual information that you would expect. This workbook is ...
1
vote
0answers
16 views

Track workflow precendents using only Excel Formulas

what I'm trying to achieve is the following. I have a production chain, say for example: A and B are used to make C C and D are used to make E and E is used to make F And I wanna know the direct ...
0
votes
0answers
33 views

How to transpose a named range in Excel 2013, using cell formulas (not VBA)

Similar to this question, I want to display the values of a named range (horizontal) in a vertical range. If I have data a b d f which is named Letters (as a named range). I want to display this ...
0
votes
1answer
33 views

Need a formula to count numbers beginning with specific digits in a string separated by commas

I need a formula to count numbers beginning with specific digits in a string separated by commas The 1st digit is always 1,2 or 3; second digit can be between 1 to 6. I need to count the numbers in ...