**0**

votes

**0**answers

7 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

**1**answer

7 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

**1**answer

20 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

**3**answers

26 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

**1**answer

14 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

**0**answers

16 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

**0**answers

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

**1**answer

38 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

**1**answer

20 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

**0**answers

12 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

**0**answers

14 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

**0**answers

10 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

**0**answers

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

**0**answers

17 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

**2**answers

17 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

**0**answers

16 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

**1**answer

18 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

**0**answers

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

**1**answer

18 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

**1**answer

14 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

**0**answers

25 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

**0**answers

20 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

**0**answers

17 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

**3**answers

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

**1**answer

20 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

**0**answers

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

**0**answers

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

**2**answers

22 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

**2**answers

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

**1**answer

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

**2**answers

36 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

**1**answer

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

**1**answer

26 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

**1**answer

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 ...

**1**

vote

**1**answer

11 views

### Excel for Mac - references in formula toolbar

My formula toolbar displays wrong - instead of for example showing in the cell where the formula is entered (A1 in this case ) =+B1+C1 it is almost like it is directing - it shows =+R1+R2. So ...

**0**

votes

**1**answer

24 views

### Finding most repeated names

I have multiple lists ranking people. I have put them in an excel spreadsheet, each list occupying 1 column
A=washington Post
B=Yahoo
C=Fox
D=NFL.com
These lists are ranking the same individuals, ...

**0**

votes

**2**answers

20 views

### Subtract a value from previous cell with sum and offset function

In Excel, I have a column with different values.
In this column, I want to subtract the value in A1 from the value in A2, the value in A3 from A4 and so on. I then want the result to show in the B ...

**0**

votes

**1**answer

20 views

### Excel: how to link cell from one sheet to another

could you please, help me?
i would like to find out how to do this:
i have a sheet 1: with columns: number, name, color.
i would like on sheet 2 to have 3 cells, where after entering the number, two ...

**1**

vote

**0**answers

12 views

### run-time error 1004 Application Defined or object-define error

I have this macro that I wrote:
Dim lastColumn As Long
lastColumns = wkbWorkbook2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'this is the highlighted part in debug
SourceRange.Copy
...

**1**

vote

**0**answers

17 views

### MS Excel 2013 Basic Help, While Offline, Not Responding

Until about a week ago I could get basic help in Excel 2013. I could search for something like "text functions" and got links to those pages. Now I get no response at all after pressing enter or the ...

**0**

votes

**0**answers

8 views

### How to enable excel-style table headers in Numbers in Mac?

I'm used to using excel for wading through large data sets using the "table headers" feature, which looks like this:
How to do something similar on a mac using iWork's Numbers?

**0**

votes

**1**answer

24 views

### Excel 2010 vlookup formula - Using variable table array as input

I been trying to find out if its possible to automatically expand the table_array on this VLOOKUP formula:
=VLOOKUP(B2,Sheet2!$F$4:$G$965,2,FALSE)
I'm calling the values from Sheet2 to add into a ...

**0**

votes

**1**answer

20 views

### Get data from another Excel file

I have an Excel spreadsheet that contains a list of usernames
Each user will have the following code. I just need to find a way to substitute First.Last with the names in the Excel spreadsheet. There ...

**0**

votes

**1**answer

14 views

### EXCEL Sum amount based on matching order numbers in another column

I am working on a spreadsheet to track our general ledger account for inventory in transit. There is a debit to the account when the order is shipped and a credit when it is received. Column C is ...

**1**

vote

**1**answer

23 views

### How to omit returning the rows for “false” values

I have a worksheet with multiple tabs. The first tab is the master sheet and columns A-G contain identifying data. In the second tab I have created a formula to return the value in column A of the ...

**0**

votes

**0**answers

29 views

### If Blank is Greater than 10% of Blank - Need Formula

I'm having trouble figuring out a formula. I need to find out if the number in Cell B is greater than 10% of the number in cell A. If it is, I want Cell C to say Yes.

**1**

vote

**1**answer

18 views

### Excel Error Bars From Pivot Table

When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...

**-1**

votes

**2**answers

33 views

### Excel Macro Sum of a Row

Sum of row, stop when the first result is positive. The rest of the row values will be converted/replaced with 0, and the last with positive result will have the final sum.
Eg.
Row A1:F1 = -2, -3, ...

**-1**

votes

**1**answer

24 views

### Excel: Averaging Sensor Data by Time Stamp

I have a device that collects temperature measurements from several sensors at discreet time intervals. This data is dumped into a .csv file with each row formatted as: [time] [sensor name] ...

**0**

votes

**1**answer

17 views

### How can I use COUNTIF and TODAY functions to identify work deadlines in multiple worksheets?

I've been playing with our spreadsheets at work and have been able to create a basic formula that will identify when there is a deadline on today's date that needs completing. The issue I now have ...