Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
2answers
32 views

Return data based on matching date range

Our group has an Excel sheet that's used to track rotating responsibilities. A simple example would be laid out like this: Column A: START has dates defining the start of the time period represented ...
0
votes
1answer
20 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
1answer
21 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
1answer
30 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
0answers
18 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
1answer
41 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
2answers
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
2answers
26 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
0answers
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
2answers
68 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
2answers
32 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
3answers
64 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
2answers
25 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
0answers
21 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
1answer
30 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
0answers
23 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
1answer
43 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 ...
-2
votes
1answer
26 views

Need to find code to merge multiple cells into one [closed]

Here is what I have across multiple rows in the same column... | This | | Is | | My Data | I have code to select and copy, but I need to ...
0
votes
3answers
51 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
0answers
16 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
1answer
13 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
2answers
36 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
3answers
32 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
0answers
24 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
0answers
14 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
1answer
47 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
3answers
64 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
1answer
13 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
0answers
9 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
0answers
15 views

Combining data with a count in Excel [closed]

I have a combined spreadsheet with a loan count for a number of sellers. In a separate column I need the total fatal issues associated with the particular loans by seller. This comes from another ...
-1
votes
1answer
24 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
3answers
31 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
1answer
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
1answer
39 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
1answer
37 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
1answer
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
0answers
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
1answer
22 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
0answers
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
2answers
52 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
2answers
39 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
0answers
21 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
0answers
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
1answer
39 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
1answer
34 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
0answers
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
2answers
329 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
1answer
22 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
1answer
31 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
1answer
45 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 ...