# Tagged Questions

**0**

votes

**1**answer

12 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

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

**0**

votes

**1**answer

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

**11**

votes

**2**answers

384 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

13 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

**2**answers

30 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

10 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

13 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

20 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

16 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

24 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

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

**-3**

votes

**3**answers

61 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

8 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

11 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

16 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

19 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

39 views

### Insert data between commas in a cell in CSV

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

21 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

33 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

135 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

27 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

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

**-1**

votes

**0**answers

17 views

### One of my excel file sitting on my online file share corrupted due to some unknown reason [on hold]

One of my excel file sitting on my online file share corrupted due to some unknown reason. (User claimed that she cannot save the file back after edit. She ended up terminate excel from task manager. ...

**0**

votes

**1**answer

17 views

### Why is copy paste losing all formatting by default?

Lately whenever i copy paste something (in particular within Office) by default i lose all formatting. To copy the formatting have to retry copying the content several times before it works.
So far i ...

**2**

votes

**0**answers

20 views

### MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version).
I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...

**1**

vote

**2**answers

26 views

### Excel '10 Formula to find & sum a row based on the intersection of 2 data points. (ie. Name(row), Month(column)

I need an Excel 2010 array formula that will take 2 given data points, say a "Name" (row) and "Month" (column), and return the sum of a row based upon the intersection of these two points within a ...

**-2**

votes

**1**answer

32 views

### Excel Macros 2013: Is it possible to create a Macro that, with a shortcut key, toggles a selected value between red and black font colours

I have created a spreadsheet with information regarding students grades and wish to be able to toggle the font colour of selected cells to indicate change in data. I have attempted to use "If", ...

**0**

votes

**1**answer

29 views

### Excel Macros 2013: Is it possible to create a Macro that, with the shortcut key, formats an input value between Whole int and 2 decimal places

I am attempting to create an Excel spreadsheet which holds information of students data, currently I have rounded all data to the nearest whole int.
What I wish to know is whether there is a way to ...

**1**

vote

**0**answers

14 views

### Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...

**1**

vote

**2**answers

74 views

+50

### Excel Opening as a blank spreadsheet, but with values

When we open an Excel spreadsheet that is populated it will open with all of the cells appearing blank. However, if you click on any of the cells you can see in the formula bar at the top that they ...

**0**

votes

**4**answers

34 views

### Getting last cell in row with data and corresponding data in column A in Excel

I have a spreadsheet that in column A lists dates. Column B may or may not have data in each cell.
The question I have is when I grab the last cell with data in column B, how can I also grab the ...

**3**

votes

**2**answers

26 views

### Can I use COUNTIFS where only 1 IF criteria is required?

COL A COL B COL C
ROW 1 Yes Yes
ROW 2 Yes
ROW 3
ROW 4 Yes Yes
I'm trying to write a formula that will count how many rows has at least ...

**-2**

votes

**2**answers

24 views

### Excel - How can I detect the X lowest consecutive values within a column

I was hoping that someone might help me with a problem I'm trying to sort out. Does anyone know a formula that could detect the 10 lowest consecutive readings within a single column.
Thank you for ...

**0**

votes

**1**answer

21 views

### Compare to cells containing text and printing a value from a third cell [closed]

I want to compare two columns containing text and if there a match print a value from third column see eg:
Column A Column B Column C Column D
BOB Sally 1
terry ...