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)

1
vote
2answers
29 views

Excel Spreadsheet sheet formulas

I would like to be able to have a cell in a 2nd tab equal what was in a previous tab, then create a new tab, copy and paste and have the spreadsheet formula update to the previous tab instead of ...
0
votes
2answers
6k views

Copy drop down list from excel 2007

How can i copy a entire drop down list from excel 2007 one document to another excel document, i have tried copying and pasting special, some forms told me to copy it through data validation process ...
0
votes
1answer
4k views

Call PowerShell script from Excel macro

I'm trying to call a PowerShell script from a macro in Excel. I have seen a number of examples along the lines of: retval = Shell("powershell ""C:\MyTest.ps1""", 1) When I try to use this, ...
1
vote
2answers
12 views

Concatenate cells but exclude empties in Excel

I am wondering how I can concatenate a row of cells with comma separated values but exclude empty cells. For Example the list would be: A1 - Dog B1 - "empty cell" C1 - Cat I am looking for a ...
2
votes
2answers
20 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 ...
1
vote
2answers
44 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 ...
0
votes
1answer
19 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 non-linear) from the raw data? Or do I have to graph the data and use the ...
-2
votes
0answers
17 views

Excel: Find duplicates among 2 colums [on hold]

Giving an excel file with 2 columns: A: 5000 numbers (some repeated) B: 100 numbers I want to know if for each number in A there is a instace of that number in B. Meaning: for A1, is it anywhere in ...
1
vote
1answer
16 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
1answer
15 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
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.
0
votes
0answers
21 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
16 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 ...
7
votes
4answers
18k views

Using find() in Excel to remove text from string

I'm using find to remove some of the test string in lookup cell value For instance I look-up the following in cell A2 Application: sales_rep_support and use find =RIGHT(a2,FIND(" ",a2)+4) to change ...
-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
1answer
55 views

How can I resolve a Zwick TestExport Error Exporting to Excel?

I am running a Zwick TestExpert program. When exporting data from a file to Word, this will produce the file fine. However when exporting to Excel, I get the message as follows: testExpert ...
0
votes
1answer
646 views

Excel 2003 “SHIFT+Copy” functionality - where is it in 2010?

i use the 2003 "SHIFT+Copy" function very frequently - eg every monthly. I have thus far been unable to find it anywhere in 2010 and have spent about 10 minutes searching MS on line. Does anyone ...
1
vote
1answer
2k views

Unable to insert rows or columns in Excel 2013

I'm using Office 2013 on Windows 7. Few times, I have not been able to insert rows / columns in a some of the Excel spreadsheets. I tried the following before searching on the internet. Use ...
0
votes
1answer
4k views

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
0
votes
3answers
1k views

Excel: How to print unique pages with only one sheet

I am trying to create a template in MS Excel to print similar pages but with an unique ID within each printed pages (e.g. ID: 001, 002 and so forth) but printing from one sheet only. I am creating ...
0
votes
1answer
24 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
19 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
25 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
11 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
3answers
25 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
0
votes
1answer
15 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 ...
0
votes
2answers
4k views

Excel - how to either have direct data input or cell value from formula

I would like to either populate a cell value from direct key input or have the cell value derived from a formula. Example: either directly input a number into cell A4 or have the value for A4 = A2 + ...
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. ...
1
vote
1answer
21 views

How to create stacked chart

I go nuts at Excel. So here's my problem: I have a table where the Y-values are projects that we are working on in that year on the x-values 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
15 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
24 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
51 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 ...
-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 sub-totalled in row 6. The dates start from G1 and the date increases in the next column to the right. Currently ...
0
votes
1answer
25 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
vote
1answer
464 views

Transform single column to multiple columns based on values

I have 1 column like below: AAA 999888 BBB 1111 BBB 2222 AAA 999777 BBB 3333 AAA 999666 BBB 4444 CCC Doit ... Consider above up to a few thousand rows. I want to convert it to below 3 column table ...
2
votes
1answer
5k views

COUNTIFS over multiple worksheets

I am trying to make COUNTIFS go across two worksheets in the same excel file (Final Driver Forecast Model), just on different tabs. I need it to count if a driver returns between a certain time, then ...
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 ...
0
votes
1answer
26k views

Find matching value in a row and return column name?

I have a sample price and I want to find the company that offers the lowest or an equal price to that sample price in the same row and put their name in the "Company Name" column. I tried to use IF to ...
3
votes
3answers
19k views

Printers not visible in Microsoft Excel

When in MS Word or PowerPoint, when I go to File → Print, I can see all the printers. But when I do the same thing in Excel, no printers are installed. Yet I can use the Ctrl-P shortcut keys and ...
2
votes
4answers
16k views

Find alike data in two worksheets and put in 3rd worksheet

What is the best/easiest way to combine data from two different Excel spreadsheets into a third Excel spreadsheet? Spreadsheet 1 will have the username only. Spreadsheet 2 would have lots of ...
-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)
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 ...
2
votes
2answers
48 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 ...
0
votes
1answer
4k views

How to customize Paste Value Excel Short Cut

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code. I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...
1
vote
2answers
2k views

How to conditional count in excel?

I have a table like below: Q: How can I count all Female Undergraduate or Male Diploma ?