**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**4**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**3**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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 ...