**0**

votes

**1**answer

21 views

### Column to aggregate values in another one

I have a series of values in a column, and I want another column to cluster these values to specific aggregates. How would I do this in Excel?
if a1 cell value between 0 and 5, then b1 = low
if a1 ...

**0**

votes

**1**answer

22 views

### MSO Excel - Add padding to the fill color of the cell

Is it possible to add some padding to the fill color of a cell?
Now if you set a fill color on a cell, the cell is always completely filled.
(I use Excel 2016 preview, but it looks just the same as ...

**1**

vote

**1**answer

33 views

### Excel add-in not loading when opening Excel from VBA

I'm using excel reg-ex add-in and it works well, the only problem with it that it doesn't load when excel is started by VBA.
I've a macro in word to collect some data in Word and copy it to excel, ...

**-1**

votes

**0**answers

19 views

### How can I use recording macro for merging cells of rows in excel and enter to next rows?

I have 1300 data which is required to merge. I am merging the data with recording macro. the problem is now that I am not able to step next row after one merge. Please suggest me how to set up the ...

**0**

votes

**1**answer

46 views

### Split data in half evenly by adding column with value: 1 or 2 based on specific cell value - excel

I have a query I pulled from a database with student information. The table has the following columns: StudentID, CourseID, CourseGrade.
The CourseGrade column can contain any of the following ...

**1**

vote

**2**answers

17 views

### Get Average of time data in excel 2010

How do I compute average time in my column N
my AHT works when I only use =AVERAGE(N6:N7)
but when it is =AVERAGE(N6:N755) until the last column , it doesn't work
note that there is only value on N:6 ...

**1**

vote

**2**answers

28 views

### Generating coefficients for SERIESSUM formula in Excel

I'm modelling a cash collection spreadsheet where a company sells products each week and wants to collect cash over a number of weeks (n; between 42 and 336 weeks).
Assuming n is ≤ 52:
To calculate ...

**0**

votes

**0**answers

13 views

### Excel column graphs

Using Excel I want to create a series of two overlapping columns to show value growth rather than stacked columns which add the values eg. reading level achievement from Level 4 to Level 9 ie. a ...

**1**

vote

**2**answers

80 views

### How to split numbers into separate digits in Excel

Does anyone know a fairly simple way to split numbers of various length into separate digits and then manipulate each digit? Could probably do it in Excel itself, but thinking a macro would be nicer ...

**0**

votes

**2**answers

33 views

### need help in editing data in csv file

I am in need of editing the date data in csv.
I will explain with an example.
I am using WPS presentation software for reading and editing csv files. If the above is not possible in that, i can ...

**0**

votes

**3**answers

75 views

### Excel Formula average without blank cells

I have a row of values and want to find the average of the first 3, not counting blank cells. Example:
A B C D E F G
12 blank 8 blank 7 9 4
The average of the first 3 ...

**0**

votes

**2**answers

28 views

### how to insert a helper column?

I have an excel spreadsheet where each data set covers three rows. I want to sort the data based on the value in column K, which is in the third row of each data set, there are no values in rows 1 ...

**1**

vote

**0**answers

23 views

### excel formulas not working in structured table protected cells

Structured Table1=
A B C
QTY Price QTY*Price
1 3 3 =A*B
2
3
Column QTY & Price are not locked
while Column QTY*Price is locked & hidden as it has a ...

**0**

votes

**1**answer

31 views

### To Populate data from a column in excel based on a value

I have list of students in one column and their scores in another column
I need to populate the names of the student who have scores less than 70%
Marks in single column in a different work sheets.

**0**

votes

**0**answers

26 views

### Excel - returning a yes or no if data matches another spreadsheet

I'm looking for the proper formula to use.
I need my file: "O:\Budgets[PROGRAM_Budget]" sheet "2015 Budget" to search another spreadsheet "O:\General Office Docs\Purchasing\Vendors\VendorList[1 ...

**2**

votes

**1**answer

48 views

### Excel: count number of unique matches for multiple criteria

I have sheet1 with a list of people and their allergies/dietary requirements. There are nine allergies/dietary needs, and each person has 1 or more allergies. Each requirement is a column, each person ...

**0**

votes

**3**answers

59 views

### Excel whitespace contains hidden 0

I have workseets with cells containg trailing whitespaces. I have tried using various VBA methods to strip these whitespaces out. However none have been successful. After examining if I copy the white ...

**0**

votes

**0**answers

17 views

### Search multiple sheets for a term in one column each, copy all matching rows to a new sheet

We have a 3rd party supplied , multi tab sheet that I would like to filter and copy data to a new sheet.
In the original sheet, all tabs can be searched for the term 8A in column C. I want any row ...

**0**

votes

**1**answer

14 views

### Force external link in Excel to break if the file can't be found

I have an Excel spreadsheet that has an external link to another spreadsheet. What I want to happen is if
Main_Spreadsheet.xlsx
Secret_Data.xlsx
When someone opens Main_Spreadsheet.xlsx and they ...

**1**

vote

**2**answers

37 views

### Excel 2010 Advanced Filter issue

I ran into something I can't really explain trying to filter a huge pile of data using the advanced filter...
I had a document with hundreds of thousands of lines (.xlsb) containing a whole bunch of ...

**0**

votes

**3**answers

39 views

### Compare two sheets in Excel and extract the differences to other third sheet

My situation:
I got a huge excel sheet from a manufacturer of products for my online shop. This format:
product ID | price | name | ...
Every week the manufacturer is sending me a updated list ...

**0**

votes

**0**answers

35 views

### Excel 2013 cannot open XLS or XLSX when an XLS or XLSX email attachment is open

I have Office 2013 installed running on Windows 7, both are fully patched. Excel 2013 can open multiple spreadsheets OK until an email attachment is open, once excel has opened an attachment I can no ...

**0**

votes

**0**answers

15 views

### Excel Excel add to sheet two based off of cell value

Ok I'll try my best to explain this. I have my totals all set up for my electrical fittings on sheet 1. I would like to be able to take my entire excel spread sheet from my estimating program, place ...

**2**

votes

**1**answer

59 views

### Excel Macro Hyperlink.Add Errors

I'm relatively new to VBA code within Excel, so please forgive me if the answer is simple (I expect it usually is). I'm using Excel 2010, for reference. I'm trying to accomplish the following, with ...

**2**

votes

**3**answers

72 views

### How can I make an Excel 2010 worksheet read-only without a password?

I want to make one of the worksheets in an Excel 2010 workbook read-only, but I don't want to use a password. I just want to make it so that I can't accidentally edit the sheet, and I don't want to ...

**0**

votes

**1**answer

16 views

### MS Excel cell references shifting after using a macro?

Basically this is what happens:
On Sheet1 I have a column of cells that are linked to other cells on sheet2. Looks something like this.
Sheet1!A1=Sheet2!A1
Sheet1!A2=Sheet2!A2
Sheet1!A3=Sheet2!A3 ...

**0**

votes

**0**answers

10 views

### Paste link into Table disallowed?

I am trying to use the Copy / Paste Link (ALT+ESL), but it does not appear to be an option when pasting into a Table.
Is this a known limitation of Excel (using 2013)? If so, is there a better work ...

**-1**

votes

**1**answer

25 views

### How to return earliest date

I want to look at the dates of 5 columns of qualification then enter the earliest date in a new column then if it is before today's date turn it red and highlight it.
I can do the second in ...

**0**

votes

**3**answers

33 views

### How do I delete (or highlight) duplicate rows in Excel ONLY IF there are 4 or more instances?

I have an excel document that has over 300 rows of data. Column A is sorted by personnel names and I need to isolate only the people that have less than 4 occurrences within the sheet.
Is there a way ...

**0**

votes

**1**answer

15 views

### Query two fields and select answer from third field (If or vlookup?)

I need to compare two fields in my data to a table and get the resulting fx value from table.
How the formula would read I would guess:
IF local_in_data = local_in_table AND
expense_in_data = ...

**1**

vote

**1**answer

44 views

### Updating Microsoft Word link item through VBA

Is it possible to change the Item of a link in MS Word referencing to an Excel spreadsheet, pragmatically, through the use of VBA?
I have found discussions on how about to change the file source, but ...

**0**

votes

**1**answer

43 views

### Automatically redefine comment box dimensions to match the background image in Excel

In Excel, say I choose an image, test.jpeg for example, as the background of a comment. I want the comment box to take the dimensions of test.jpeg. Since I plan on having hundreds of such comments, my ...

**0**

votes

**1**answer

15 views

### Whats an easy way to fill in empty cells after copy and pasting from Pivot table classic layout?

I've run a report on products sold and used a pivot table to see products by customer. I then need to upload the data back to SF and so I have used the classic pivot table layout to be able to copy ...

**1**

vote

**0**answers

20 views

### which function would add a row to another set of rows, so it behaves as if they were below each other?

Example: having data in A1:E4 and another data in G1:K1 and i need to use them to look like A1:E5 so that G1:K1 was added below A1:E4.
The reason behind this is that excel is asking to give set ...

**1**

vote

**1**answer

23 views

### How to get the median based on column headings?

Let's say we have:
EPS Sentiment Revenue Sentiment Formula1? Formula2?
10 3% 20 5% F1a F2a
9 6% 30 4% F1b ...

**0**

votes

**0**answers

17 views

### Excel IF statement COPY alternative [duplicate]

I have a multiple page Workbook for handling reservations. There is a page where resevations will be entered and then subsiquent ones to display totals for each "catagory".
I am using a simple IF ...

**1**

vote

**2**answers

53 views

### Alignment of characters in Word or Excel table

I have some hyphenated data like this:
A
1| 2-8
2| 0-12345
3| 15-123
4| and so on
How do I align the contents in word or excel such that hyphen is at the center?

**3**

votes

**2**answers

45 views

### How to automatically exclude maximum and minimum values when calculating an average in Excel

If I want to take a medial average, which excludes the highest and lowest values, is there a way to do this on Excel without having to manually find and exclude the highest and lowest values from the ...

**0**

votes

**0**answers

24 views

### Auto Extracting Data from Excel file on Onedrive

Our team is using One Drive for file sharing. What we wanted to do is to be able to Auto Extract data from 1 excel file on OneDrive to another excel file to be saved on another OneDrive ...

**1**

vote

**0**answers

30 views

### Update absolute reference if referenced cell is part of the copied data in Excel

The main purpose of absolute references is that still point to the same cell after copy/pasted elsewhere. But what I want is, in case the cell referenced to is part of the data copied, the absolute ...

**0**

votes

**1**answer

41 views

### Why does excel tables break VLOOKUP formulas

I have a worksheet using raw data that Excel does not identify as Tables (ie. plainly putting values in adjacent cells), and on another part of my worksheet, formulas doing lookup in that data, like
...

**0**

votes

**1**answer

35 views

### reference to first visible cell above in Excel

How can I get a reference to the first visible cell above the active one after the data in a table has been filtered.
NOTE: I don't need this for summing up the data above. I know how to do that on ...

**0**

votes

**0**answers

26 views

### paste data with blanks that does not erase formatting in destination sheet

I am trying to collect data using ms excel mobile which does not support a number of the functions I want to utilize. I have set up identical spreadsheets for mobile and full featured excel. The ...

**5**

votes

**2**answers

335 views

### Where is value coming from in formula?

I have been sent an Excel sheet and I am trying to workout how one of the formulas works. It has an if statement in it and the value if true looks to be some sort of variable that references a formula ...

**0**

votes

**1**answer

24 views

### Conditional Formatting for when cells contain part of a value

here is the best way I can describe my problem I am having, I tried a few things and I can't seem to hit the nail on the head of what exactly I want. Here are my columns. The asset in column B is ...

**0**

votes

**1**answer

36 views

### Making the 'Series Name' a combination of text and cell data?

I'm having an issue trying to figure out how to create a 'Series Name' for a line chart in Excel to a TEXT + CELL value.
For example, I have two cells labeled 2015 and 2005 in Excel. In my chart, I ...

**0**

votes

**1**answer

48 views

### Excel VBA that loops through the folder and move data to the next column

I am trying to write a macro that loops through all of the files in a folder m then opens it and looks for the words starting with "Page" in K column and then shifts it to the next column. The code I ...

**0**

votes

**1**answer

33 views

### Plot graph in MS Excel using multi axis

I have a table with many of lines (alice, bob, etc.) per each date:
x line y
2015-04-10 alice 11032024
2015-04-10 bob 1492804
2015-04-10 clown 845033
2015-04-10 mary ...

**0**

votes

**1**answer

27 views

### How to display cell values only if they are highlighted?

Basically what I want to do is to display values in specific column only if the row(B5) is highlighted(Hereinafter column E) . And if it is highlighted then multiply column C by D.
Could anyone ...

**1**

vote

**1**answer

65 views

### Disable “Unable to open <URL>. Cannot locate the Internet server or proxy server” error

I've been having this problem in Excel 2003, but maybe it's also present in earlier versions.
I have an Excel spreadsheet that imports data using a web query, which connects to a web page hosted in ...