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 excelvba. If it is about an Excel formula or worksheet function, then also tag it worksheetfunction.
0
votes
1answer
7 views
Is there a way in which to show two values per pie slice in a pie chart?
Trying to show for each major slice of a pie chart(4 total slices), two pieces of data per pie slice (% of items with information and % of items without information)
1
votes
0answers
10 views
Is there any point in getting the MOS certificate? Especially Excel?
Anyone here got a MOS certificate? How was the test? Was it difficult? I am interested in getting the two Excel 2013 certificates. How useful would it be in getting a job? Almost all financial analyst ...
0
votes
0answers
7 views
How to include image(.png) in legend of an excel chart?
All,
I am trying to include company logos as legends of excel charts instead of their names automatically using VBA. Any leads will be highly appreciated.
1
vote
1answer
36 views
Excel. Looking for exact match and return value
I have 3 Excel files. Excel file 1 and Excel file 2 contains:
Fixed data in column A
Different values in column H.
Excel file 3 (dashboard) contains the fixed data found in column A of the 2 ...
0
votes
1answer
19 views
Copy Table values from one sheet to another
On the first sheet of the spread sheet I have the following:
1 Item Item Description
2 xxxxxx yyyyyyyyyyyyyyyyy
3
4 Object 1 Object 2 Object 3
5 AAA ...
0
votes
0answers
5 views
Pivot table 'page fields' usage
In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts by pressing Alt, D, P. In one of steps there is one ...
1
vote
1answer
52 views
Excel VBA row fetching loop
I have three sheets: "bom", "MPS" and "DData". What I'm trying to do is first read the value of cell A2 from "MPS" and fetch all the rows from "bom" that in column A have that value and list them to ...
1
vote
1answer
18 views
How do I display the value of one cell in a cell on another sheet?
I would like to build a spread sheet with multiple sheets. The first sheet is the main 'working' page. The additional sheets would be filters of data found on the first sheet. On the first sheet on ...
2
votes
3answers
27 views
How to auto fill increasing values between existing filled cells
the situation is like this:
0


0




0



0
I wanted to be like this:
0
1
2
0
1
2
3
4
0
1
2
3
0
There are thousands of cells in the range and this cannot be done manually.
2
votes
2answers
39 views
How to add a line break to the output of a formula in Excel?
=UPPER($B$8)& " " &PROPER($C$8) & "& " & UPPER($B$9)& " "&PROPER($C$9))
I want add a line break to a cell. Current my cell looks like this:
SMITH John & SMITH Linda
...
0
votes
1answer
12 views
Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”
I've got a great pivot table in tabular layout, but how do I "fill down" values in column A?
A10 should also read "Alpaha Police"
A15:A18 should also read "Atkinson Co Sheriff"
0
votes
0answers
13 views
Determine a Scrum team's historical performance [on hold]
I manage a Scrum team that calculates "Planned" versus "Actual" velocity each sprint (2week timebox). Velocity is measured in points.
For example, in sprint #1, the team may plan to deliver 50 ...
0
votes
0answers
15 views
Merge two Excel files and only retain new data?
I manage a daily shipping report (an Excel file) that has many date fields (departure, arrival, etc.) that are populated automatically from our shipping system. In the last column of the report I add ...
1
votes
1answer
19 views
Excel CONCATENATE function produces error when referencing a worksheet with space in name
In Microsoft Office Excel 2013 on a Windows 8.1 PC, I get an error message, #NAME?, when trying to do the following:
=CONCATENATE('Calculation Sheet'!D, " Customer Sales")
Doing the same with an ...
0
votes
1answer
12 views
Using ISNUMBER and SEARCH
I'm trying to use the formula =IF(ISNUMBER(SEARCH("180",A1,0),1,0) but for some reason it isn't working. I tried removing the quotes and the same problem occurred, I see entries (e.g. "it is 180 ...
0
votes
1answer
17 views
Using A Conditioning Statement
Tried using statement =NOT($F2="Received"), but it still highlights everything. To start from the beginning because none of these are working, I am looking to highlight everything in red that has been ...
1
votes
3answers
45 views
Formula is not working, cannot find error in the formula
I'm sure that this has an incredibly simple answer but I've looked over this formula for hours and can't figure out the error. Essentially what I want the formula to do is if F3 = "Freshman" then ...
0
votes
1answer
18 views
Different permission for different user on Excel Online
I need to create Excel online workbook with different permissions sheets. more like some users can see some sheets while other can't edit, etc.
can I achieve this?
3
votes
1answer
33 views
Alternative programs to Visual Studio [on hold]
I am looking for an alternative (free to download) program similar to visual studio where i can create dlls that i can import into Excel. I have sharp develop but i am unable to import dlls into excel ...
0
votes
0answers
15 views
Multiple languages mail merge word
I'm having some trouble with Microsoft Word's mail merge feature. Every day, we send an email to a bunch of people across the world. I have an around 600 rows Excel file generated daily and I send an ...
2
votes
0answers
25 views
Excel to sum row values in date range
I have a worksheet with dates in row 1 and data values in rows 2  5. The data is then subtotalled in row 6.
The dates start from G1 and the date increases in the next column to the right. Currently ...
2
votes
0answers
27 views
Opening Microsoft Office 365 gives blank menus and blank popups
I have recently installed Microsoft Office 365 (shows up as Office 2013) but when I open any of the applications (Word, Excel, etc.) I am presented with a popup which is nearly blank and the ribbon ...
2
votes
1answer
22 views
Replace contents of Excel column with realtional data from another column/sheet?
I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column.
For example, in one ...
1
vote
0answers
20 views
Users logged on [on hold]
Need help with this I am able to run this script with no issue even excel pops up however no computer or data come in please help. I am just trying to get a list of user logged in from a specific ...
0
votes
0answers
35 views
Multiplying Two Cells Returns Zero
I created a formula field that multiplies two cells and it returns 0 even if the numbers in those cells are greater than 0.
The formula is
=K2*J2
The values I see in those cells are:
K2 = 16.32J2 ...
2
votes
1answer
17 views
How to nest SubTotal with SumIf? [on hold]
I have an Excel table. I would like to combine in one Formula following:
=SUBTOTAL(9;M10:M21)
and
=SUMIF(I10:I21;"Promotion";M10:M21)
Is it possible ?
0
votes
3answers
51 views
calculating end times with working hours and skipping weekends
In my worksheet, I want to calculate estimated end times of processes.
However, i want to restrict this to a predetermined time constraint. So for example, when i add 4 hours to 14:00 I dont want the ...
0
votes
1answer
24 views
Bar chart from data in one column in Excel
Call me stupid but every time I want to perform an easy task in Excel I end up using Google to find a solution. Today's mission impossible is to create a bar(or pie) chart from data located in one ...
0
votes
0answers
16 views
switching between excel and other program alt + tab
I am having a problem in my new system. When I have to type certain figures in excel worksheet from a different program, I use alt + tab. Now if I am typing a long figure and have to see more than ...
3
votes
1answer
31 views
Excel, how to use text functions on lookup array without putting in another column?
If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column?
Let's say I ...
1
vote
1answer
12 views
How to copy a path from “recent items” in any MS Office application?
or "recent places" for that matter
It's not possible to copy the location from the application, so is this list stored somewhere else e.g. registry, file system, xml config file?
The problem is that ...
0
votes
3answers
50 views
How to automatically make copies of columns in Excel?
Everyday I have to take the raw data which has more than 40 columns and increasing number of rows (right now 2,5 millions) and prepare it according to a certain format.
Lets assume that I have 5 ...
2
votes
0answers
24 views
How to make 1300 row Excel file with specific column name and copy the data in separate workbook? [on hold]
File#1
BEE PEE GREENS (All Lic From 01/04/2002 to 30/09/2014)
LicenseNo LicenseDate LicenseValue LiCategory IssuingOffice ExporterClass Item
1830000033 11Jun13 ...
0
votes
1answer
22 views
VBA highlighting a cell if corresponding range in the same row is not blank
I am trying to enforce food name in column B of a file if column D to DX (Qty) has any value in it.
Rational is if any new request of food is received which doesnt appear in the file, the user can ...
0
votes
0answers
16 views
Column order and names for table objects in Excel
I have a table in Excel that is connected to MS SQL Server table in the database. When I created a connection I specified a query that returns col1, col2, and col3 in this particular order. Then I can ...
1
vote
1answer
53 views
Excel chart for rail car movements
I need to display the movements of a group of rail cars between two locations.
Each car has dates for "left location A", "arrived location B", "left location B", "arrived Location A"  repeatedly ...
1
votes
1answer
25 views
Excel 2013 displaying 'zoomed' UI on Windows 8.1 with high DPI screen?
I'm using a high DPI laptop  13" 1080p screen  which Windows 8.1 usually manages very nicely for modern sofware. Old stuff looks blurry, PowerShell is bizarrely unusable, everything else pretty much ...
0
votes
1answer
28 views
How to translate automatic months from a language to another?
I'd like to translate a billing report from Portuguese to english.
It is accurate by months, and it is an automated sheet.
A contract may start on January, but it's commonly started on the others 11 ...
2
votes
2answers
46 views
Random selection with a caveat / criteria
I have a 6 x 6 grid. I have 36 samples split into three equal groups (A, B, and C).
I want a formula to arrange the samples in that grid randomly. However each row and each column must contain two of ...
1
votes
0answers
20 views
Autonumber based on criteria
Trying to create a specific autonumber system based on the following:
**Criteria** **Numbering Sequence**
Pillar 4.0
Objective 4.1
Action Item ...
0
votes
1answer
21 views
Copy/Paste only cells with values
Is it possible to do the following?
Source Target Result
1 F 000 10F
    > 0 0 = 0 0
1 F 000 ...
0
votes
1answer
37 views
Excel  find multiple pieces of data in several different columns at once
I've currently got a spreadsheet on the go which lists contracts. I need to know if a contract is a renewal, new to product, or new to company. I'm currently struggling with the logic behind it and ...
0
votes
2answers
38 views
Improper Excel Profit Formula?
I'm looking to include in column H of my spreadsheet as profit as a %. Such as if you paid $5, and sold for $10, you made 200% profit or 2x your money, obviously excel will only recognize 200%, not ...
1
vote
1answer
21 views
Excel conditional drop down lists causing massive file size
I have an excel file which relies heavily on data validation. There are about 20 drop down lists per row. One column has a 35 formatting conditions. One column is a conditional drop down list (using ...
1
vote
0answers
22 views
How do I combine data in two tables in LibreOffice?
I have a spreadsheet with two sheets inside, SheetA has Customer number and location, SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and ...
0
votes
0answers
24 views
How do I apply conditional formatting to many workbooks?
I have 120 similar excel workbooks. They each have one sheet containing a small customer databases.
I want to apply conditional formatting to all these workbooks. I can do it in one workbook. Is ...
1
vote
3answers
50 views
Excel: How to show top 3 “winners” by age and gender?
I'd like to use Excel to manage the data for a marathon. The marathon groups winners by age and gender into a category, and awards prizes for first to third place in each category.
Can Excel be used ...
2
votes
1answer
27 views
Attendence Points Rollover
I have an attendance worksheet where we calculate employee attendance based on points, if employee absent they get 1 point and if tardy or did not complete shift get 1/2 points also if employee has ...
0
votes
1answer
29 views
Functions (specifically text functions) within a countif function
Is there any way to nest text operators within a countif?
I want to check if the first 4 characters of a file are in the form A**.
=Countif(Left(A1,4),"A??.") doesn't work, but I can put in a
...
0
votes
1answer
20 views
Monthly Pivot Tables In an Annual Report
I was given 12 tables of purchase orders (one for each month) that my school has made and was asked to create an annual report listing purchases for each month which is pretty simple.
The thing is ...