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
0answers
14 views

Text is being duplicated in OpenOffice - How can I stop it?

I generally do not use OpenOffice. However, my Microsoft Office decided to deactivate itself recently, and will not reactivate due to the product key being used too many times (which it hasn't). I am ...
0
votes
1answer
18 views

Microsoft Excel: Merge two sheets and dedup

I have a pretty simple question and google can't seem to return what I'm looking for. Essentially I have two sheets in one workbook, both contain the exact same columns. The primary key (and first ...
0
votes
1answer
15 views

Create filtered connection in Excel

I have created a connection between two Excel files, however when I create multiple a pivot tables off this connected data, my file size dramatically increases. I understand why this is happening (a ...
-2
votes
0answers
50 views

lookupvalue and return multiple values in Excel do not work

I need to pull through multiple unique IDs for expenses. i.e. one timesheet consists of 5 expense payments for one date, but each of these expenses for that day contain individual unique ID. I need to ...
-1
votes
1answer
51 views

How to generate controlled replications in excel

Basically, I have a dataset with three columns: Start date, end date, and number of replications. I need to generate one column data from this dataset like following regarding the number of ...
6
votes
4answers
759 views

Can I sort the text after a certain character?

I have a large list I'm trying to sort but I'd like to sort the list from the value after a certain character. eg: 241&name=A 123&name=C 645&name=B So I'd like to sort the list ...
0
votes
0answers
18 views

Excel Issue- update from one excel [on hold]

I would like to update an excel based on values from other excel. Issue I have two sheets in a work book. Master, Updator. In updater I update some values. Updator Data ( two columns) CR ...
0
votes
1answer
17 views

how to put formula in a single cell through data validation (list) option [on hold]

I want to put many formulas in a single cell this way I can see ans. for sum, max, min, of a particular selected rows or columns in that cell. please help me through this quire.
0
votes
1answer
35 views

How to Highlight entire row of a Table using Excel VBA

I'm using a UserForm, to enter data into a worksheet. I'd like to use a Checkbox to highlight the entire row of a table. Example code: Private Sub AddModifyAtRow(ByVal lRow As Long) cIndex = 0 If ...
0
votes
0answers
27 views

Having trouble graphing big data in Excel (3500+ rows, 2 columns)

I really need with help this issue. I'm trying to show a relationship between two categories but the only problem is there's too much data! Problem: Is there a relationship between X and Y? X and Y ...
0
votes
0answers
18 views

Is this possible to generate excel combo box based on cell value?

As you can see, Cell C2 got 1,2,3,4. I assume this is a student id. So, I would like to generate a combo box in Cell B8, using Cell C2's data, separated by ,. So, in this case, the combo box should ...
1
vote
1answer
17 views

How to import several worksheets from a single Excel file to Microsoft Word document as linked and updateable objects?

I have an Microsoft Excel file with several (about 10-20) worksheets. All sheets should be stored in one Excel file, because they are connected to each other (calculated values). Now I have to create ...
4
votes
1answer
36 views

Add multiple series to a dynamic chart

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...
0
votes
3answers
22 views

In excel, how do I group duplicates according to whether or not they meet a certain condition?

I have a list of people with each row showing a person, and their usage of a platform in percentages. if a person uses more than 1 platform, they will appear in multiple rows, each for a different ...
-5
votes
1answer
42 views

Divide a number into descending values that equal that number [closed]

I want to take 523,728 and divide it by 42, but instead of the numbers all being 12,469.71, I want them to be in descending order. So the first number is the highest, the second is lower, etc. so ...
0
votes
2answers
24 views

Counting number of each item assigned to customer with unlabelled columns

I have a table in Excel as follows: 1 2 3 4 5 6 7 Customer1 Z U A C D A A Customer2 B D J S F D B Customer3 S A C A A B B Customer4 X H A C D A A ...
3
votes
3answers
283 views

How do I keep a running Subtotal/Sum in Excel?

I know this is probably a super simple question, but I have no clue how to word it in Google so I could find out on my own. I have a spreadsheet in Excel that's basically a shopping list: ...
0
votes
0answers
6 views

How to maintain cell size in Excel, but add scroll bar to view text within call?

I have an excel document that I have created and I do not want to loose the formatting of the page when text is entered into a cell. I currently have the "wrap text" option on in the cells, ...
-2
votes
0answers
27 views

How to Split two or more columns in Excel into multiple columns? [closed]

I have a list with two or more columns and I would like to split that into two or more multiple columns on a separate sheet. An answer by Scott - http://superuser.com/users/150988/scott - only gives ...
0
votes
1answer
49 views

How to make an Excel list which changes based on another list?

For example, I have a list with two items, "fruits", and "vegetables". When someone selects "fruits", the second column displays a list of fruits. When someone selects "vegetables", the second column ...
0
votes
1answer
11 views

I cannot insert a bar chart in PowerPoint

In rerence to a previous post I too can no longer insert a chart into powerpoint. When I select chart type it allows me to click but then blinks at me and does nothing. My IT guys have looked into ...
0
votes
1answer
20 views

Comparing and Updating multiple excel sheets within a single workbook

I have 4 sheets of names, some of which may exist in one or more of the other sheets. What I need to do is, compare all 4 sheets of names and create a new sheet ( Master List ) of all names from each ...
1
vote
3answers
55 views

Summarize tables of several sheets into one final Table Excel and include new sheets in summary

I have got several excel sheets, every single one of them containing a table for user information and one last sheet which contain the sum of all the previous tables. Since my table is very big, is ...
1
vote
3answers
48 views

How to hyperlink to a location in a cell in Excel?

I have a cell, with a file path written in it. How do I make it that so, when you click that cell, it automatically opens whatever file path is written in it? Ex : if cell A1 contains ...
0
votes
0answers
17 views

Cannot insert more than 4 empty rows in an excel sheet

I currently work on billing for the company that I work for and use excel for this purpose; I use one sheet all month and at the end of the month I sort and separate participants and add an empty line ...
0
votes
0answers
12 views

Radar chart in excel - charting with intended “gap data”

I want to plot a radar chart that has cross-fire axis with text added labels at each axis. The data items to be placed between these axis points eg at 2pm, 4pm, 8pm, 10pm. I am having difficulty ...
0
votes
1answer
28 views

Count appearances of two cells in a 5x100 matrix

I have two cells that I want to compare against a 5 columns by 100 rows matrix where they can appear. I have tried this but doesn't work: ...
0
votes
1answer
46 views

Dynamic array/matrix generating within formula

The following formula: =TRIM(A1:A20) would make no sense; you typically should decide a column, write =TRIM(A1) on first cell and copy until =TRIM(A20) ... BUT ... suppose you want/need to use it ...
0
votes
0answers
32 views

How to convert dd.mm.yy date format in excel 2007 date

Please help me to get excel(2007) date format 'DD-MM-YYYY' for the following non-standard date format. " 01.11.65" having leading space. "'01.11.65" having leading single quote mark. "15.11.50" ...
0
votes
0answers
12 views

Google spreadsheet count words

I have spreadsheet: https://docs.google.com/spreadsheets/d/19GrXAFLpv6jz9OzDum-fyfP_m-RZFCNrQ0rr1vd5bYI/edit?usp=sharing I want to count percent of wins(W) in G column and write it to G1 cell. I plan ...
1
vote
3answers
49 views

How can I automatically organize data from a text file in a spreadsheet?

I have a text file like this: and I would like to organize into Excel like this: I could do this by hand manually for two data entries, but I would like to be able to automate this for a larger ...
2
votes
0answers
38 views

Use Excel to match data from a cell on a worksheet, then copy data from its neighboring column and paste on a different worksheet

I have a spreadsheet with multiple names and phone numbers next to them in each Sheet 1 - Sheet 5. Each Sheet has about 900 names on column A and their associated phone numbers next to them on column ...
0
votes
0answers
22 views

Excel Macro Security on a Network Drive

I'm working on some "high functionality" Excel sheets that will do things like add new entries to a table and automatically generate forms in Word from that data. I've got a fair chunk of the code ...
4
votes
2answers
369 views

How to count if there's a cell with certain restrictions using Vlookup?

I'm finding if there at least one cell with the first character equal to "!" Formula I have used without success: =Vlookup("!";Left(N2:N49;1);1) Why doesn't it work? And what do I have to change ...
-1
votes
1answer
37 views

excel extracting data and concatenating fields? [closed]

I have a large excel sheet which I want to extract some certain fields. Here is an example: Column 1 has a list of countries: Country: USA | UK | India | GER Column 2 has a list of route IDs: ...
0
votes
0answers
30 views

Two-way data update with Excel PowerPivot tables (Office 2013)

Background: We have two excel workbooks: Data and Visual which we are using to track and visualize activities in our project. The Data file is organized like a database: each sheet is a table (which ...
0
votes
1answer
26 views

How do you create a mailing list from excel? [closed]

I need to create an emailing list from excel that will be altered quite often into Microsoft Outlook.
0
votes
1answer
24 views

Pulling data from multiple spreadsheets [closed]

Need to run a report pulling data from 10 time tracking spreadsheets. In column C, if the job type = Artwork, then I need to pull in the data from columns A, B, D & I of the same row. There may be ...
0
votes
1answer
17 views

Format an Excel cell from VB 6.0 with an amount to two decimal places

When using vb 6.0 to make a cell, we cannot force the amount to be shown with 2 places after the decimal if the number does not have end in 1-9. For example 59.12 shows up correctly but if we try ...
1
vote
0answers
30 views

What has caused my csv load time to dramatically increase?

I have a monthly report formatted as a .csv file. It's file size is 90 MB. It used to take around 10 seconds to open. Now it takes 4-5 minutes. When I convert it to an .xlsb, it takes 10 seconds. ...
0
votes
1answer
23 views

Excel 2010, how to summarize counts based on month listed by row

If I have a set of data with a month listed for each row and want to sum various column counts by month listed, how do I do that? For example, I have 10 rows of data, with two rows being "June" and 8 ...
0
votes
0answers
32 views

Make reference in two Excel tables in order to automate a calculation

I have a table in excel. My tables stands several feature values for every month (from 1-44) The tables rows stands for the several features and the table columns for the months. I want to create a ...
0
votes
0answers
17 views

Excel 2013 PivotTable refresh slow when source data file is not open

I have an Excel workbook with ~3800 rows and ~380 columns. In a different workbook I am using a PivotTable which references this monolithic workbook. I am seeing an issue where if the source ...
0
votes
1answer
44 views

Excel Formula - Match

Can someone recommend a way to write a formula that will achieve the following. I can achieve these things individually but stringing together seems to be difficult. I have a list of orders with ...
0
votes
1answer
24 views

In excel how could I generate a row of data from another sheet?

In excel I have a sheet named "sales", and another one named "factor". In factor I have some fields for factor ID, customer name, product code, quantities and price. I want when I add this data to ...
0
votes
0answers
11 views

Excel Consolidate Choice List Data in New Tab

I have a sheet which lists a bunch of people and next to each they can select a choice such as: Barry / Choice 1 Sally / Choice 1 Dave / Choice 2 Lucy / Choice 1 Alex / Choice 2 What I would like ...
1
vote
1answer
21 views

Excel - pivot date values with max function

I am trying to pivot date values in a pivot table in MS Excel. I am getting incorrect date values. I do not want "Grand Total" as they do not apply for dates. Is it possible to do such pivots in ...
0
votes
0answers
40 views

Excel Power Query joining all text files together, need them on separate rows Basic

I am importing many files in to excel. They are text files. Using PowerQuery They have about 40 lines of data in them, all on separate lines. 0945996 G ANDERSON 1405 Saturday 8th etc etc I want ...
0
votes
1answer
39 views

maintaining a constant total of excel cells

I have a column with 3 cells: A1, A2 and A3. I want the numerical total of the 3 cells to remain constant as I increase or decrease any one of the 3 cells. That is to say, I need any increase or ...
1
vote
2answers
29 views

How do I use IF in MS Excel-Mac 2011 for 3 variables?

When I type A, B or 0 in one cell, I want to see in other two cells (separately) to show 2,1 if I type A 1,2 if I type B 0,0 if I type 0 Can someone help me how to do this? I currently only have ...