# Tagged Questions

**1**

vote

**1**answer

12 views

### Show timestamp when cell is changed

I need to know how to show a timestamp in a cell in column D when a cell changes in that same row in column B. I edited this screenshot in paint to show what I mean more easily:
The image
I have a ...

**0**

votes

**0**answers

2 views

### Using arrayformula in google sheets to copy down

I have read all the other questions that show this being used and I ether get errors when I plug this in, or it copies everything from the first row all the way down.
=(split(split(D1,"SMS from ...

**2**

votes

**1**answer

27 views

### How to count number of distinct values containing specific text

I'm not sure if I've phrased that question well so I'll elaborate.
I have 160 lines of file numbers, many of which are duplicates. In each file number there is a value that determines the year the ...

**0**

votes

**1**answer

11 views

### how do I create a formula to find percentile of data in different ranges and worksheets

I have 3 worksheets with data in column Q and I want to calculate the 90th percentile of all the data. The number of rows of data in each worksheet is different. It's probably easier to create a ...

**0**

votes

**1**answer

8 views

### Microsoft Excel, copying Format of a cell

Like copy and pasting cell content with format to another cell or multiple cells, is there a way to copy a particular cell's FORMAT alone and paste using Ctrl+V to another/multiple cells?
Thanks in ...

**0**

votes

**1**answer

20 views

### IF function that will calculate the annual total

I can not figure this out and would greatly appreciate if someone could help me!
In cell 5, enter an IF function that will calculate the annual total. If the client has a locker (D5) is "YES" then ...

**0**

votes

**2**answers

22 views

### I need a formula to find the last xday of the month

I am trying to write a formula to find the last Wednesday of each month of the year. I also need the last Friday as well. I am finding ways to get the first Wednesday of a month and tried to modify ...

**-1**

votes

**0**answers

7 views

### linking validation to pivot tables to create dashboard

Please can you advise why this scribt is not working on my excel 2007 but is working on another excel 2007 computer
Private Sub Worksheet_Change(ByVal Target As Range)
'disable events and screen ...

**0**

votes

**1**answer

27 views

### IF statement error message in Excel

The following formula is returning a #VALUE! error.
=IF(L$3<$H11,4*5,(IF("<0",0,(5-(L$3-$H11))*4)))
Why is it returning an error? I know that the error is coming from somewhere in the second ...

**1**

vote

**0**answers

13 views

### Incorporate Excel formula Names in Word Mail Merge document

I have an Excel document with numerous constants defined in Names. For example:
-------------------------------------------
/ Edit Name ? X \
...

**-2**

votes

**1**answer

19 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

**2**answers

27 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?

**-2**

votes

**0**answers

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

**-2**

votes

**1**answer

36 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

**1**answer

16 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

17 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

12 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

13 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

21 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

15 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

37 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

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

**36**

votes

**2**answers

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

12 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

18 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

22 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

24 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

30 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

17 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

21 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

21 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

41 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

28 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

23 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

18 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

9 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

39 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

18 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

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