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

check one column against another and return a third

I'm trying to create an import csv. the sheet has the following data ImportID, 1stname, FirstName, inport_ID 1, Bob B, Bob T 2, sue, Bob B, 1 3, Jill P, Jill P, 3 4, Michael, Jill P, 3 I need to ...
0
votes
0answers
4 views

Convert a formula in Excel into an Array Formula without Ctrl-Shift-Enter?

Question: How might it be possible in Excel to convert a formula into an array formula, without using a hotkey? Normal Formula Array Formula
2
votes
2answers
37 views

Alphanumeric sorting in Excel

In Excel, is it possible to sort alphanumerics from a-1, a-2, a-3...a-123 instead of a-1, a-10, a-100, a-11? Sorting via oldest to newest or via A-Z, definitely won't give me the result I want. I've ...
0
votes
1answer
10 views

Match first and last name to 2nd column then output corresponding 3rd value

I'm trying to create an import csv. the sheet has the following data ImportID, 1stname, lastname, FirstName, LastName, inport_ID 1, bob, Abraham, bob, Abbott, 2, sue, Abraham, bob, Abraham, 1 3, ...
0
votes
3answers
26 views

EXCEL - How to have a formula output and user input on the same cell?

I would like help from someone as I believe this problem requires VB. I basically have a CELL(A4) where people will be entering values to find out the corresponding calculations displayed below. ...
-2
votes
0answers
25 views

INDEX AND MATCH

I am using a formula w/ index and match and it returns data where it should be blank. help ex miles month unit 1000 apr 101 1001 may 101 1001 jun 101 1002 jun ...
1
vote
1answer
13 views

In Excel, how do I replace all instances of text in a cell if any of the text matches values from a range of cells)

To make things easy for users of this workbook, I've setup column J with data validation (pulling values from Sheet2) that allows for multiple selections of event types (Academic Calendar, Art ...
0
votes
0answers
21 views

Dynamic Bars in an Excel Bar Chart

In a typical bar chart, is there a way to dynamically change each bar color based on a variable? (example: If value is 1 then bar color equal Red, If value is 2 then bar color equal yellow, etc.)
0
votes
2answers
20 views

Indexing a sum of values by row from multiple columns

I'm struggling with this one... In row 2 I have week numbers up to week 9 in this example. Row 1 has a formula that determines to which month a week belongs. In this example, week 5 is in month 1 ...
0
votes
0answers
27 views

Perform a calculation n times and sum the results (without VBA)

I'm looking for a way to sum the result of a calculation performed a given, arbitrarily large, number of times. Suppose I have 15,000 customers each of whom will spend between $100 and $200, and I ...
-1
votes
1answer
22 views

Excel Macro to do a Sql Query

I need to do a Macro in Excel Worksheet such for the following process. User will enter a string in the Text field and click a button. When the button is clicked the VBscript should match the ...
0
votes
0answers
17 views

Add vertical line to horizontal bar chart - Excel 2013

In the below screenshot, I wish to add a vertical line at 80%. How do I do this in Excel 2013? I see that there are tutorials on older versions of Excel but does not seem to work for 2013.
-1
votes
0answers
8 views

Run-time error '13' : Type Mismatch [migrated]

While writing a Macro for Concrete Column, I have encountered a "Run-time error '13' : Type Mismatch" Error Here is the code. Option Explicit Sub Pu() Dim D, b, fck, fy, Es As Double Dim xi As ...
-3
votes
1answer
37 views

Compare two cell data and pull the third vaue if both the cells match

I have the following 2 sheets, Sheet 1: Customer Customer Name StockCode A00003U AVAGO TECHNOLOGIES SC1865-01-00 A00003U AVAGO TECHNOLOGIES ...
1
vote
0answers
10 views

Excel: An indication that a small cell contains more information within that cell

When a cell contains more information than the width of the cell allows, then content is hidden. Is there any way to show this visually in Excel that this is the case (like an icon or similar)?
0
votes
0answers
12 views

Updating multiple pivot tables with slicers

I have a worksheet with about 15 different pivot tables, about 80% of them with multiple slicers. I've added rows to the data source sheet, however when I try to update the data source on the pivot ...
-1
votes
0answers
14 views

Automatic generate number series

How to create a numeric series based on an input value For example: If you enter 3 in the number of types column, it will generate 1,2, 3 to SSiatem# column. Then enter another number of type say 2, ...
-2
votes
1answer
20 views

How to create a numeric series based on input value in excel and repeat it for several inputs

I want to create a numeric series based on input value in Excel. For example if user type 3 in column D7, there should be a series of like 1, 2, 3 in column E7. Then continue to enter or type a ...
-6
votes
0answers
28 views

Microsoft - Excel [on hold]

I am wondering if you are able to auto fill an order form on one sheet of document with information from several other sheets in the document. For instance, be able to type in the project name of ...
0
votes
1answer
19 views

CSV File saving as Creo Pro Versioned File

This is an odd one, I'm saving an Excel file as a CSV file, which is the required format I have to send this data in as. However when I save the file, it shows in the Directory as a Creo Pro Versioned ...
1
vote
1answer
25 views

Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...
0
votes
1answer
12 views

How can I set up logic to count the number of occurences in a month for a list of dates?

I have dates that look like this: 9/24/13 9/24/13 10/7/13 10/7/13 10/14/13 10/16/13 10/22/13 10/22/13 10/30/13 I need logic in a cell that will count the number of September occurrences. Then I ...
0
votes
1answer
6 views

Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items, with different information in all columns ,although certain columns might have duplicate information. I can do conditional formatting and highlight the ...
0
votes
2answers
18 views

Drag the cell to create an array of Roman numbers

I need to create an array of cells of roman numbers. So I placed my entry like this cell A1: I cell A2: II cell A3: III cell A4: IV I selected the entries and dragged the corner down, hoping that ...
0
votes
1answer
18 views

Format dates so they are split across two lines

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well). In other words, between the ...
1
vote
1answer
16 views

Office 365 Excel Online keeps on deleting a textbox

I have a number of spreadsheets on One Drive. If I open them in "Excel Online", the first thing that happens is that the text box which contains the header graphic and title on the spreadsheet is ...
0
votes
1answer
10 views

Microsoft Excel 2013 on Windows 7, creating cost based on drop down values

Hi I am need of some assistance and was wondering if anyone can help me. I am creating a spreadsheet for quoting jobs on site and am stuck with a particular part. I have a cell containing a drop down ...
-1
votes
1answer
15 views

Assign the value of a cell as a cell reference of another cell in Excel - How to?

The intention behind this query is to simplify the review of excel sheets with engineering calculations. Let us assume that column A contains the notations. cell A1 contains "Rfa" and cell A2 ...
0
votes
2answers
18 views

Computing time difference to fraction in excel

Consider an employee working 8 hours a day (9AM-6PM), and came in 9:25AM, had a break at 12:00 - 1:00PM and logged out at 6PM. I use a formula to get hours worked (7.58) - ...
0
votes
1answer
14 views

selecting elements from a column in Excel

In Excel, I have three columns A2:A100, B2:B50, C2:C50. I want to do the following things: If An (n is any number between 2 and 100) is in B2:B50 AND Bm==An for some m, then let Dn=Cm. How can I do ...
0
votes
1answer
13 views

Move cursor to specific cell in other worksheet

I put a value in "Sheet1" cell "J2". On running the macro I want cursor to move to "Sheet2" Column "B" and row number as per value put in "Sheet1" cell "J2". Please suggest vba code for the same. ...
1
vote
2answers
41 views

Look up a value in a list and return ALL multiple corresponding values

The basic answer to my question is provided here: How to look up a value in a list and return multiple corresponding values. However, once the formula is entered, I need to drag down, or copy/paste ...
-2
votes
1answer
22 views

Need an “IF” function that shows whether the difference of a simple subtraction is greater than a certain value

I have values in cells A3 and A2. I will be subtracting the value of A2 from A3. What I need is to be able to highlight or flag the result if the difference is greater than an absolute value of .01 ...
-1
votes
1answer
22 views

How do I add two URLs into given format?

I have a excel sheet..That contains two urls sets..I need to add them into this format in another column Col 1 Col 2 Web site A.1 Web site B.1 Web site A.2 ...
0
votes
1answer
22 views

Use macro to email document, and CC another user

I have a spreadsheet with a macro button that forwards the document to a specific user in an email. I have been asked to now have the email send to the original recipient and CC another email address. ...
0
votes
1answer
18 views

Excel 2013 Multiple Validation Rules

I have a 2 part problem that I am having issues with... mainly part 2. I have gotten the first part to work by itself. 1) I have a column which contains part numbers (###-#####-###). I am using data ...
1
vote
1answer
9 views

How do I retrieve all values from a 3D range and insert into the current worksheet?

I have a series of worksheets named 1.. 50. I want the values of the 3D range '1:50'!A10 inserted into a range on the current worksheet, RawData. How do I do this?
1
vote
2answers
29 views

Find largest number in one list and smallest number in another list to index one cell

![enter image description here][1]Is there a way to identify the highest number in a list and the lowest number in a list to index to a cell? I have a list of players, each player has total number of ...
0
votes
0answers
13 views

Merging Data from a Spreedsheet into an e-mail template

I'm trying to find an application of sorts to help me extract data from a spreadsheet and then display that data into an e-mail form e.g. Spreedsheet data.xls Field 1 | Field 2 | Field 3 Data | ...
-3
votes
0answers
23 views

Need Help in Excel [on hold]

NAME From To Dept Date Arrv Date Sachin Bangalore Pune 01/08/14 08/08/14 Sachin Pune Mumbai 08/08/14 12/08/14 Sachin Mumbai Delhi 14/08/14 25/08/14 ...
-1
votes
0answers
10 views

Have Excel sheet manifest in two ways

Is there a way to have the data manifest in two ways on two different sheets? So I have the same data where perhaps I sort by date, then another sheet I sort by alphabet. Key thing though is that I ...
0
votes
1answer
20 views

How do I stop Excel Auto Update?

I have an excel file (linked to software) of stock prices, the files gets updated prices from the software. However, I want the excel to update data only when I want (say F9). Please suggest. I can ...
0
votes
1answer
30 views

Group Data By Multiple Columns

I'm not sure I phrased this title correctly. Please feel welcome to offer suggested edits. I have data formatted like so: Token,Location,Quantity VBD,IN,100 NN,IN,200 FD,OUT,300 VBD,OUT,300 ...
0
votes
1answer
24 views

Spreadsheets Formula Check In/CheckOut Autopopulate Data

I am working on a spreadsheet (I am doing it in Numbers since it will easily let me work on the file on my mac, iPhone, iPad and online at icloud.com)... but this is essentially also an excel question ...
0
votes
1answer
27 views

How can I use pivot table grouping by dates incremented by a day at a time?

I have some data which has been extracted from staff timesheets which provides number of hours worked by a member of staff on a given day. I need to summarise this information grouping by days but ...
2
votes
2answers
23 views

Indicating trends within sparklines in Excel

I have created a load of sparklines in Excel for a variety of diseases over time. However, in order to identify trends from these sparklines, it would be useful to include a little more information ...
0
votes
1answer
14 views

Creating 2D data from a flat/1D list of spreadsheet entries

This seems like it'd be a really common operation, but I don't know the terminology or what to search for. I have a table like the following in CSV: +------+------+------+------+ | Test | Var1 | Var2 ...
0
votes
0answers
9 views

Change regional number format for powerpoint, but not excel

My clients (and me) are Germany-based, as such I need to use the German number format 1.000.000,00 for all client-facing documents, usually created in Powerpoint 2007. In Excel however, I use the ...
-5
votes
0answers
25 views

Checking cells format [on hold]

I need to check that a list of post codes has a valid format, like the following: AA9A 9AA A9A 9AA A9 9AA A99 9AA AA9 9AA AA99 9AA A = letter 9 = number How do I do that in Excel? Any ideas?
1
vote
1answer
14 views

MS Word tables as link from Excel only shows a single line

I have a Word document that functions as a template using a linked table to an external Excel sheet. My problem is that when i 'paste special' to insert the link, the table shows only the last line of ...