**0**

votes

**0**answers

30 views

### Dragging cell references to different worksheet across the rows

I'm trying to link every cell in 3 columns to corresponding cells in a different worksheet. While I am able to pick up the first cell reference just fine, when I drag the reference down the column in ...

**0**

votes

**1**answer

18 views

### Pivot table filter

Below is a simple representation of a huge data and its pivot table
Data
+------+------+
| Proj | Data |
+------+------+
| ABC | S |
| ABC | U |
| ABC | S |
| ABC | U |
| ABC | U ...

**1**

vote

**2**answers

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

**2**

votes

**1**answer

46 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

**2**answers

24 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

16 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

44 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

33 views

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

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

14 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

34 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

**1**answer

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

**-1**

votes

**1**answer

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

**0**

votes

**2**answers

33 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?
UPDATE
Glitch disappeared when Excel restart, so nobody knows the reason and I awarded just "direct" ...

**-2**

votes

**0**answers

60 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

38 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

22 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

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

**-1**

votes

**1**answer

31 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

19 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

72 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

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

**1**

vote

**2**answers

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

**44**

votes

**2**answers

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

28 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

16 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

**3**answers

72 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

13 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

23 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

17 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

24 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

**2**answers

31 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

44 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

93 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

**1**answer

16 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

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

**2**

votes

**1**answer

29 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

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

**1**

vote

**2**answers

36 views

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

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

20 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

27 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

19 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

63 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

28 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

15 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

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

**1**

vote

**2**answers

41 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

147 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

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