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

Excel 2013 - Table connection problems

Okay I have a real problem on my hands and have spent several hours trying to figure this out. When I add a new column to and external data table (RP_DASH) the additional columns moves the data around ...
0
votes
2answers
20 views

Changing pricing Excel 2007

I need to update all pricing to end in .15 no matter what it currently reads. As of right now I have formatted the cells to only show two digits past the decimal, but when I click on the number, it ...
0
votes
1answer
16 views

Excel 2013 - need age that is input to reference numerical value

I am creating a spreadsheet of insurance rates from a number of companies. I would like to input the age of the individual once, which would then populate figures for each of the companies, retrieving ...
-2
votes
1answer
20 views

Find salesman sales between two Excel tabs

I have a spreadsheet with over 100 salesman's sales on two two tabs. On tab 1 is the person's sales number (ex. 5233) with his monthly sales. On the tab 2 is his quarterly sales. I need to add his ...
0
votes
2answers
17 views

Match-Search function in Excel?

So I've got 2 columns. Column "Mess" has gazillions of random numbers x digits long. Column "Check" has specific sorted numbers. Now I make a 3rd column called "boolean". I want a function to check ...
1
vote
0answers
13 views

Why does Excel 2013 Ignore My Keystrokes?

So I was doing some copying and pasting into this new Excel file, and all of a sudden the keyboard is not being recognized in Excel. I also am unable to save this file. Anyone have ideas? Here is a ...
-1
votes
1answer
22 views

How can I merge 2 sheets in excel?

I have to update a defect database in excel that is filled with data that fluctuates between 160 to 700 rows every day. This database has 19 columns, some of which are numerical and some are ...
0
votes
0answers
19 views

How can I type one keystroke YET return something else?

I want to be able to type one character in a cell and have it return something else so I do not have to type it over and over I am making a schedule spreadsheet so instead of typing 7/11 or 3/11 ...
0
votes
2answers
8 views

Create custom parts for the header and footer in Excel

I have a spreadsheet with several worksheets. On each printed page of each worksheet I would like to have references to some fields that i define somewhere in the document. More specifically, i would ...
-1
votes
0answers
10 views

Excel - pasting text opens “save as” dialogue box

I'm copy/pasting text in Excel. Whenever I use Cntrl-V or paste - it opens the "save as" dialogue box. This freezes the spreadsheet. How do I stop this from happening?
0
votes
0answers
9 views

Excel referencing: Go To Box does not fully have the whole path

When I reference to another workbook in the formula line I see the whole path to the workbook. So that is good. But when I have the referenced workbook closed (the one I get figures from) and I want ...
2
votes
1answer
17 views

How do I copy a column of numbers to another column while excluding cells with zero or blank?

I have a column containing zeros, blanks, and numbers greater than zero. I want to copy just the cells containing numbers greater than zero to another column of contiguous cells (no placeholder cells ...
0
votes
1answer
20 views

Excel: Matching and counting records (rows) to multiple conditions and unique values

I have two sheets: ‘Data’ and ‘Report’. In the report sheet, I need to calculate some data which requires 3 different formulae. The Data sheet has column headers in row 1 and many records of data in ...
0
votes
1answer
12 views

Two Dimensions Generated Table

I have a two dimensionnal table. And I'd like to fill it up like a multiplication table with Excel. But I can't find an easy way to do it. Copying-Pasting the columns or the ligns doesn't work. ----- ...
0
votes
0answers
11 views

Horizontal/Column filtering in Excel? Should be simple

In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value ...
0
votes
1answer
16 views

How can I return corresponding value from Master List by comparing Child List?

I have 3 columns MasterList, Value and ChildList. Now I want to compare Childlist against Masterlist and get the value from corresponding MasterList. I have below values in worksheet. MasterList ...
-1
votes
1answer
29 views

How can I alphabatize the word TRUE in excel?

When I type the word TRUE in an excel cell, it centers it and when I try to alphabetize a column which includes TRUE it puts it at the bottom. How can I make excel treat the word true just as a word? ...
0
votes
1answer
18 views

Convert Array to String with Excel Formula, is it possible?

Convert Array to String with Excel Formula, is it possible? I know how this would be done with VBA, but I have to share my workbook, and I have to assume that other people will not be able to enable ...
0
votes
1answer
18 views

Auto-Fill excel columns with formatting

I'm trying to create a To do list that I can easily manage in excel. In column C, I would like to press 'd' - and the cell automatically inputs done, and changes the background to green. The letter ...
-1
votes
0answers
18 views

I would like a macro to find a cell, then input a number 1 [on hold]

I have a spreadsheet with names in a column and years along the top row. When I do a particular piece of work, I want to run a macro to input a 1 in the appropriate cell to show the job has been done ...
-1
votes
0answers
12 views

How to write expression to diplay multiple series on same graph in Excel?

I need to plot 3 series to same graph. I cannot select by mouse because it's opened from onedrive.live.com I successfully map one series like that: =Sheet1!$C$12:$C$19 I need to map also ...
0
votes
2answers
28 views

Find most frequently used value

I know that that question has been asked before but my question needs more scalable solution! I have a column G with States, there are 10,000 States in that column. I need to find out what is most ...
2
votes
1answer
23 views

How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows: Unknown Very High High Medium Low Very Low None I like the visual cues provided by ...
0
votes
2answers
28 views

Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)? I have this option unchecked, but is still not ...
2
votes
2answers
25 views

Dynamic formulas based on other cell formula results

I have 10 years of monthly data for 300 plants. While Excel can do moving averages for various time periods I am looking to do a moving median value for this data set. I can obviously figure out the ...
0
votes
1answer
31 views

How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this? When I disable the specific add-ins by unchecking them in the ...
0
votes
1answer
31 views

Word document loads incredibly slow

I have a word document (286kb) which takes almost 2 min to load. The document contains a large number of excel objects (as links from the same workbook). This is what I've tried: Remove the "old" ...
1
vote
0answers
15 views

Feeding Data from SQL Server to Excel Template with visual studio c++ program [on hold]

I started a projet of automatic reporting. To realize this i am using Microsft Visual Studio 2010 C++ (Ultimate edition) Right now the project is almost finish, but i am getting stuck at the last ...
1
vote
2answers
25 views

Deleting segments of a text cell value in Excel

I have many lines that follow a similar suit to the below format in my Excel sheet: JFB001 D (2 Stem Flower Spray Orange Handcrafted Sugar Decorations) Web.jpg What do I have to do, in order to ...
0
votes
0answers
23 views

Excel import/ format problems

After clearing out lots of junk and formatting to a legible layout in excel im having problems crossing one final hurdle. My data I've imported is really hard to work with as its in the following ...
1
vote
1answer
21 views

Two Columns Sum if

I have an "amount column" and a "Date Vouchered column". What I would like is a formula in a "summary cell" that will show the sum total of the amounts once a date vouchered has been placed next to ...
3
votes
2answers
88 views

Showing a zero in front of a number in Excel

How do you get a zero to show up in front of a number if the numbers in the column are all different sizes, such as bank account numbers?
0
votes
2answers
30 views

Shortening an Excel formula if possible

I am unable to shorten an Excel formula I am using in an Excel database. I have googled it, but this appears to be the shortest way already from the first page on Google. ...
2
votes
1answer
37 views

How to convert data in Excel to percentages of total?

Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't ...
0
votes
1answer
25 views

Formula Required for Costs to date based on number of project days completed

I am trying to put together a template for project costs and am looking for a way to roll forward daily costs for each account code that avoids the need to change the formula on a daily basis. I have ...
0
votes
1answer
22 views

MS Excel : point a cell by concatenating text

In Microsoft Excel 2013, I want to point to a cell with this kind of formula : =Sheet1!["A"+E1] Where E1 contains the number of the line, for instance 25. So the purpose of the formula is to get ...
0
votes
1answer
13 views

excel: compare 3 column's numbers, decide on the largest number and place the column header in the 4th column

i want to compare the numbers of three columns, row by row, decide on the largest number and then place the title of the column of the largest number in a fourth column. the fourth column will end up ...
2
votes
2answers
18 views

Excel: Auto-updating chart with changeable starting point

I have hooked up excel to an auto-updating database, but now I want to go a step further and make all essential report items automatic as well. And not only that - I want to make the way report looks ...
-3
votes
1answer
21 views

Find and Replace in all excel files

I am no programmer. Is there a macro/vba/tool that allows me to find and replace in all opened excel files, at once? If not, an external tool that allow me to drag & drop files, because I have ...
-1
votes
0answers
18 views

Source code vCard to MS Excel [on hold]

Do you have any source code to convert contacts from vCard to MS Excel? Any type of language such as Java, C# and C++. Thanks in advance
0
votes
0answers
12 views

Adding to ranges within the XIRR function

The following (left side) is the standard example from the help on the XIRR function. The 37.43% is the XIRR. Now, assume that the initial row values are from somewhere else and I want to somehow ...
1
vote
1answer
63 views

Setup Excel 2010 sheet that automatically popluates bi weekly dates

I'm trying to set it up where if I fill in a date it will automatically fill in the next column and on down. For example: A1= 10/06/14 B1= 10/19/14 I want A/B 2 to be 10/20/14 and 11/02/14. I found ...
1
vote
2answers
29 views

Excel - Pick Top 3 Choices

I exported a Qualtrics survey which had users rank 6 options. I want to then take their top 3 options and list them in the row. Example: Choice A Choice B Choice C Choice D Choice E ...
0
votes
1answer
42 views

Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...
0
votes
1answer
19 views

LO Calc / Excel - Dropbox change another cell

I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet. The spreadsheet has a sheet called "Inventory" which has the following columns: Name Price This ...
-2
votes
1answer
25 views

Compare two rows and two columns and sum the 3rd row of the common value

I want to compare two rows and two columns and have to sum the third row of the common value. I have two sheets. In one, I have the work the students made, ordered by date. In the same sheet, I have ...
2
votes
1answer
31 views

Can I sort in excel but read the cell values from right to left?

I have an excel worksheet list of names and email addresses. Some of the email addresses, however, are cutoff on the right and have "...". For example: some email addresses are "test@test_user...". ...
0
votes
0answers
12 views

How can Excel add-ins be managed in an environment with multiple version of Office?

I have both Excel 2010 and 2013 installed. COM add-ins appear to be shared by all versions of Office. This is problematic because the whole point of having multiple version installed was to be able to ...
0
votes
1answer
47 views

Lookup Values Based on Values in Other Cells

I have an inventory list that contains a manufacturer name and product category for each product. I want to look up the code for the manufacturer and the category code for the product and place the ...
1
vote
2answers
31 views

How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date). The chart is printed or worked on at ...