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
Combining the ISBLANK and Date function
I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function.
What I need to do is use this formula in google sheets for ...
0
votes
0answers
9 views
How to find trendline without graphing
I have set of data in Excel for which I would like to find the trendline. Is there a way to find the trendline (linear and nonlinear) from the raw data? Or do I have to graph the data and use the ...
1
vote
1answer
6 views
Remove duplicate rows, and keep newest row based on date column
I have a huge list of data in excel (250.000+ rows) in the following format:
Number Value1 Date Value2
40325 1 21/01/11 18.10 2
65485 3 22/01/11 16.47 2
40325 9 ...
0
votes
0answers
10 views
Add missing data in excel based on available row values
I there a way to fill row values based on a prediction of the available data? This what I have:
Crop Year,Avg Planting,Loss Avg
2015,11/2/2015,12/15/2015
2014,11/4/2015,11/9/2015
...
2
votes
1answer
11 views
Convert multiple unicode values to corresponding text in Excel spreadsheet
If my Unicode character contains more than one hex value in an Excel cell, how do I write a function in Excel to convert it into the corresponding character?
For example:
Unicode Hex values in Excel ...
1
vote
1answer
35 views
Excel  Manipulating data in awkward format
I have a dataset that I want to analyse, but it is in quite a strange format. See below:
> Account_Details Account_Name
> account # 1 client name
> product 1 name ...
2
votes
1answer
17 views
Hide data label containing series name if value is zero
I have made a chart in excel in which I would like to hide the data label if value is zero. For data labels that contain the value itself this is done by using custom formating as explained here How ...
0
votes
1answer
23 views
In excel, I want the word “Name” to display but not print
I have a census sheet in excel that has to list peoples name in a specified area. There are a set number of rooms that can contain people, but they are not all full at all times. I would like to have ...
1
vote
1answer
24 views
How do you create a conditional nesting formula on excel 2010 with more than 3 conditions?
I have "A, B, C and D." I need " if a>0, use a, otherwise, use b. If b has the error "#N/A", use c, otherwise use b. If c=0, use d/61, otherwise use c.
So far, I have this:
...
1
vote
1answer
10 views
Cell references in formulas keep moving with old data in Excel
When I update Excel to the latest figures my formulas keep moving with the old data. I have already tried using absolute and or relative references like $A$1, $A1, A$1, and A1. I've also tried using ...
0
votes
1answer
12 views
I have an Excel file with a worksheet that is completely white and on interactive. It's also not protected. How do I acces it?
I am working on a rather complex Excel file that has various Database connections and VBA code behind it. This file is getting pretty old and has had many people work on it during its life.
There is ...
0
votes
1answer
10 views
Excel Mac (Office 11): Sum cells within a row that meet heading criteria
I am trying to create a formula that will sum cells in a row for those cells with column headings (number 1 to...n) that fall within a range, say 2 to 4 or 3 to 9. The critera for the column ...
0
votes
2answers
20 views
Is there a way in Excel to have a formula stretch its row extent to include adjacent inserted rows?
In Microsoft Excel 2011 for Mac OS X, I have several columns of numerical figures and a final row at the bottom that shows a maximum value for each column. My data set is ordered, such that most ...
2
votes
1answer
58 views
Need a formula for Leap Year
I need a formula by which I can find by entering a date whether that financial year has a leap year or not. Let's say if I entered date as 03/01/2015 then it should be consider a Leap Year as ...
0
votes
0answers
17 views
Excel 2010 Macro throws Object or Method Not Supported error
I keep getting an error 438: Object doesn't support this property or method when trying to run a portion of a macro I have that updates three PivotCharts off of the top three items on another table.
...
0
votes
3answers
24 views
Filter only rows with 0 value in multiple columns
I am trying to filter rows only if they contain 0 in multiple columns  I want to delete the rows. eg only rows where value is 0 in all columns E,F,G,H
1
vote
1answer
20 views
How to create stacked chart
I go nuts at Excel. So here's my problem: I have a table where the Yvalues are projects that we are working on in that year on the xvalues are project related properties. On of those properties is ...
1
vote
2answers
130 views
How to get Ctrl+Shift combination for Excel macro shortcut?
When I click "Record Macro", the record macro window only shows Ctrl + another key as the shortcut key. As we all know, most of the Ctrl+ are used by Windows and Excel for other important functions ...
2
votes
0answers
14 views
Excel Function  Convert unicode to ascii [on hold]
I'm trying to figure out if there is any function in excel (2010) which helps
decoding the text unicode to ascii?
I have one column in my sheet which contains word/sentences in Portuguese
For ...
1
vote
1answer
23 views
Excel to show icon
I want to have icons that will signify increase, decrease or equal from the prior cell.
For example below in C2, the icon should increase when compared to B2 (because its value is greater). The ...
2
votes
1answer
14 views
How to hide page break lines in Page Layout view in Excel
I have a work sheet which I need to look at in the Page Layout View, however, in that view the page breaks show as dotted lines along the outer border.
I have read this question, and the answer works ...
2
votes
0answers
43 views
Excel 2010 scrollbar goes too far
My problem is illustrated in the PrintScreen below:
I've searched a lot on the Internet and almost all sources say to delete the empty rows at the end of the sheet and save the document. For ...
0
votes
1answer
25 views
Apply Names in Excel is bugged?
I see people had this problem 10 year ago and it's still not fixed. Or maybe I just don't know how to use this feature.
In my sheet I have these named ranges:
A1  "name1"
B1  "name2"
C1  "name3"
...
3
votes
2answers
25 views
How to format text between branches excel using a macro Excel 2010
I found a little macro to change all the text between "[" and "]" red in excel.
But i can't get it to work in Excel 2010, i get some errors.
Can someone help me debug this?
At the end i wish that in ...
1
votes
1answer
12 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)
0
votes
1answer
13 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
60 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
23 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 ...
1
vote
1answer
17 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
56 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
22 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
29 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
42 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
13 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
14 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
1answer
24 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
23 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
14 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
19 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
47 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 [closed]
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
17 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
1answer
31 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
33 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
25 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
21 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
36 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
19 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
53 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 ...