A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

-1
votes
0answers
9 views

importing Data from cvs files to excel and perform some steps using macro

I want to import csv files into one excel file using a macro and perform some steps for example deleting some rows based on matching the date in two columns. some times the imported information will ...
0
votes
2answers
7k views

Automatically Updating a cell in Excel from another sheet's data, based on another cell's value

So, I have setup a drop down menu with a list of names in A1. What I want to happen, is have the Data in F34 change based on what A1 is reading. I want to have F34 update with data from another sheet. ...
1
vote
4answers
3k views

Filtering character in Excel

I have a column in excel file which is mix of set of character and numbers, I want to filter out all rows starting with character. Example Column1 abc 12345 def 5678 xyz 7895 tryc I want to ...
1
vote
4answers
6k views

Change default encoding of Excel to UTF-8?

I am using a variety of tools to regularly prepare data for the web. One stage requires me to open a CSV in Excel, make changes and save the file. Is there a way to force Excel to accept UTF-8 ...
1
vote
0answers
141 views

Best approach to doing automatic analysis of sets of tags in Excel/Access/or similar?

I have a large set of open-ended responses to a survey (~10,000), and each has been assigned a set of tags representing what the person has said in the response. This data is sitting in an Excel ...
2
votes
1answer
398 views

Can I do a Multiple Regression with Excel?

I have performance data for 3 years for about 50K employees. Each employee has 3 ratings associated with them. I would like to create an equation that will predict (or try to predict) the future ...
1
vote
2answers
136 views

Excel - plot rate of occurrence of certain event

I'm analyzing logs where I have the times where a certain event occurs, example: t=1.05s t=2.25s t=2.26s t=2.35s t=3.40s I want to be able to plot the rate of occurrences/second in order to see how ...
0
votes
0answers
16 views

Analyzing customer arrival trends in Excel

I'm trying to figure out how to analyze some data with Excel and need some assistance wrapping my head around how to do it. Specifically, I need to present charts or tables that show how customer ...
1
vote
1answer
344 views

Excel price function not working despite adding the analysis tool pack

I am trying to price bonds using the Excel function, PRICE(..), but the intellisense doesn't come up. The help file says to install the analysis tool pack, but this doesn't resolve the problem. I have ...
3
votes
2answers
1k views

Excel Free Text Survey Analysis

I have to analyze a survey. The survey consists of some yes/no questions, some numeric questions and some questions like the following (free text where respondents have entered multiple answers). Do ...
2
votes
1answer
1k views

Excel 2010 not displaying calculated measures as currency

When connecting Excel 2010 to a SSAS 2008 R2 datasource, calculated fields(Standard Margin) do not display with the appropriate currency symbol. When I define the measures in the cube, I am setting ...
0
votes
1answer
19 views

How do I identify partial duplicates in an excel list?

I have a list of over 1000 company names, however some are duplicated but they aren't exact duplicates (ie: Nintendo, Nintendo Inc, Nintendo Video games, etc), is there a way to identify the ...
1
vote
1answer
28 views

Generating Repeating Data

I have 4 data items in column B. Initially I needed to fill another column with the original data repeated 7 times. So the first item should appear 7 times, then the second item should then appear 7 ...
0
votes
1answer
3k views

Changing cell values based on another cell

Lets say that I have 3 parameters/cells: High (Cell A1) Medium (Cell A2) Low (Cell A3) the fixed values for these cells are 2, 2 ,2 how can I change the value of cellA1 based on the changes of ...
0
votes
2answers
41 views

Measuring Noise in Excel

I have 2 datasets: One looks like: 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 The other looks like: 1 3 3 1 1 3 1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 2 3 2 1 1 3 ...
0
votes
0answers
31 views

White space between columns in Excel

There are white spaces between columns in excel when I have conditionally formatted them to shade depending on row. How can I fix this?
0
votes
1answer
17 views

How to assign a unique text per group of entries in a column?

I have a list of employees in Column A and a location in Column b(empty). I need to assign a location for every twenty employees which its value on another sheet on column a. thanks
-1
votes
0answers
17 views

enroll employees different labs [on hold]

i have a sheet (column a) serial from 1 to 9000 , (column b) employee name ,(column c) training lab no# and another sheet that have a list of training labs(training lab no1,training lab ...
0
votes
0answers
24 views

Problems with excel formula

I created a sheet with tables and I duplicated that sheet to create 3 more. Then I added formulas in tables in first sheet where I used table cells from other sheets. All formulas were structured ...
0
votes
3answers
30 views

split a column in excel into two columns keeping leading zeros

How to split a column in excel, keeping leading zeros? example: column1 column2 column3 +260 0974587 +260 0974587 +667 0007894 to +667 0007894 +447 4785540 ...
1
vote
0answers
24 views

Excel doesn't create structured formula for all tables

Structured formula case I am facing 2 weird issues with Excel 2013. I have been mainly using the tables. Initially when I created the sheet and inserted tables and added formulas, they were all using ...
0
votes
0answers
14 views

Windows 7 Professional Taskbar Grouping Disappears (Not using Aero Theme)

I like using the grouping function with Windows 7, yes our company is still on Windows 7. However, when using Outlook 2007, ("yes 2007") and excel 2007 when I have multiple emails or excel files open ...
0
votes
1answer
30 views

Creating a formula that analyzes whether or not individual was served between two dates

I am writing a grant report in which I need to count the number of individuals who received a service during a specific quarter. That is, if the person was in our shelter any day between 10/1/2015 and ...
0
votes
0answers
24 views

How to assign different sets same value…? [on hold]

I have a list of employees as a serial that starts from 1 up to 600 and I need to assign every 20 employee starting from 1 to different location and what if I needed to assign every location ...
0
votes
1answer
26 views

Spreadsheet formula for adding all values adjecent to multiple instances of text cells

Given a table with unique and duplicate text values in a column with number values adjacent in the following format: A|12 B|23 C|98 A|66 D|86 E|3 B|25 A|65 . . . The values are simplified for the ...
0
votes
2answers
3k views

Exporting Attachment File Name + Email Metadata from Outlook to Excel

I am looking to do analysis on all of the file types that I have received in a folder in Outlook. I have tried using the Export functionality in Outlook, as well as importing Outlook directly into ...
0
votes
1answer
31 views

Excel IP address pattern

I have data set (COL A) that is mixed IP addresses, and hostnames. I have a separate sheet that is a capture of the DNS records. I would like to create a formula that will do an index match on those ...
1
vote
1answer
13 views

Fill the excel table based on a value

I have a list of items in excel, with the description and price for every one of them in the columns next to them. The example below: Item 1 description 1 500 Item 2 description 2 6000 Item ...
0
votes
1answer
29 views

How to disable right click “delete” option on worksheets tab

Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook ...
0
votes
0answers
12 views

How to insert online pictures into excel with VBA

I want to add images from my web image repository so I have all the hyperlinks in row 3 (C3:L3) and in row 2 (C2:L2), I would like to automatically insert the image whenever I press the Display image ...
2
votes
1answer
3k views

How should I share workbooks that use PowerPivot?

I've used powerpivot to make a super-awesome report. But now I need to share it with my co-workers, who do not use powerpivot. When I send someone a powerpivot report to users without powerpivot ...
0
votes
0answers
16 views

Search tool using keywords on Excel data or a keyword based corresponding code and description search : The file needs permission

I am a basic level Excel user. I need some help on preparing a look-up tool using keywords as described below: I have a list of 1000 different product/service descriptions along with their respective ...
0
votes
2answers
12 views

dble clicking the drag down only auto fills 100 or so rows

Is there a way to drag a function down all of the rows (30000) rows for example the double click feature is only filling the first 100 rows
-1
votes
1answer
24 views

Creating auto-shapes in excel based on cell values

I'm trying to create (and maybe I shouldn't be using excel at all) a calendar with gantt chart style display in excel. I know there is software that is designed for gantt charts by themselves. That's ...
0
votes
2answers
24 views

How can I specify a range in a formula?

I know that a formula can be applied on a range of cells by utilizing an intermediate column, but can I directly specify a range in a formula somehow? E.g., is it possible to do something like this, ...
-1
votes
1answer
13 views

Single pie chart input from two excel sheets

I want to make a single pie chart which takes input from two different excel sheets. For example: My excel document has 3 sheets( sheet 1, sheet 2, sheet 3). I want to make a single pie chart in sheet ...
0
votes
3answers
37 views

Excel 2010 Specific cells for formula input cell arguements

Col A Col B Col C Row 1 a a a Row 2 a a a Row 3 a a a I am trying to set a specific range in the COUNTIF function, =COUNTIF(range,criteria). Example ...
2
votes
0answers
23 views

Copy hyperlinks from original list to search index list

I've created a search index (using formulas) from a list of products that have hyperlinks attached (created with Insert Hyperlink). The search index is created without the hyperlinks however. Both ...
3
votes
0answers
48 views

Checkbox location changes when workbook is opened in Excel 2010

I am using Excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell. When I open it at work with Excel 2010, all the ...
9
votes
2answers
2k views

Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format?

I work with many CSV files, and am constantly annoyed by the Excel dialog that pops up when I try to save a file: "[your spreadsheet] may contain features that are not compatible with CSV (Comma ...
10
votes
3answers
99k views

Quick replace #N/A by 0 when vlookup

I use vlookup a lot in excel. The problem is with #N/A value when the seek value is not found. In that case, we often replace it by 0 using if(isna(vlookup(what,range,column,false));0; ...
1
vote
1answer
21 views

Pie Chart in Excel, is it possible to have a slice for a remaining balance?

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd ...
0
votes
1answer
17 views

Check cell value for active conditioning format being applied?

Is there a way to check if a range of cells have a certain conditioning format on them such as cell is highlighted if blah blah blah... ?
0
votes
1answer
32 views

Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this: Actual End Date ----CP 2016-04-22------------4 2016-04-26------------3 2016-04-26------------9 2016-04-22------------7 ...
0
votes
1answer
20 views

Merge data from three columns

I would like to merge the contents of three columns into a single column. I need to use a nested if formula as the columns take precedence over each other. Example column A1 may or may not have data. ...
1
vote
2answers
3k views

Workbook doesn't find macro

I created a macro in a workbook which is being used by several persons on their own computers. For some of them, it seems to work fine, but for other a message appears that it can't find the macro on ...
10
votes
9answers
49k views

How to toggle Scroll Lock in Excel 2010 without a Scroll Lock key in the keyboard

I have a notebook with no Scroll Lock key (or any shortcut using the 'Fn' key). Somehow Excel 2010 got the Scroll Lock on. I see it left down in the status bar and now I can't navigate through cells ...
0
votes
0answers
14 views

Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data: 1st column is the name of the Route 2nd column is Time1 in decimal hours 3rd column is Time2 in decimal hours 4th column is TimeDifference in decimal hours (or decimal ...
0
votes
2answers
27 views

how to copy a function over thousand of rows without losing cell spacing?

I have a spreadsheet with thousands of rows and every four rows I need to take an average of the cells in those rows =AVERAGE(F2:F5) is there a code that will save me copy and pasting this formula ...
0
votes
2answers
35 views

Date stamp when editing rows in spreadsheet

I have a spreadsheet which needs date stamp for each row as soon as there are changes being made in cells within that row. For example, I change something on cell B14 or E14 or G14 and today's date ...