**0**

votes

**1**answer

16 views

### SumIF, while ignoring hidden rows and using extra criteria

My original formula is
=SUMIF($D$5:$D$250;"A";G$5:G$250)
which sums up all cells from G5:G250 that have a value of "A" in D5:D250.
Now I am going to hide a few rows and I want them to be excluded ...

**0**

votes

**0**answers

21 views

### Moving through large set of repeated values in Excel more efficiently

If one has repeated values in the dataset of a spreadsheet in Excel, that, when sorted, stacks nicely like sets e.g. in one column
A
A
A
B
B
C
C
C
C
Is there a shortcut to move to the first ...

**1**

vote

**0**answers

9 views

### Locked between MailChimp and European Windows for CSV export?

I have a CSV export for our application that is being used by end users (not tech-savvy).
For some European regional settings Excel expects a semicolon ; for delimiting (comma is used for decimals).
...

**-1**

votes

**0**answers

21 views

### Data Validation with if condition

I have a list of options in cell "B1" using data validation, however, i need it to auto-populate if A1 is selected with Monthly, else the drop down should remain the same.

**-1**

votes

**1**answer

21 views

### Need correct if function

I need help with below formula.
If the difference in dates mentioned in cell A1 & B1 is 60 days, we need Manager approval, if its 90 days we need Sr. Manager approval, if more than 90 days we ...

**-1**

votes

**1**answer

33 views

### How can I make the value of one cell change, based on the value of another cell?

I am writing an inventory list for my office, which is combined with a borrow list. What I want to do, is change the number of items in the inventory list, once an item has been borrowed. For ...

**0**

votes

**0**answers

16 views

### Combine data from multiple rows with same key into one row

I have a spreadsheet that contains an ordered list of data that I need to take the first record with the key and append additional records to the end of the first. Below is the source data structure.
...

**0**

votes

**0**answers

13 views

### Add series from multiple tabs to Excel 2013 PivotChart

Context: I need to produce a dynamic (based on Slicers) Resource Plan graphs for brainstorming business modeling workshop. The Resource Plan needs to present Resource Demand and Resource Capacity per ...

**0**

votes

**0**answers

9 views

### Compare 2 columns As in 2 separate sheets and if they match add column Bs from each sheet together

I have 2 separate sheets with 2 columns. I am looking to match Column A from both sheets and add the value of column B to each other and input the sums in a different column. looking for help.
...

**1**

vote

**0**answers

11 views

### Cell auto adjust height when pulling data from other cells?

I've built a spreadsheet with a summary report that auto formats fine, except in situations where the text in one cell and is too long to fit into a cell.
The report pulls info from cells under ...

**4**

votes

**2**answers

152 views

### Bizarre COUNTIF/COUNTA behavior in excel for counting text cells that are not “”

I have a column of cells filled with formula that give "" on error, and a text string if no error. In a second column I'm giving a formula with:
=COUNTIF(range,"<>")
as well as:
...

**-1**

votes

**1**answer

51 views

### Excel - Lookup value in column and return values from the same row

I was wondering if someone could help me with the following.
I have 2 spreadsheets in a workbook. From the table in sheet1, I would like to lookup everyone that's enrolled in the workshop "7 Habits ...

**0**

votes

**1**answer

21 views

### Counting words in a noncontinuous range in excel 2010

I need to count how many times a person's name appears in a noncontinuous range in excel. I used a formula on a different sheet that worked as it only looks at a column, but I need to look at ...

**0**

votes

**1**answer

12 views

### How to spread monthly values over biweekly pay periods in Excel

I have values each month of the year. They sum to 1.0.
O N D J F M A M J J A S
.05 .06 .20 .05 .05 .05 .05 .05 .18 .16 .05 .05
I want to spread these out proportionally over ...

**0**

votes

**1**answer

21 views

### Changing Excel Cell colours once a word/value in another cell is entered/changed

I currently have a spreadsheet with a list of deadline dates in row C and status updates in row E.
I need the cells in row C change to green once the words Complete/ Completed is written in any of ...

**0**

votes

**1**answer

29 views

### finding two adjacent cells using vlookup()

In preparing my data for an interpolation within an interval, I am using the MS Excel vlookup() function to find a pair of values that will define the interval for my interpolation.
The default ...

**0**

votes

**0**answers

18 views

### List of Events - Excel

Suppose a game involves rolling of 2 dice.
First Player rolls dice, the second player must roll the higher number (sum of dice), and then the first player must roll the higher number to stay in the ...

**0**

votes

**1**answer

19 views

### Excel Conditional Formatting for Date colums

I have 2 columns with dates and I want to apply conditional formatting to all values where the date in one column is bigger than the date in the other column.
So, when the dates in "Actual End ...

**0**

votes

**3**answers

56 views

### Excel mobile aggregate conversion of a code

I use this code
=INDEX(B:B,SMALL(IF(A2:A1000<1, ROW(A2:A1000)),RANDBETWEEN(1, COUNTIF(A2:A1000,"<1")))) to pick a random cell from the b column that doesnt have 100% set in the a column. This ...

**0**

votes

**0**answers

16 views

### How do I combine two pivot tables on a shared column in excel

I have two pivot tables that share a column of data. I would like to combine them so that the data attached to the shared column is lined up with the appropriate item in the shared column in one ...

**0**

votes

**0**answers

22 views

### How to auto fill the Data In corresponding columns of excel. Without the use of fill handel

Hi is there any other way we can fill up corresponding column automatically without use of fill Handel

**-3**

votes

**0**answers

50 views

### Use Excel IF and AND functions

I am trying to create a formula that returns a document # if certain condition are met. However using a range of cells in the condition results in the same answer being returned. What I really want is ...

**0**

votes

**1**answer

26 views

### How do I implement the VBA module to copy filtered data

I need to implement a VBA Macro that copies data from one excel worksheet and puts certain column into another one.
Sub sbCopyRangeToAnotherSheet()
'Method 1
Sheets("Sheet1").Range("A1:B10").Copy ...

**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

44 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

17 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

64 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

26 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

30 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

42 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

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