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

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
0
votes
1answer
18 views

Excel formula to compare single value in one cell with multiple values in other cell

I have a value in Column A, which I want to compare with multiple values of corresponding cell in column B, and depending on that value, put the answer in column C. For example, using the table ...
0
votes
1answer
16 views

Excel macro to save workbook on another session of excel

Im trying to make a macro in one session of excel that saves a particular workbook in another session of excel. Lets say i have Workbook1 and Workbook2 and i have opened them in different excel ...
0
votes
1answer
11 views

How to move the y axis to the left in excel , scatter plot with x-axis log scale?

I have my scatter plot with x-axis log scale like below: I want the position of y-axis moved to the left. How can I do this?
0
votes
1answer
30 views

Populate default value to a cell based on another cell content

We use a spreadsheet as our time cards. The template is stored in a server with links to it on the individual's desktops. I am trying to figure out VB code that would help in achieving the flliwing: ...
0
votes
1answer
17 views

Comparing two strings in excel, add value for common variables

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains ...
-1
votes
1answer
21 views

How can I populate other columns after user selects choice in drop-down?

I have a spreadsheet that is essentially going to be a form for our user to print out and hand to the necessary individuals. What the user needs to be able to do is select a customer number from a ...
0
votes
0answers
15 views

Is it possible to insert multiple objects at once in Excel 2007?

My co-worker keeps a spreadsheet of candidate data, which includes the resume of each candidate inserted as an object. How can we insert multiple objects (resumes) at one time, instead of going ...
-2
votes
1answer
22 views

How to assign a unique number per group of entries in a column?

I have a list of part numbers in Column A and a location in Column S. I need to assign a value of 1 for all part numbers that are the same (A3-A16), then change to a value of 2 when the part number ...
1
vote
3answers
38 views

IF formula returns wrong value

https://www.dropbox.com/s/v6nd2z4icftmnvf/example1.xlsx We have Excel 2007 (German) and vista ultimate. I am trying Excel by building a roster but have run into a problem with the following formula. ...
0
votes
1answer
16 views

Excel shows different files in same window

In Firefox, I downloaded an Excel spreadsheet and it displayed a dialog box asking what to do with it, so I selected "Open in Excel". Then I downloaded another Excel spreadsheet and opened that one ...
0
votes
0answers
16 views

Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data: -0.0892 8 -0.0711 16 -0.0529 19 -0.0348 13 -0.0166 5 0.0015 12 0.0197 5 0.0378 5 0.0560 3 0.0741 4 0.0923 5 0.1104 1 I would like to add a ...
0
votes
2answers
30 views

SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for. On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...
-2
votes
1answer
36 views

Randomize Huge List - Windows 7

i've been searching for a solution for this but i couldn't find it anywhere. I have a large list, more than 2 million entries. I need to randomize it. I can randomize lists in excel but excel ...
1
vote
1answer
14 views

Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...
0
votes
1answer
18 views

Nvidia How to display particular workbook of Excel file on TV and no matter what i do on the computer the TV displays the workbook

Basically i have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when i work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I ...
0
votes
1answer
14 views

I want to create a format in Excel to trigger a colour code?

Currently I have a drop down list on certain cells, connected to a list of statuses. 'Complete' which marks as green, 'Pending' which marks as orange, 'Outstanding' which marks as Red. I want each ...
0
votes
1answer
12 views

Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...
0
votes
1answer
24 views

Cell in a cell excel 2013

Is it possible to insert a cell in a cell? I need to divide a cell in half horizontally. I don't want to have to insert another row as I would like it to be horizontal. Can this be done?
0
votes
3answers
37 views

Average Difference and Direction Between Values in Excel with Blanks

I have a sheet that looks something like this: Sheet 1 1 2 3 4 5 6 7 8 9 10 11 1 6 2 3 5 3 ...
0
votes
1answer
16 views

Named ranges changing randomly in Excel 2010

I'm trying to create some named ranges in Excel that extend using the offset function based on the number of non-empty cells in a column, with the general formula: ...
1
vote
0answers
21 views

What can slow down Excel in copying worksheets, but doesn't slow down general responsiveness?

I've got a fairly complex workbook that I'm building, and it looks like it's going to need a number of the sheets copied 10-20 times over - where each copy operation takes ~45s at the moment (over ...
0
votes
0answers
14 views

Open Excel on last modified page

I have a spreadsheet with 13 pages. Theoretically, when I open it, then modify it, it SHOULD next open on the page I most recently modified. It does not. It's opening on a page that hasn't been ...
1
vote
1answer
51 views

Excel Pivot Table - Average per day

I have a table of data Date Item Quantity Operator 01/01/2014 Item1 3 John 02/01/2014 Item1 7 Bob 02/01/2014 Item2 4 John 03/01/2014 Item1 2 ...
-1
votes
1answer
22 views

Excel: Shortcut key to move selection to specific row

I am creating a bot where I need to move the selection (cursor) to a specific row, like row 1, or row 5. Does such shortcut feature exist or is it possible to create it? Alternatively, does ...
0
votes
0answers
16 views

Select item from drop down menu and run macro

I have a drop down list in a sheet called 'Report', cell B9. The source for this list is in another sheet in the same workbook, 'List' with range 'A1:A32'. When the different items in this list are ...
0
votes
0answers
15 views

Prevent 'Run-time error '7' out of memory' error in Excel when using macro

I keep getting this error whenever I run a macro in my excel file. Is there any way I can prevent this? My code is below. Debugging highlights the following line as the issue: ...
0
votes
0answers
11 views

highlight lines of text in text box based on selected flowchart item

I have a simple flowchart, and next to it I would like to place a textbox containing more detailed information on that chart. Is it possible to have an area of the text highlighted when a flowchart ...
0
votes
0answers
9 views

Excel Formula Bar Display

Is there a way to make the formula bar in MS Excel display the input formula in a way similar to most coded languages with multiple lines and indents? I've only ever dabbled in Excel for very basic ...
0
votes
0answers
25 views

Excel consuming absurd amount of memmory

I have a excel file consuming a huge amount of memmory, something ~500mb. The file contains only one sheet, no images or scripts and its size is only 719kb. I have checked all suggested solutions ...
0
votes
2answers
22 views

Excel 2010 Data Connection - Add Filter to Command Text

Two relevant workbooks: Historical Data.xlsx with a table GLDATA, which includes a field cc Template.xlsx with a named range COSTCENTER Question: How do I modify the Command Text in the Data ...
1
vote
0answers
17 views

Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...
0
votes
1answer
19 views

Excel 2010- Document Contents Not Scrolling with Scrollbar

For some reason on a couple of computers, Excel 2010 is having issue with the scrollbar. When the vertical scrollbar is dragged, the contents of the page do not follow (for example, as they do in a ...
1
vote
0answers
18 views

Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following: 48.8 4.19 (0.36) 4.52% and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...
1
vote
1answer
21 views

VBA + Polymorphism: Override worksheet functions from 3rd party

my company makes extensive use of a data provider using a (closed source) VBA plugin. In principal, every query follows follows a certain structure: Fill one cell with a formula, where arguments to ...
2
votes
1answer
21 views

Create a linear trend line in Excel graphs with logarithmic scale

I I have an Excel scatter chart with x and y values. I set the logarithmic scale in x-axis and y-axis. When I add a linear trend line to the graph, the line is not linear but appears like a curve. ...
0
votes
0answers
28 views

Update conditional formatting cell references when conditional formatting is applied to new cell

I am applying conditional formatting to cells on my spreadsheet, using the following formula in cell C6: =INDEX('All Time'!$F$2:$F$550,MATCH(INDEX('All Time'!**$A$7**:$A$550,MATCH("*",'All ...
0
votes
0answers
22 views

Macro to copy values to new sheet and prompt user where they want to save

I'm looking to create a macro in Excel 2007 which will do the following: copy the formatting and values from a sheet called 'report', insert this into a new workbook, naming the file with the value ...
1
vote
0answers
18 views

Is that possible to have a Shamsi (persian) Calendar in Windows? What about Microsoft Office

Is there any solution for replacing the current Georgian Calendar of Microsoft Windows with Shamsi (Persian) Calendar? Although, Microsoft Excel and other packages of Microsoft Office must recognize ...
0
votes
3answers
31 views

Excel - how to rank based on number of occurences?

I have an excel sheet with one column with text strings. I would like to transfer it to a two column sheet where each line appears once and its count in the 2nd column. Ordered by descending count ...
0
votes
1answer
23 views

Excel VBA Insert Character Between Number and Letter

I would like some VBA code that would allow me to detect if a string contains any instances of a number followed by a letter and then insert a new character between them. For example: User enters the ...
1
vote
0answers
13 views

Excel table column validation next row

I made a table with first column formatted to DATE. In the first row I entered the date manually. In SECOND column I entered validation of date >= previous date. I copied this table 8 times. In 5 ...
0
votes
0answers
19 views

Auto Updating Month Over Month and Year Over Year formulas

I have a spreadsheet that has several different sheets (Visitors, Buyers, Conversion Rate, GMS). Each sheet has the data on that statistic monthly from 2013 onward. So sheet 1 shows monthly visitors ...
0
votes
2answers
23 views

Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value

I have rows of possible duplicate employee ID #'s, with another column of different values for the same person. I need a single column of unique ID's with the certifications transposed in the same ...
1
vote
2answers
28 views

summing up numbers when criteria match

I have a range of long dates from Sep 2014 till Dec 2018, and for each month I have an amount. I want to sum up the data of each year in one cell. Example: 2014 : sum of all amounts that are in ...
0
votes
1answer
28 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
2
votes
2answers
46 views

Creating folders and sub-folders with a VBA macro

I'm looking to use a spreadsheet I've created to generate folders and sub-folders based on what is in each column. The first column is the top level, the second column the next level down ...
1
vote
1answer
21 views

Keeping Microsoft from auto starting on Mac

Whenever I start up my Mac Mini (running OS Mavericks) or Macbook Air (OS 10.9), I have to wait while Word and Excel automatically load and open. I've tried stopping this from happening via system ...
-3
votes
1answer
27 views

Different rows in to different columns(special case)

I have a excel sheet that contains hundreds of data like this.. Name 1 Name 2 Name 3 Name 4 A Aa Aaa Aaa Name 5 Name 6 Name 7 Name 8 B Bb Bbb Bbbb I need to ...
-2
votes
1answer
30 views

Two lists of same figures showing different totals

Have two columns of the same numbers like for like but when you add one column up manually and the other auto sum and using sum function - it gives a different figure. Can anyone advise as to what ...