# Tagged Questions

**-2**

votes

**1**answer

15 views

### How can I embed file into an excel spreadsheet cell?

Does anyone know of a way to embed a PDF, JPG, Word file, or Outlook email into an Excel cell?
I am entering data into cells and want to link them to specific documents and to save them getting lost.
...

**-1**

votes

**1**answer

19 views

### Can't insert current date and time into Excel 2013

Ctrl ; is not working to insert the current date and time into Excel 2013.
How can I fix that?

**-1**

votes

**0**answers

21 views

### Setting up Monthly Payments in an Excel Spreadsheet

I made a basic checkbook-type spreadsheet, using three columns for +.-.= but couldn't figure out how to make it so something is added to the - column every month, preferably by itself. If it can't be ...

**-1**

votes

**1**answer

23 views

### How to “draw” a square grid on excel?

How can I find the relation between width (of the columns) and height (of the lines) in the excel grid?
I need to draw a simple diagram and I need to do it on excel

**0**

votes

**0**answers

13 views

### Comparing data on Excel 2013 and removing excess

I am using Excel 2013. I have one worksheet (called A) with 2150 rows and 10 or so columns. I also have another worksheet (called B) with 1400 rows with 4 columns. In column A, the data is the same ...

**0**

votes

**1**answer

14 views

### Macro in Excel to add the date in ISO-8601 format

For some reason, Excel forces me to use my region for footers when I insert the date. However, it also doesn't auto update when the worksheet opens. Without the formatting this is a rather trivial ...

**0**

votes

**1**answer

11 views

### How to add up Column B based on whether Column A is a duplicate value?

I have two columns, one with names and the other filled with '1'. Column A has many duplicates in it - this is intended - what I need is a formula to add the 1s in Column B if the corresponding values ...

**0**

votes

**1**answer

9 views

### How to make a Custom List with sheet cross reference?

At the end of the month i get a excel file with a variable number of sheets.
Every sheet has a value in the same cell: A1
I want to create a new sheet and display all the values of A1 on every sheet ...

**0**

votes

**1**answer

20 views

### Calculate the year-year Growth

Assuming i have a short income statement for the next 12 months.
Now I want to create another table, for the first three years, something like this
x Year 1 | Year 2 | Year 3
...

**-1**

votes

**0**answers

12 views

### Displaying data from another tab

I run a daily report where I need to display errors on a roster of our associates. I have one tab ('Roster') with the complete roster and a formula that checks to make sure that the shifts are correct ...

**1**

vote

**1**answer

21 views

### COUNTIFS for multiple criteria across multiple sheets

Help guys!
I'm trying to come up with a very short formula to compute for multiple data across multiple sheets.
I have one workbook wherein I compile error reports I receive from several people. The ...

**0**

votes

**1**answer

18 views

### Matching and returning values to populate column

I have a workbook (Excel 2007) with two sheets. Sheet1 has more than 8,000 employees and their associated unit numbers, which is a 6-digit ID. I am trying to populate Sheet1!C:C with a corresponding ...

**-2**

votes

**0**answers

19 views

### Zero points of a chart in Excel [on hold]

I ploted a chart in a specified interval. After that I have to count zero points in this interval. Are there any general solutions, methods for this?

**1**

vote

**1**answer

15 views

### Excel table not formatting new rows appropriately - where does formatting come from?

I have an excel table and all rows are formatted the same. When I add a new row, the formatting does not match the rows above - so every time I add a row I have to select the above row and copy/paste ...

**26**

votes

**2**answers

1k views

### What does “A1:A4^{1,2,3}” mean in an Excel formula?

What does the caret operand in Excel do to a range when it is followed by some other numbers in brackets? For example lets say we have the following table:
A B C
1 1.5 0 0
2 ...

**0**

votes

**1**answer

18 views

### Excel Dates Transformation

How do I change the dates in Excel for the below scenario:
Existing dates:
2/2/2014
3/12/2014
1/1/2015
2/1/2015
Target converted dates:
3/31/2016
3/31/2016
1/1/2016
2/1/2016
I want all the dates ...

**0**

votes

**0**answers

4 views

### Excel chart doesn't show 'value' on hover

I have a combination chart on Excel 2013. It has both lines and stacked areas. When I hover over the lines, it shows all relevant information ('series', 'point' and 'value') of the data point.
When ...

**0**

votes

**2**answers

32 views

### How can I resolved Performance issues with Excel 2013?

I'm using a dell E6440 laptop with Core i5 CPU and 64-bit windows 7. I'm running Excel 2013. I do a lot of reporting through Excel and of recent I've noticed reduced performance - choppy mouse ...

**0**

votes

**0**answers

11 views

### Undesired Locked cells on OSX Excel 2011 (but not in 2010 Win7)

I have an Excel-document where in most of the sheets are locked, and only few cells are available for editing. I don't have the password for the document as I am not supposed to edit anything in the ...

**-1**

votes

**0**answers

17 views

### Allocating unique number to duplicate values

I have a list of codes in a column that have some repetition. I can remember using an IF statement a few years ago to identify the series of repetition. For example I need a formula that will return ...

**0**

votes

**1**answer

16 views

### How do I copy a Function to select columns in an entire spreadsheet

I have an inventory report and the rows go by item and the columns go like this:
Inventory - Stock Shipped Out - Inventory - Stock Shipped Out ect.
I want each items Inventory figure to be the sum of ...

**0**

votes

**1**answer

21 views

### Format row that is different than the preceding VISIBLE row

I have an Excel sheet as a database, where each row has a category, and are always sorted by category.
Category Item
1 AAA jjj
2 AAA kkk
3 AAA lll
4 ...

**0**

votes

**1**answer

23 views

### “Open as Read-Only” but workbook still opens as writeable

When I press Shift+Right-click when clicking on a workbook's filename, I get the "Open as Read-Only" option in the context menu, but when I click this option and the workbook opens, it's in read/write ...

**0**

votes

**3**answers

25 views

### Excel function determine if a cell is visible

In conditional formatting I want to detect if the row above the current cell is hidden or visible. How can I detect if a cell is visible or not?
The only hack I can think of is:
Create a column ...

**0**

votes

**2**answers

14 views

### Concatenating multiple URLs to create new page URLs in Excel

I pasted the following URLs into a spreadsheet:
https://www.kickstarter.com/discover/advanced?google_chrome_workaround&page=1&category_id=9&sort=magic
...

**-2**

votes

**3**answers

64 views

### How to fix the #DIV/0! error in an Excel document as a whole?

I've seen instructions on how to get rid of the #DIV/0! error on a single cell, but I'm looking for the easiest way to deal with all errors at once in the whole document.
The reason for that is the ...

**0**

votes

**0**answers

10 views

### Find a specific name in a column, bring in the value in the corresponding row, in the column I designate in another worksheet

So I have a worksheet that people will go into and put their name down to sign up for a meeting for a specific date. In a separate sheet, I have their names and I manually input the days they signed ...

**0**

votes

**1**answer

14 views

### Automated Excel Sheet Import from Downloaded Spreadsheet

At work we have a data storage system where we keep information about equipment we've ordered. I want to take select columns from this data and put them in another sheet that is already formatted with ...

**0**

votes

**1**answer

21 views

### How to have different numbers on separate cells and still have 100% in one cell on Excel? [on hold]

I have 38hrs in B4 and as soon as I put 38 hrs it automatically shows 100% in cell D10. Now I was either cell B12 or B18 to add to cell B4 so it will equals 100% in cell D10. Example: I have 33hrs in ...

**2**

votes

**1**answer

18 views

### Excel Filter and join between multiple tables

I'm reasonable user of Excel (definitely not very skilled though) - I'm using Excel 2013.
I'd like some assistance on how to achieve what I need on table controls. I've created three tables.
...

**-1**

votes

**0**answers

20 views

### Modify Excel data connection without disconnecting the connection file

When I link a data connection file to a workbook, and then edit the SQL query (to include dynamic parameters), Excel says:
The connection in this workbook will no longer be identical to the ...

**-3**

votes

**0**answers

40 views

### Insert data between commas in a cell in CSV [on hold]

Say I have 23 names in Column A, like this: jimmy.jpg,fred.jpg,pam.jpg.brian.jpg. They are in a single cell, with a comma after each name.
I need to insert 3 names between fred.jpg and pam.jpg, with ...

**1**

vote

**2**answers

27 views

### Why is Outlook 2010 Changing my Embedded Spreadsheet to a GIF? [on hold]

Years ago I figured out how to embed a spreadsheet in an Outlook email to automate a task I do regularly. Whenever I want to send a new quote request I open an old email, tell Outlook I want to ...

**0**

votes

**0**answers

19 views

### How to insert a row into an Excel sheet1 and automatically insert the row into sheet2 [duplicate]

I have the following table in sheet-1 (master table) from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main ...

**2**

votes

**1**answer

22 views

### Tricky cross table excel function

I'm trying to set up a table column in excel to check for matching names between the name columns of both tables, then return the total from the second table.
Currently this works, but I can't sort ...

**0**

votes

**0**answers

17 views

### Formula or function to change part of a text string color not using conditional formating

I have a shape I am using to highlight text. The text is using a formula to get a set of text from the spreadsheet . I need a single word to be a different color than the rest of the text string. ...

**0**

votes

**0**answers

8 views

### How to combine two columns with associated data?

for my term paper i have to compare several algorithms to compute pi, i wrote scripts that use certain algorithms that i want to test, that give me an excel file as output. The excel file contains ...

**0**

votes

**1**answer

38 views

### SUM IF FREQUENCY MATCH

I'm trying to add another criteria for the below formula. On the Payroll Data tab I have column H that has hours in it, some of those hours may be negative so I don't it to count those rows with ...

**0**

votes

**1**answer

16 views

### IF AND conditional formatting not working - Excel 2013

Okay so I’m trying to format cells that are blank and meet the logical test. Here’s the formula:
=IF(AND($B2="Y", ISBLANK($C$2:$F$172)), TRUE, FALSE)
If both tests are true (B column = Y and there ...

**-1**

votes

**0**answers

13 views

### How to match donor data from year to year (ID Number and Associated Data)

I need to compare donor data from year to year and need to align them on a spreadsheet. For example, now I have the following:
Column A- shows 2013 Donors ...

**0**

votes

**0**answers

12 views

### Task Schedule excel file with ODBC/Oracle connection

I am having problem running an excel file with ODBC connection for Oracle to run via Windows-7 Task Scheduler. It will just say running.
What the excle file does.
After I open the file, it will ...

**-2**

votes

**1**answer

34 views

### How to multiply rows in Excel based on a variable? [on hold]

last week I found a macro solving my problem, but I seem to have lost the code and cannot find it anywhere anymore.
My problem is the following:
I have table with names and their variables:
Peter ...

**1**

vote

**2**answers

33 views

### Excel Convert the correct Date type

I'm currently following the date type dd/mm/yyyy i need to have another row showing the month in mmm type. E.g. From 13/09/2014 to SEP
My formula is =Text(A2, "mmm") which is the correct formula,
...

**2**

votes

**1**answer

139 views

### Select all cells in a row

How can I select all cells in a row in Excel / Google Spreadsheet?
I know I can select all cells in a column using
A:A
But how can I select all cells in a row?
This doesn't work:
1:1 // select ...

**0**

votes

**1**answer

19 views

### Plotting data in excel grouped by type

Take a look at:
I made this manually. Basically, I plotted a normal bar graph, where all bars were blue color.
I want to get all bars of same type to be represented with unique color (Type 1 - ...

**0**

votes

**3**answers

26 views

### How to lookup a value within a range

I need a formula to calculate values from slab Ranges.
for example
columnA columnB
1-10 A
11-20 B
21-30 C
31-40 D
41-50 E
51-60 F
61-70 G
71-80 H
81-90 ...

**0**

votes

**1**answer

28 views

### Macro to copy distinct values from one Excel sheet to another

I have an Excel workbook that has the following sheets, "Main" and "Count":
Now the "Main" sheet has the column B with list of IDs.
Is it possible to have a macro on "Count" page to copy all ...

**0**

votes

**0**answers

9 views

### Word mail merge and page breaks

Looking for a way to put a page break after a number of rows in an Excel data source for mail merge in Word - the number of rows before the page break can vary, depending on he number of records that ...

**0**

votes

**0**answers

10 views

### equivalent of Crtl+Apostrophe in google docs [migrated]

In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of ...

**0**

votes

**0**answers

23 views

### Prevent Excel from changing formula of last row of table when adding a new row

I have a table with columns named "date", "cost" and "daily". "Date" is a date, "cost" is a number and "daily" is a formula calculating the total cost of each day. The formula looks like this:
...