**0**

votes

**1**answer

23 views

### Excel, Needed: Automatic repeat after data entered, unless manually changed

MS Excel, one row of data (numbers 1 to 20). All cells input is done by a drop-lists.
I wonder if it is possible to choose a drop-down list element and all cells to its right within the range, ...

**0**

votes

**2**answers

39 views

### How to compare time in multiple rows using excel 2007

I need help to compare time in multiple rows in excel. I am creating a new rule in conditional formatting. I'm entering this formula in formula bar to compare time across multiple rows:
=IF($E$4:$E$6 ...

**3**

votes

**2**answers

157 views

### Non-intersecting values in columns in Excel

I have three columns with values (A, B, C) as shown below. I would like a formula in column D that will return ALL the values from column B that are not listed in column A. Similarly, what formula ...

**0**

votes

**3**answers

47 views

### How do I use Excel to count the times a string appears in other sheets?

I have a worksheet that contains 10 sheets with data about facility checklists.
I am wanting to create an overview sheet that looks through all of the other sheets can counts the number of times the ...

**0**

votes

**1**answer

33 views

### How we can add background color in EXCEL for printing?

How we can add background color in EXCEL for printing? I create a small image with gray color and add it to PAGE LAYOUT-Background Image. When I see the main window of EXCEL everything is fine and all ...

**0**

votes

**1**answer

44 views

### How to calculate time differences and average difference in Excel?

The list of dates and times below is pairs of task start and completion times (each successive pair is another task). I need to know how much time it took to complete each task. Then I want to find ...

**1**

vote

**1**answer

23 views

### How to ignore the date and just get information from the times

I am using the d/m/y h:m:s format, and I need to count how many entries I have within the same hour no matter the date.
I was using:
...

**0**

votes

**0**answers

14 views

### How to create If a range cell in worksheet equals Y, then create new worksheets

I am trying to get my macro to copy sheets if a range value in active sheet = y, then create worksheets based on the Y values from the B Column with no duplicates. Any suggestions to what I am ...

**0**

votes

**2**answers

29 views

### Excel automatic rating

OK , so let's say I have a list of movie titles. Say for simplicity's sake that there's 5 movie titles. On the next column, I have ratings based on my opinion for the movies,from 1 to 5 because there ...

**0**

votes

**1**answer

50 views

### Best combination of values from two columns

I am trying to pick the best scenario from data in two columns:
Column 1 contains values for 20 rows (4, 6, 8, 10.5, 13, etc).
Column 2 contains values for the same 20 rows (1100, 950, 800, 750, etc).
...

**1**

vote

**1**answer

47 views

### Excel VBA to Standardize Names in a selected range

I am a complete novice at both excel as well these forums, and am attempting to piece together code that would allow a user to update a column of text entries. Basically what I was attempting to do ...

**0**

votes

**2**answers

25 views

### What function do I use for looking up how many times something occurs in a cell for each department?

Partial clip of my spreadsheet:
Dixon Tamara tmdixon2 Anthropology SecurID 700
Portera Maria mportera Anthropology SecurID Software ...

**0**

votes

**0**answers

24 views

### How would you set this up in Excel 2013? [duplicate]

I recently got hired in a sales position and would like to make sure im getting paid for what I have sold.
I have a worksheet with 3 columns where I keep track of what I have sold, 1 column shows ...

**1**

vote

**1**answer

38 views

### Excel 2010 - Max Value in Column based on Cell Row Position

I am working on a spreadsheet that requires all populated rows to have an ID (minus the headers). Normally, simply doing "=PreviousCell.Value + 1" (pseudo code) would do the trick. However because not ...

**0**

votes

**2**answers

23 views

### Why is this Excel IF Query Not Working?

=IF(ISBLANK(CM7),"",IF(CN7=F7>1,-1, IF(CN7=F7>-1,1, IF(CN7=F7,0))))
What I want to say is that if cell CM7 is blank, then leave the cell where the calculation takes place blank. Otherwise, ...

**1**

vote

**1**answer

33 views

### Negation Symbol over character in Excel

Is there any way to achieve a negation symbol over a character within an excel cell ? Im looking for sth. what you can do in latex easily with
\neg
or
\Overline

**0**

votes

**0**answers

13 views

### Word embedded in Excel shows only the first page

I have this view of a Word file embedded in Excel:
I intentionally made the height of the page of 10cm. There is plenty of space below the last line, but I cannot see the data which is actually on ...

**0**

votes

**0**answers

18 views

### Copy text based upon drop-down menu selection?

I have a drop-down menu in excel, I want to change the rows values below the selection of drop-menu (selected cell)- the immediate rows for e.g 10 rows to change its value by copying text from another ...

**1**

vote

**1**answer

38 views

### Excel Formula - Count Unique Projects but Exclude 'Admin'

I am looking for some Excel related help for a formula which I've not been able to figure out myself.
I have a sample list of data in range A1:B7 - Column A is a list of names (e.g. John, Jane, etc) ...

**0**

votes

**0**answers

26 views

### Splitting .csv File Based on Values in Other .csv File

I have two .csv files. One contains a string in the first column, then a number per column for several columns after that, like so:
ABU_1102;1162;1165;1167;1168
AFG_1220;1214;1215;1213;1212;1211
...

**1**

vote

**1**answer

26 views

### Automatically copy a row to a new sheet based on value in a specific column [closed]

How do I automatically copy any row that contains the name john into another spreadsheet?
I have an example table from my Workbook below:
date car color address location car number ...

**5**

votes

**4**answers

90 views

### How to setup stacked bar chart to graph medication doses?

My Mom is sick (cancer) and my Dad has been writing down the times that he has administered pain medications to her. He asked me to plug it into a spreadsheet and chart it so he can visualize trends ...

**0**

votes

**2**answers

48 views

### Excel formula to change one cell value to another value based on a third cell

to make this simple a1 has a value that can change, b1 has the formula to test a1 value. c1 is reset to a chosen value based on a1.
I have a table that people can input values. I have a list box in ...

**3**

votes

**2**answers

48 views

### Extract a Whole Word From String Containing a Specific Letter or Character

I would like to extract only the word from a cell that contains a specific character ("=") within the text.
A2: Dolly made me a homemade=cake and some muffins
A3: we had cheese=cake for dinner
A4: ...

**0**

votes

**1**answer

45 views

### Prevent Excel from converting values to dates when opening HTML files

I have some HTML files that contain tables, which I need to perform some analysis on.
I can open them in Excel, and it preserves all the table formatting and layout (which is what I want).
The ...

**0**

votes

**2**answers

69 views

### Excel Formula To Get First and Last Non-Zero Values

I have checked the similar questions but they are little bit different from what I need to do.
What I need to do is create a summary table for large data, some of that data is this:
[A] [B] [C] ...

**0**

votes

**1**answer

25 views

### Why does this Excel formula return 0.042361? =Sum(Indirect(Address

In sheet3 columns A,B,C,D are the value of row numbers. Thus, A1 to D1 contain 1, A2 to D2 contain 2,...etc.
Why does the following formula in G2 of Sheet2 return 0.042361? All numbers are integers. ...

**3**

votes

**1**answer

57 views

### Return multiple values from one reference id

is it possible to have an excel formula that would create the output table below?
initial data:
╔════════════╦═════════╦══════╦═══════╦═════════════╗
║ product id ║ item ║ size ║ price ║ size ...

**1**

vote

**1**answer

29 views

### Power Query Conditional Dynamic Filter

I have a Power Query query that uses a secondary function query that pulls parameters from a table in my workbook. For example, to filter by date range, I use
#"Filtered Rows" = ...

**-4**

votes

**0**answers

37 views

### Combinations in VBA

I have a list of 100 items and I'm looking to create a basket of 5. I would like Excel to print off each combination of 5 distinct items. How can I do that the easiest?
This is my code now – I ...

**2**

votes

**1**answer

37 views

### Replace method generates application-defined or object-defined error in Excel for Mac

I'm having trouble with this on the latest version of Excel for Mac.
Here's the macro:
Sub Run()
'
' Run Macro
'
'
Sheets("Data").Select
Cells.Select
Range("BK1").Activate
...

**1**

vote

**1**answer

22 views

### Copy Conditional Formatting 3-Color Scheme to another tab

I have one sheet, Tab 1, with a 38x12 grid of values ranging from -30 to +30. I applied the traditional 3-color scheme conditional formatting to the data, which shows all shades of the spectrum ...

**0**

votes

**0**answers

18 views

### How do you group by week in Excel PowerPivot?

Say you have a simple sales table in PowerPivot. What's the easiest way to allow the data to be grouped by week in a PowerPivot pivot table?
I know excel's basic pivot tables have a group feature, ...

**0**

votes

**1**answer

29 views

### Get excel to undo its helpful date conversion

When importing and manipulating data in excel, certain coding systems (like CAS numbers) are always a problem because numbers like 8000-01-7 can become 7th of january 8000.
There is usually (but not ...

**0**

votes

**1**answer

32 views

### How to fill up gaps in excel

My data in excel has for example the following data in columns A and B:
A B
1 4
2 6
5 88
9 67
12 45
and so on.
I would like to transform it as following:
A B
1 4
2 6
3 0
4 ...

**0**

votes

**0**answers

40 views

### Access Denied error when attempting to save Excel spreadsheet files with Microsoft Office

I have a server running Samba Version 3.6.3 on Ubuntu 12.04.4 LTS. Some users are receiving the following error message when trying to save changes to an Excel spreadsheet file (mounted from a Samba ...

**1**

vote

**2**answers

35 views

### Extract string containing a word from an Excel cell with hundred of strings

I have an Excel workbook, in column A each cell contains all URLs of a site (this means hundreds of URLs in one cell).
Among all the URLs within a single cell I want to extract only the URL that ...

**0**

votes

**0**answers

29 views

### Find and Replace in .txt file by extracting data from spreadsheet

I need to replace instances like Manhole Name="1" with Manhole Name="SW3/001" for instance by extracting the data from spreadsheet.
Would that be possible using regex, or in any possible way ?
...

**-1**

votes

**0**answers

13 views

### Summation issues with Excels [closed]

my excel spreadsheet sums some cells correctly and other not. Even when the data being used is the same manner and it is not a formula issue ...often it says that the clipboard function cannot be ...

**0**

votes

**0**answers

15 views

### Microsoft Excel 2013 - Auto-generating a page with parent formating

I have a multi-line activity log which is created using merged cells and colored borders, and often times the activity log follows on to a new, un-formatted page.
Is there a way to have excel create ...

**1**

vote

**0**answers

37 views

### Sum data from muliple cells, multiply by other cell range, reference on other sheet

Ive had a couple issues with this workbook recently this seems like the biggest. As you can see in the pics, this a time sheet that needs F15 multiplied by Q15, then added to F20 which was multiplied ...

**0**

votes

**1**answer

24 views

### Odd issue with Excel pie charts

I am having a weird issue that I was hoping was a quick fix with Excel 2013 for a pie chart. However, I can't figure out what's wrong! I am attempting to make a pie chart out of a column that looks ...

**0**

votes

**0**answers

7 views

### Publisher doc merged with Excel printing some blank sheets

I am merging addresses on envelopes. Some addresses contain 3 lines; some contain 4 lines. Here's the order:
Name
Business Name
Street Address
City State ZIP
I have checked the box that says ...

**0**

votes

**1**answer

51 views

### How to move columns with drag and drop in Excel 2016?

How to move/reorder columns with drag and drop in Excel 2016 for Mac? The method that worked for Excel 2011 no longer works in 2016. The cursor never changes to the pointer or hand.

**0**

votes

**0**answers

20 views

### Create Dependant Data Validation without Cell Tables

I currently have data validation setup for cell A1 to select either "dog" or "fruit". I have another data validation for cell A2 to allow the user to pick items depending on the value picked for cell ...

**2**

votes

**1**answer

45 views

### On Excel I want to create a list from another sheet based on two values

I have 2 values in dropdown menus in cells B2(DATE) and B5(ITEM).
from these values I want to create a list of items(based on B5) that were sold on that date(B2).
The transactions are listed on a ...

**0**

votes

**1**answer

41 views

### Formula to extract certain character positions in a string

I'm busy here with excel but kind of struggling with some kinda formula.
I got first and last name in one cell and I want to combine them in an another cell. but I just want the first letter of the ...

**1**

vote

**2**answers

22 views

### Excel EDATE Formula

I'm using Excel 2013. I have an edate formula in column B which looks at at the date in column A then adds 5 months onto it. My question is, if there is a blank cell in column A a weird date appears ...

**0**

votes

**2**answers

27 views

### Fill in blanks in multiple columns in Excel

I have about 50 columns in my spreadsheet and around 5000 rows. In these 50 columns, there is either "TRUE" or it is blank. What's a shortcut to changing all of the blank cells to "FALSE"?

**1**

vote

**2**answers

68 views

### How do I create randomized word lists that are dependent on a master list?

I am using excel for Mac 2011
For a linguistics project I want to do the following. I will have a word-list like this (in reality it will be much bigger):
Master List:
Bag
Leg
Magnet
Apple
Gum
...