**1**

vote

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**4**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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 ?