**0**

votes

**0**answers

5 views

### Displaying data in Excel Pivot Tables

I am working on a project and being able to use a pivot table would make life much easier. I need essentially for one column to become the column labels which is fine, however I would like to display ...

**0**

votes

**0**answers

4 views

### Excel - Pieces of data from large chart sheet 1, auto sort on sheet2

I have a large chart and need to take small pieces of data (3 cells each for 14 rows) and have them stack ranked on the second sheet. I need A21:A34 (Branch Name), M21:M34 (% of Goal) and K21:K34 to ...

**0**

votes

**2**answers

19 views

### Sorting rows in Excel 2013 based on when they were added

Is there a way to sort rows in Excel 2013 based on when the rows were added?

**0**

votes

**1**answer

7 views

### Format as currency within a formula

I am trying to sum a column of dollar amounts and label it as "Total: $xx,xxx.xx" in the first row of that column.
I have gotten as far as
="Cost - " & Text(SUM(B2:B), "$0.00")
BUT, it is not ...

**0**

votes

**1**answer

12 views

### Excel: Calculate IF column based on another IF column

I am trying to use Excel to create a scorecard for different companies to use. The product I create needs to be a finished product - when a company representative fills out certain information on ...

**-4**

votes

**0**answers

21 views

### Creating Rules in Excel Spreadsheet [on hold]

I have the following problem. I have a spreadsheet which has different cells that I need to to create some rules in the spreadsheet so cells turn red if a position is named and not posted and if a ...

**1**

vote

**1**answer

21 views

### Counting how many fall within a time range based on specific text

I am trying to produce a fomula that counts how many times and indivioudal registers a time between acertain time range. So the table below is part of the data so for example how many times did ...

**2**

votes

**0**answers

21 views

### Looping through master sheet and filter out rows that are needed

I have created a script which I want to allow a user to select a file (Master File) and if a condition is a met I want to Copy the data to the excel workbook (which the script is run on) The code ...

**2**

votes

**1**answer

30 views

### Update an existing cell in Excel without circular reference

Please note: I am aware that the function I am using will cause a circular reference. I am trying to find a work around for this problem.
I have a simple excel report which I use to fill in weekly ...

**-1**

votes

**0**answers

21 views

### How to convert microsoft excel spreadsheet into mobile-friendly html table?

mobile-friendly html table
microsoft excel spreadsheet data pattern
| h1 | h2 | h3 | h4 | h5 | h6 | h7 |
|----+----+----+----+----+----+----|
| | d | d | d | d | d | d |
| ...

**0**

votes

**0**answers

17 views

### Excel Combo Box Refresh Dropdown?

Is there a way to refresh a combobox?
I have the following VBA code.
The dropdown is populated, until the If statement where the list is cleared and populated with the matched items.
at this point, ...

**-1**

votes

**0**answers

6 views

### Change format of data label of pie chart (in Excel 2007) dynamically satisfying some conditions

I have made a Dynamic Pie Chart in Excel 2007. It has a Data Range that changes dynamically using Form Combo Box. I would like to have a VBA code that checks each Data label of Pie chart with ...

**0**

votes

**0**answers

6 views

### Pivot table filters replace values on their own

I have a pivot table connected to a table in SQL. When I create the pivot table for the first time, all the filters display the correct information. Once I start applying filters however, some of the ...

**-3**

votes

**1**answer

36 views

### How to create this Excel function (formula)? [on hold]

I'm trying to create an Excel formula:
If (B20<=750 and B20>=850 and B22>=135 and B22<149) then B15*.16 otherwise 0
It is for this graph
PVR
Penetration 0-749 750-849 ...

**-1**

votes

**0**answers

23 views

### Find first value above 0 in Column A and B then find the first value above 0 starting from the row where the previous value came from

I have column A and B which are filled with values, mostly zeroes. All other values are above 0. If a value is above 0 in column A it will always be 0 in column B and vice versa.
I now want excel to ...

**-1**

votes

**0**answers

32 views

### Combine data from monthly sheets into totals on another sheet

I have an Excel workbook with different sheets per month for salary details, with columns being Employee Name, Basic, HRA, Conveyance, etc. I want the sum of all these components in a different sheet ...

**0**

votes

**1**answer

31 views

### Count rows matching criteria for every row in excel

Hi here is a sample spreadsheet:
+--------+-------+-------------+-------------------+
| Animal | Count | Animal Type | Animal Type Count |
+--------+-------+-------------+-------------------+
| cat ...

**0**

votes

**4**answers

27 views

### Format percentages in Microsoft Excel

I am trying to format the following column in Microsoft Excel to add the percentage sign after the second decimal:
5.8394
3.2922
3.2
4.461
1
I highlight the column and choose Format cells > ...

**0**

votes

**1**answer

8 views

### Multiple row calculation with one fixed value

I have a calculation like this
=B8+((B2-1)*C8)
I want to multiple these calculation by just dragging it down. So I don't need to type the calculation for each row. The values B8 and C8 shall ...

**0**

votes

**0**answers

10 views

### Excel - Conditional formatting retention through data validation in another sheet

I have applied conditional formatting in an Excel sheet (Sheet2) to change the font color in column A if the result in the adjacent cell in column B is "No." I then used this conditionally formatted ...

**0**

votes

**0**answers

17 views

### I want to hide rows in Excel 2010 using VBA if a cell value is blank

I can get the VBA to work just fine to do this, but my spreadsheet is 20MB without data. What I want to do is find the first time a cell is blank and then hide every row at once from that spot until ...

**1**

vote

**1**answer

11 views

### Inserting formula through VBA in “A1” reference style

I insert this formula through VBA,
Cells(1, 1).FormulaR1C1 = "=LEFT(A2;5)"
But the formula which gets inserted ends up with apostrophes.
=LEFT('A2';5)
This works perfectly with the R1C1 ...

**0**

votes

**1**answer

25 views

### How to make a macro universally usable on multiple workstations with different usernames

I have a macro that I built for a specific work related task. I share this macro with a few people by sending them the .xlam file as an addin. No problems there.
My problem is that some of the code ...

**0**

votes

**0**answers

15 views

### Can i have a transparent slider in Excel?

I want a transparent slider element in Excel. What do I have to set for BackColor? Right now it is: &H8000000F&
In the end I want a slider Element which changes colors on slide.

**0**

votes

**0**answers

38 views

### What is the most useful way to chart word frequency over time? [on hold]

I want to create a chart displaying word frequency in a newspaper over time. I'm looking to chart specific words (not all words). I thought a scatter chart would be best. I would like to have the ...

**0**

votes

**1**answer

31 views

### Excel Formula with conditions

This feels like it should be simple but my head is hurting now and I'm struggling.
I need to add a condition to an existing sheet which already contains formulas and references to other sheets.
...

**0**

votes

**0**answers

11 views

### Copy Blank Count

i want to copy the blank color count under Color column from "5-Jul-15" sheet and "6-Jul-15" sheet to ABC sheet under "5-Jul-15" and "6-Jul-15" column (i.e. C13 and E13) respectively.
It should ...

**0**

votes

**0**answers

3 views

### Excel for Mac conditional matching statement

In Excel for Mac.
What I am trying to do is create a formula in cell A13 that will take a value from cell A1 and look for a match from a a list of multiple values from a list (column a) from tab b. ...

**1**

vote

**1**answer

33 views

### Excel - duplicate search and replace - 2 sheets

Let me rephrase the question. When a cell in column A sheet 1 matches a cell in column A sheet 2, take the value on that row of sheet 2 column e and replace the value in column E sheet 1 with it on ...

**0**

votes

**1**answer

36 views

### Searching for multiple sub-strings within a single parent-string

I've been searching all day for a similar question to mine. Many questions come close, but my questions is a bit different:
I have a list of last names in Column A. In Cell B1, I have someone's ...

**6**

votes

**4**answers

171 views

### Excel: Average numbers if another column contains a certain substring text

I'm looking for a way to average the numerical numbers in one column, say B, only if the string in column A contains a certain text.
For example:
(In column A) (In column B)
Hello table . . . 1
...

**1**

vote

**1**answer

15 views

### accessing excel workbook in cloud with hyperlinks

I have an excel workbook that has hyperlinks to PDF documents. This workbook gets updated daily with new hyperlinks to documents.
I need to be able to have others access the excel document and be ...

**0**

votes

**1**answer

14 views

### Word macro referencing Excel worked in Office 2007 but fails in 2010

I created a VBA macro in Word 2007 that determines if Excel and a specific Excel workbook is open, opens the workbook (and Excel if needed), then performs various tasks in the workbook. Under ...

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

45 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

50 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

755 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

16 views

### how to put formula in a single cell through data validation (list) option

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

31 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

17 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

35 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

41 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

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