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
1answer
11 views

Excel: Month() Formula Returning Wrong Value

I have a Sheet that has dates in Column B and Numbers Column X to be Averaged by Month in the formula I am using is as follows take for instance the month of February ...
0
votes
1answer
13 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
0answers
6 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
2answers
22 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
1answer
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 ...
2
votes
1answer
16 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
0answers
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
1answer
23 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
0answers
23 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
1answer
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
0answers
22 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
0answers
19 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
0answers
12 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
0answers
7 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
1answer
37 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
0answers
24 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
0answers
34 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
1answer
32 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
4answers
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
1answer
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
0answers
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
0answers
18 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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
4answers
174 views

Average numbers if another column contains a certain substring text in Excel

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
1answer
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
1answer
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
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
47 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
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
4answers
756 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
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
1answer
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
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 ...