**0**

votes

**0**answers

20 views

### Matching data in Excel

I have two columns of stock codes - column A has no prices on it - column B has the prices beside it in column C. I want to index column B and search the code in Cell 1 of Column A for the same code ...

**1**

vote

**1**answer

46 views

### How to use vlookup to look up words in Excel?

Here is a mockup of my data:
Column I has categories of food and column H has the codes for those categories.
Column E has sub-categories, which is what I need to work with. It contains the ...

**0**

votes

**0**answers

15 views

### Excel: Reference a number in a concatenated string

Below is my formula in cells B7, B9, and B11 for three separate ranges of numbers: B7 = C6:N6, B9 = C8:N8, ... .
B7 = "Average: " & round(average(filter(C6:N6,C6:N6>40)),2) &" Total: " ...

**0**

votes

**1**answer

18 views

### Expand colour of formatted cell to rest of the row in a table

I have applied conditional formatting to several cells in column A, whereby if I type 'I' this cell will turn grey. What I want to also happen is that colour to expand into column B-I without changing ...

**1**

vote

**1**answer

68 views

### Dispersion graph in Excel

I need to draw a dispersion diagram in Excel, but that must be vertical, not horizontal.
I have this table and need to graph the "Weighted" column:
When I try, I get this horizontal graph:
What ...

**0**

votes

**0**answers

27 views

### Extract all URLs and emails from a single cell

I have an Excel workbook, in column A each cell contains lot of text and some URLs and emails (all this in one cell).
Among all the text within a single cell I want to extract all URLs and emails.
...

**0**

votes

**0**answers

18 views

### how to get cells containing keywords separated by a comma to become filter keywords on activating the filter

I have a table of recipes:
Dish | Ingredients | Tools |
Soup |tomatoes, basil|bowl, fork |
Pizza|eggs, cheese |pan, knife, plate|
Pie |meat, eggs, ham|skillet, knife |
If I ...

**0**

votes

**0**answers

8 views

### Triplicate entries of a column

I have a data column with over 2000 entries...
MV1
BNV
CMG
IKN
...
...
I want to triplicate each entry in the column format.
Result should be;
MV1
MV1
MV1
...

**0**

votes

**0**answers

11 views

### Auto copy based on condition in excel

I have developed an Auditing sheet in Excel in which the results are copied into a Word document to create an audit summary report. How do I get excel to copy all the rows that contain the word ...

**-2**

votes

**0**answers

28 views

### I need a formula to covert time rolling over from one day to another.

I am trying to enter minutes in an Excel spreadsheet.
I have the column formatted with the 24 hour clock.
The problem I am having is when you go from 11:55 PM to say 12:10 AM the next day.
I ...

**0**

votes

**0**answers

30 views

### Excel pivot table grouping issue with 1904 date system

When I use 1904 date system in an Excel workbook I experience a pivot table grouping issue.
After grouping for a date field in pivot table, the date values are shifted by one day.
An example of the ...

**-1**

votes

**0**answers

15 views

### How to create Pie Charts for several data with maximum area against the maximum sum of all

I have some data and I would like to represent proportions in chart pies. I have 12 subjects of two columns each. I found a guy called Andy Pope's pie resizer VBA code, but he has a restriction of 9 ...

**-1**

votes

**0**answers

12 views

### Diverging bar chat in excel

I am really struggling with plotting a 5 point likert scale in excel. The blogs I've read mention dividing the the middle figures (neutral) or in my questionnaire its (moderately) in two. However, my ...

**2**

votes

**2**answers

24 views

### If, Match and Index function returning error

I have a range of cells containing names in A6:A12.
I also have corresponding values in columns B, C, D and E.
I want to compare the value of C3 to see if it matches in the names then extract the ...

**-2**

votes

**1**answer

19 views

### IF formula to compare several cells

Having problems with "IF" in Excel.
I want to compare Cell A2 with cells B2, B4, (...), B100 from another sheet.
How do I write the formula?

**0**

votes

**1**answer

26 views

### Custom fill sequence excel

I want to do a custom fill sequence in Excel that i can drag. For the life of me i can't find the answer to this.
Two desired outcomes:
A1=B1,
A2=B7,
A3=B14,
A4=B21,
But what i really like is:
...

**0**

votes

**1**answer

41 views

### Not boolean operation in Excel

In Excel if I have some boolean operation of the form
{=SUM(IF((A1:A8="Google")*(B1:B8="Stanford")+(C1:C8="Columbia"),1,0))}
I know that * means AND() and + means OR() so that we are searching for ...

**0**

votes

**0**answers

18 views

### Combining Multiple columns and deleting doubles

I have 12 tabs on a spreadsheet - one for each month of the year.
My column D of each sheet references item numbers (there are 1,000's on each tab)
I want to have a master spreadsheet which captures ...

**-4**

votes

**0**answers

19 views

### 1 Excel Spreadsheet 2 Different Monitors

I used to be able to use the "New Window" button to view a single excel spreadsheet on 2 different monitors. Excel would create another version of the same spreadsheet on a completely different Excel ...

**0**

votes

**0**answers

13 views

### Finding a way to auto update a formula based on real dates in excel

I'd like to track my employees vacation time with Excel. I'd like to be able to develop a formula that "gives" each employee 8 hours of vacation time once a month, based on their start date, and then ...

**0**

votes

**1**answer

20 views

### Check for two values in same row in excel

I have retrieved some values using powerquery, its essential records from track and field meets. They are structured like this:
Meet | Result | Name
WC 10 John
NC 11 John
DC ...

**0**

votes

**1**answer

13 views

### Linking website data to Excel sheet

Not sure if what I am trying to accomplish is even possible but I figured I'd ask.
I have a decent sized spreadsheet with specifications from hundreds of different smartphones that I am working on as ...

**-1**

votes

**1**answer

31 views

### how to select only cell A1,A3,A5,A7…till end of the row in excel using formual

Please help I want to know how to select a cell which is shown in screen shoot in excel using formula
Here is the screen shot

**0**

votes

**1**answer

43 views

### Index match on 2 conditionals?

Data:
I could use some help coming up with an index match formula based on 2 conditional items. For the attached data set, I need to set up a formula (and make it repeatable for other stores and ...

**0**

votes

**0**answers

12 views

### Onenote 2013 embedded Excel list blurry in web view

I embedded an Excel table into a OneNote page (to track a Todo list). It displays fine in the OneNote 2013 desktop app, and I can edit it there directly and also open it for editing in Excel.
When I ...

**0**

votes

**0**answers

20 views

### IF adding formulas instead of “Yes and ”No"

I have a formula to calculate an end value if the input value falls between 85-70, if the input value is between 70.00000001-0 there is another formula to calculate an end value.
Can I replace the ...

**6**

votes

**2**answers

346 views

### How to generate random string from a set of available strings in Excel?

I want to generate a column which will have random string values in any order. Those string values have to be from ('New', 'Mint', 'Very Good', 'Good', 'Acceptable', 'Poor') strings? Can anyone let me ...

**1**

vote

**0**answers

39 views

### Excel 2010 Password Protected Book Accepts More Than One Password

I use Excel 2010 64 bit (14.0.6023.1000)
A workbook that is being protected by password "flu" and be unprotected by password "flu" OR " ab". Why is that? First of all, I thought beginning with Excel ...

**0**

votes

**1**answer

21 views

### Read last known value in a Excel data table

I'm working on something but can't figure out a formula and wondered if anyone out there has any suggestions?
I'm looking for a formula which will tell me the last status of a job.
In the example ...

**-3**

votes

**2**answers

40 views

### Excel VBA Code to maniplate rows and columns

Hi can someone help with vba code in excel 2013 to do the following to a worksheet
Current : sheet1
Filer ShareName IPAddress1 IPpaddres2 IPAddress2 ... ... ....
ServerA ...

**0**

votes

**0**answers

26 views

### Excel using index for a whole column except blank cells

Sorry I didnt know how to title this question so feel free to change it to make it more understandable. I have this values:
1 - 3
1 - 2
1 - 5
0 - 4
on my name manager I have these ...

**0**

votes

**0**answers

17 views

### Condtional formatting

I have a question on how do you write a formula in a conditional formating if it sees the text funded in colume h I want to highlight column a the loan number when it sees the world funded only for ...

**0**

votes

**1**answer

25 views

### Need to transfer a column's data. I have 2 sheets with same data and need to move corresponding data from one to another

I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 ...

**1**

vote

**0**answers

17 views

### Data Validation not filling when adding row to table

I have a table I'm using to track issues. Two of the columns have data validation based on lists and there is conditional formatting set up on a few of the columns as well. When I add a new row to ...

**1**

vote

**3**answers

69 views

### Can Excel 2013 show the formula instead of the value only in certain cells?

I need a specific column in my spreadsheet to show the formula and not the resulting value. It still needs to be seen by Excel as a formula but it just needs to show the formula in the cell and not ...

**2**

votes

**0**answers

23 views

### How to show collapse/expand button beside a sub-group in Excel that is the last child of it's parent?

I am experiencing this strange behaviour in Excel and am looking for either an explanation or a solution.
I am using Excel's grouping feature to create some parent-child nodes within my spreadsheet. ...

**0**

votes

**1**answer

86 views

### Excel printed pages are different between two machines

I have a single excel file that in one machine is printed on 1 page where in another machines needs 2 pages as the last line is moving on the next page.
I have re-installed the same drivers on both ...

**1**

vote

**1**answer

10 views

### Find and Assign (Exact Phrase) Keyword Values?

I am using the following formula to assign values to rows based on keywords, which I found here: Can I use the Excel Match function to match on more than one type of value
...

**0**

votes

**1**answer

21 views

### Sort excel table (multiple columns) by numeric column

I have this table from program profiling:
I need to sort it by Total column. But instead, the Excel sorts the numbers alphabetically. I can't even believe it's that stupid. Just check it out!
Of ...

**-1**

votes

**0**answers

34 views

### Excel list that suggest a new value

I'm trying to make a list that helps me choose what kind of dimension I should choose.
=INDEX(A$8:A$21; MATCH(A2;A$8:A$21;0))
I know that I have to use IF inside there, but I just get error.
...

**0**

votes

**1**answer

35 views

### Select specific rows in Excel from text file

I want to select a lot of rows in Excel in order to delete them, and doing this manually literaly takes hours. I got the specific rows in a .txt file with a number on each line. Is there some cool way ...

**-1**

votes

**0**answers

20 views

### Why does pasting large number of additional rows into Excel 2007 table cause Excel to flicker as if continually recalculating?

I have an Excel 2007 xlsb workbook containing several Excel table (ListObject) objects, each holding reference data. Every month, each table is updated by pasting approx 2,000 additional rows of ...

**1**

vote

**1**answer

57 views

### Excel.. using INDEX and MATCH to find a string in duplicate values?

I need a formula in Sheet1!C2, maybe a combination of INDEX and MATCH to find out, using ID field as a key, if a certain ID bought screws (sheet 2).
My problems are: ID is duplicated in sheet 2, ...

**0**

votes

**0**answers

25 views

### MS Excel - Match match index?

Sorry in advance if my formatting or question is hard to follow.
I'm kind of new at this. And couldn't figure out how to do table format...
I have an Excel table laid out kind of like this:
(ID#) ...

**0**

votes

**2**answers

41 views

### Formatting numbers in excel so they are in parentheses

I want to format cells in Excel so the numbers the cells contain are displayed in parentheses (both negative and positive numbers). Examples:
(4.54)
(-2.32)
The cells I want to format this way ...

**0**

votes

**0**answers

25 views

### Trying to find number of times an ID # appears in a data list

I have a list 500 Master Account IDs, and a second sheet with a list of 1000+ child account IDs.
Each of the child accounts is linked to a unique Master ID from the 1st sheet.
I need to summarize as ...

**1**

vote

**1**answer

21 views

### excel data management and formula request

I have a dataset
~2000 patients are sampled weekly for 18 months and get a positive or negative results (or something indeterminate)
each patient has a single row
the columns are the results or ...

**0**

votes

**1**answer

41 views

### Excel: Duplicate names in column A, unique data in column B. I want one row for each unique name with multiple column

I need help getting a spreadsheet that looks like this:
Smith, A. Education
Smith, A. Government
Smith, A. Marketing
To look have the name listed once and the three words listed ...

**0**

votes

**0**answers

25 views

### Excel drop-down list formulas

I'm trying to create a smart Stats sheet in Excel 2013 (PC) using drop-down lists.
In Sheet 1, Column B contains similar drop-down lists with the following two choices: Project and Regular Work.
...

**3**

votes

**0**answers

34 views

### How can I click on an inactive Excel window and have Excel move to the cell I clicked on?

Can I customize Excel so that when the Excel window is not active, and I click on a cell, Excel will move to that cell?
Clicking on a cell activates the window, but Excel does not move to the cell. I ...