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)

-2
votes
0answers
24 views

How to have cell text from one tab show up on another tab?

I have several worksheets in my excel file. One worksheet has the information for Company A, another worksheet has the information for Company B Company A Worksheet: | DateA | CheckA | ...
-1
votes
0answers
22 views

How do I create a chart showing distribution of values from a list?

I have the following list of values, representing time duration of operations in seconds: 5,5 4 6 6,1 3,7 9 9 9,1 I need to create a chart showing frequency of operations based on their ...
0
votes
0answers
18 views

Efficient removal of duplicate records across multiple Excel sheets

I have a workbook with 2 sheets. Sheet 1 has 3 columns (1A, 1B and 1C) and sheet 2 has 2 columns (2A and 2B). Now I need to delete rows from sheet 1 if 1A and 1B match any row in sheet 2 (i.e. 1A=2A ...
0
votes
2answers
30 views

How to plot positive and negative values on both sides of the axis in Excel?

Could anyone please tell me how is it possible to plot a graph in Excel or LibreOffice in which different values for a single variable can be plotted on both sides of X-axis but in a way that both ...
0
votes
1answer
14 views

Excel Pivot: make 1-dimensonal data 2-dimensional

I have an Excel table with a structure as follows Customer1 Domain1 Domain2 Product1 ... Customer1 Domain1 Domain2 ProductN Customer1 Domain2 Domain3 Attribute1 ... Customer1 Domain2 Domain3 ...
-1
votes
0answers
16 views

How does Excel to recognize the header row when filtering?

I have googled a lot ,they all pointed that the spreadsheet would "guess" the header row.But I don't know how to guess.What are the rules when guessing a header row?
0
votes
0answers
13 views

Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...
5
votes
4answers
482 views

How can I record a transition from a 0 to 1 in a column in Excel?

I need to record the number of transitions from a down state (0) to up state (1) in a single column in excel and I am wondering whether there is some kind of logic like this available in Excel or ...
0
votes
2answers
28 views

Identify records with multiple IDs in Excel

I have a spreadsheet which is an export from a CRM database. There are two fields, email address and ContactID which I need to run a check against. I need to know for a given email address, if it has ...
1
vote
1answer
23 views

Excel 2010 : How to compute the number of non blank cells in a column among the entire workbook

Let's say I want to compute the number of non blank cells in some column (A for exemple) among the entire workbook, for a fixed range of cells. How can I do this ? knowing that for just one worksheet, ...
0
votes
0answers
35 views

Advanced 'text to columns' in Excel - is there an add-in/macro available anywhere?

Often I need to split text which has multiple differing delimiters or other difficulties that the default 'text to columns' tool cannot handle e.g. ignore the first x columns Is there a ...
0
votes
0answers
45 views

Check if substring of cell in one row matches with another cell on column values in another row

I have a table with 2 columns (ID number, Description) as shown below: ID no Description 1001 A letter to george william 1001 ...
3
votes
1answer
51 views

Excel Formula to Check if a Word Begins with a Keyword

As the picture shows, I have 3 keywords from cell A2 to A4: a, bb, and ccc. I have 5 words to check, listed in B2:B6: aa, bb, bc, ccand d. I'd like to check, for each word in Column B, that if it ...
0
votes
1answer
17 views

MS Excel: Count the max spaces between a number frequency

I have a column of numbers (i.e. 7,2,5,2,6,7,5,3,7,8,9,2,3,5,6,7) What I am trying to do is count how many numbers are between each 7. Not just the first, second, third, etc. but each instance. So, ...
0
votes
1answer
14 views

Excel cell value (text) based on 2nd cell value (number) appearing in a named range

I have a spreadsheet where I want a contact name to appear in a cell (F166) if the department number (P166) appears in a named range ("PS Depts" on Sheet2). Here is my existing formula, but it only ...
0
votes
1answer
16 views

How to dynamically copy data to other sheets in Excel

I have one sheet with master data and four sheet with sub-sets of the data. I want to copy entire row contents to other sheets named ABM-I, ABM-II, ABM-III, & ABM-IV based on the 4th column "ABM". ...
0
votes
1answer
26 views

Excel - how can I count rows based on three column values?

I have the following columns: bonus1 bonus2 bonus3 1 2 3 4 1 2 3 4 0 0 0 0 I want to count each row once if the any of the columns is ...
0
votes
1answer
38 views

Identify in what of the given ranges is a random number

I have this table with the first column being just an Identifier Code and the second one being the ranges. So for example if a number is between 0 and 1134, it corresponds to the first row ...
0
votes
1answer
26 views

Excel logic AND and OR functions

Does my formula below need to read (Occupancy=1)*(Gender=2) to consider the occupancy for both genders? =(MIN(IF((Occupancy=1)*(Gender=1)+(Gender=2),Gross_Rev))) I guess as a general question, ...
1
vote
2answers
38 views

searching for a set of strings in Excel

I have set of terms and a set of strings that may or may not contain one or more of those terms. I'd like to search for if there is a match for one or more of the terms. Search terms (cells A1:A17 in ...
0
votes
0answers
26 views

Macro to increment date from a start date to finish date

I'm a beginner in macros. I have start_date value in cell B4 and end_date value in cell C4. I need a macro that can write the dates from a start_date (the saturday just before the start date) to ...
0
votes
0answers
15 views

Excel 2010 “lastcell” issue with formula in complete column

I'm currently using a formula throughout a column in an Excel 2010 worksheet. It works fine, but I'm not really using the entire worksheet, I only don't want to have to worry about adding the formula ...
0
votes
1answer
34 views

Changing the maximum value on an axis in Excel 2013

How do I change the max value on the axis option for Excel 2013?
-1
votes
1answer
39 views

split information in single cell to multiple cells [closed]

I have this information in an a single cell Please register for me: NAME: Zaki Bin Manjoy PS NUMBER: 675676 DIETARY PREFERENCE (halal/vegetarian): Halal LOCATION: KFELS MPH KOM Tower Level 10 ...
0
votes
1answer
25 views

organizing columns in excel into standard format

I have data in a excel spreadsheet in a regular pattern that needs to be organized in a format friendly to statistical analysis. Here is the format: Clinton 29.30% 22 Edwards ...
0
votes
1answer
13 views

Does Excel 365 vba (or 2013) have the vbscript Regular Expression that found in Excel 2010

I'm considering moving to the cloud, but I use a lot regular expressions in Excel and was curious if Excel 365 had vbscript regular expressions.
0
votes
1answer
33 views

Find First Letter in a String

I need a formula to find and return the first letter in a string. So if a cell contains: 1234(*&^%$23ADFG54 the formula would return: A EDIT#1: I am currently using the following UDF: ...
0
votes
1answer
37 views

VBA code not working due to syntax error

I'm new to VBA. My objective here is to create a function to show the lowest price of a steam item, given a URL. Here's the mash-up code I've put together so far. However, there seems to be a problem ...
0
votes
2answers
79 views

Color scale for text values in Excel

I would like to apply color scale on text values. But unfortunately, it works only on numbers! I’m doing this to easily identify the repeated values sorted by other column. This image explains the ...
0
votes
2answers
35 views

Make Excel marks the repeated rows with a lot of data in each row

I have this Excel archive with 5 columns of data, and then, about 4,000 rows of different data for each column, but I can’t find a way to make that Excel marks the repeated rows? I have tried using ...
1
vote
1answer
35 views

Chart format corrupted or size is wrong when I copy from Excel 2013 to Word 2013

When I copy charts from Excel 2003 or Excel 2013 to Word 2013 the charts are corrupted: the fonts are too big so the titles and legend text is a mess. If I don't want the chart to update in Word ...
0
votes
1answer
25 views

Excel 2013 charts - how can I setup default chart with distinct line colours and fonts as in Excel 2003

The default line colours in Excel 2013 have poor contrast and are not easily distinguishable. I would lie to use the same chart colours, fonts, borders, symbols etc. as was in Excel 2003. How can I ...
2
votes
1answer
54 views

Unable to enter anything into a cell

While working on a Excel for Mac, I suddenly cannot enter any data in ANY cell. Also the same thing with all my spreadsheets, unrelated to the one I was working on. I can type numbers and letters on ...
1
vote
4answers
167 views

Count the number of rows with equal values in two specified columns

I have two columns in MS Excel/LibreOffice Calc/Google Spreadsheets with numbers. I would like to count the number of rows which have identical values in both columns. In the following example: ...
-1
votes
1answer
30 views

Excel formula to collect data

I have this type of table in Excel: A | A1 B | B1 A | A3 A | A4 B | B3 What I need is to create a new table where the data would look like this: A | A1, A3, A4 B | B1, B3 Is ...
0
votes
1answer
28 views

Sum values in range if lower than a threshold otherwise sum the threshold value

As per the title, the best I could come up with is this, however it yields an error. My unremarkable knowledge of Excel prevents me from making further progress. This example formula should add all ...
0
votes
2answers
35 views

Excel: how to remove leading characters of a string with a function?

I have a text column in Excel full of hexademical values like this: 0000000000000c10 00000000000036f0 00000000000274da 00000000000379e0 Which function can help me strip the leading 0's up until the ...
0
votes
0answers
19 views

excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon) layout data labels more data label options... then it automatically slaps ...
1
vote
2answers
60 views

Macro for cleaning all sheets in a workbook (VBA - Excel 2010)

I have a macro file with 5 sheets and I would like to add a VBA command button into the same file to clean all workbook contents with a single click. Does anyone know how to do it by using VBA on ...
0
votes
1answer
18 views

Can I filter out all rows corresponding to reference list in excel

I have a list of IDs that I would like to select in a excel sheet. I am used to using the filter function to search for 1 ID, but now I would like to filter out all the rows with that match the ID in ...
0
votes
1answer
20 views

Excel formula - Return value from lower row

I'm looking for a way to search for a value in a single column and return a value in that same column two below it. Example: A1: Apples A2: Bananas A3: Oranges A4: Pears If I search for ...
0
votes
2answers
21 views

Why is using this code to replace a formula giving me an error?

In Excel I use the following to clear cell E5 and replace it with the word name. Sheets("Invoice").Range("E5") = "Name" I can also use the following to replace G11 with the VLOOKUP code I have here ...
1
vote
2answers
32 views

How do I format cells in one column based off cells in another column?

So I found some similar questions to this already answered here, but they don't go deep enough for what I want to do, and was hoping to find some more help. At a high level I want to format some ...
-1
votes
0answers
25 views

How to write % change formula in Microsoft Excel

I have a spreadsheet that I am building and I need to show staffing level changes. I currently have several cells with 0 counts that will be changing to 1, 2 or 3. How do I write the formula to show ...
0
votes
1answer
26 views

Excel Conditional sum on same row

I have a rather basic Excel question, but my Excel skills suck. What I want is a conditional sum, but I'm not sure how to do it. Example: A B C D E ...
0
votes
1answer
20 views

Excel saves absolute references to other sheets in my workbook. This causes problems when emailing the workbook to colleagues

I have this the following problem. I create a pivottable and set a reference to anther Sheet, for example: =Sheet1!A:C When I save, copy, cut and paste file to various locations, I end up with the ...
0
votes
0answers
19 views

Scan only to excell cell

I am trying to set up a system where particular cells on various spreadsheets can only have data scanned into them. It will also be necessary to disable the ability to input data into that particular ...
1
vote
2answers
41 views

Formatting of output .csv file generated by a software

I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. In my colleague's computer, the same software outputs the ...
0
votes
2answers
25 views

Finding the right graph to display inter-department connections [closed]

I have a task of displaying the interconnection between departments at my university. The idea is to show how many departments come together to work on a project. The data I have lists the projects in ...
-1
votes
0answers
26 views

Macro to update Date in Specific row in excel

I want macro to update current date in cells M10, M15, M18 and M19 Ex: If format of the date is 01-11-2014,then, macro should update cells M10,M15,M18:M19 with 1 ...