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
6 views

.XLSM file has sharing violation when saving during remote desktop use

I have a large (~5mb) multi sheet excel macro file *.xlsm stored locally on my laptop. While using the file I occasionally connect to my office via remote desktop to do unrelated work. If I make a ...
0
votes
1answer
6 views

How do I get nothing to print when using ISBLANK nested formulas?

I have 6 columns and 3 equations : E*F=G, H*G=I & G+I=J I don't want zeros to print if a cell in F or H is empty. Currently I have these equations and everything is dependent on the F & H ...
0
votes
0answers
5 views

Using value of cell to search text of another sheet and highlight cell if match is found

Scenario is a workbook with two sheets. I need a way for cells on sheet 2 to search sheet 1 and highlight themselves if they find any text on sheet 1 that matches. So cell sheet2!a2 with value of ...
0
votes
1answer
20 views

Spreadsheet autofill increase in middle of text (Lotus 123 could, Excel cannot?)

I could drag a series in Lotus 123 (25 years ago!) and it was intuitive about what should increase. For example: xyz1abc xyz2abc Would drag to: xyz3abc xyz4abc Etc. Excel seems to be able to ...
1
vote
5answers
19 views

Adding Quotations and Brackets to format of cell conditionally

I have three columns: Word | Formatted Word | Type Chicken |................| Noun Running |................| Verb If the word in A2 is a Noun, I would like B2, the formatted word, to look like ...
-1
votes
0answers
18 views

Excel table / form data transfer

(Sheet 1)I have a table with tons of lines. (Sheet 2)Data is entered in a cell in a form that looks for a specific line in the table on sheet 1 using Index/Match and fills in lines in the form. ...
0
votes
0answers
26 views

Delete duplicates and keep the row with more data

I have a spreadsheet with duplicate IDs in Column A. In columns B, C, and D, I have consent form dates. One duplicate will always only have a date in column B whereas the other duplicate will have the ...
1
vote
0answers
15 views

Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...
1
vote
0answers
16 views

Excel converting data entered to 10% of correct value

I am having a problem with all of my ExcelWorksheets. Any number that I Type into a cell is converted to 10% of the value I typed. For instance, if I type in 100 into a cell, the data displayed is ...
0
votes
1answer
9 views

Nested Ifs for personal accounting sheet

I have a personal accounting sheet with 5 columns. C is Debit, D is Credit and E is Balance. I want to do 3 things but I've been confusing myself for the past hour. If C5 and D5 are both blank, ...
0
votes
0answers
17 views

ISO Weeknumber formula explanation

can anyone breakdown this ISOWeekNumber formula and explain to me in detail how it formula works? =INT((A1-WEEKDAY(A1,2)-DATE(YEAR(A1+4-WEEKDAY(A1,2)),1,4))/7)+2 and this one? ...
0
votes
0answers
5 views

Sort a pivot table according to % of Row Total

My pivot table compute the sum of sales amount of products in different regions (row field) according to product type (column field). The values which we want is the % of Row Total (so that we can ...
0
votes
1answer
21 views

Why the excel file of xml sized large ,is it there any way to reduce it?

i am trying to open 9 MB excel file in open office calc,it takes lot time ,so i opened it with archive manager to find whats wrong with the excel file While opening it with archive manager i could ...
0
votes
2answers
25 views

In Mac Excel 2011, how to format cell as percentage or currency based on content of another cell?

As far as I can tell, the Conditional Formatting feature doesn't support percentages. You can format styles (color, font, etc.), but not the actual content presentation itself. I have two columns, ...
1
vote
3answers
29 views

How to count occurences of strings in a cell using VBA

Sub Test() Dim countMe As Integer countMe = Sheets("Data").Range("B1").Formula = "=LEN(SUBSTITUTE(B1,""|"",""""))" Sheets("Data").Range("C1").Value = countMe End Sub What is ...
-2
votes
0answers
17 views

why doesn't auto row height work in excel?

I type some text into a cell and hit enter, and part of my text is hidden. This is extremely evil because I write procedures that can cost a fortune if you do half the step. So I select all the rows ...
3
votes
1answer
36 views

Excel — Tell whether a string contains any value in a table column

Background I'm using Excel 2013. I have an Excel table named SiteCategories, with a number of Category columns, and then sites in those columns, like so: So we could get to those values using ...
0
votes
0answers
12 views

Creating Excel range given start cell and row/column offset, in Applescript [migrated]

I am trying to use Applescript to insert values into cells in an Excel worksheet. The values are held in an Applescript variable as a list of lists (see example code). I've already worked out that if ...
0
votes
1answer
25 views

Special format of date in excel

A customer wants a special format of a date column in excel. What he wants is that the date (for example 02.06.2014 and formatted as short-date) changes to a number (41792) when the format changes to ...
2
votes
1answer
28 views

How to open the Save As dialog and save as PDF

I have the following code, which gives the option to the user in the end to "Print" the worksheet I wish to modify it. The user should be asked if we wants to "Export it to PDF", if he selects "Yes", ...
0
votes
1answer
30 views

Excel T88 error

When a client opens an Excel 2013 file she will get this error. I have tried to reset Excel and also an Office 2013 Repair but to no avail. Any ideas on what creates this?
2
votes
3answers
78 views

How would I increment an alpha field in a table

I would like to increment an alpha field in a table. a000001 a000002 a000003 a000004 etc.
1
vote
1answer
19 views

How can I run a macro changing the value of the cell (no carriage returns)?

I can run a macro whenever a value is changed in a cell. However, I have to press the carriage return button to change the value of the cell. Is there any way to run a macro whenever I press a single ...
-2
votes
1answer
25 views

How to transpose range in Excel through insertion of new lines?

My data looks like this: a 1 2 b 1 2 c 1 2 I want to reorganise it so it looks like this: a 1 a 2 b 1 b 2 c 1 c 2
1
vote
3answers
32 views

How to find average of first difference in one set of column excel/google docs?

I have one column with numbers eg. 130, 131, 135, 140, 120.., I would like to find the differences eg. 131-130, 135-131, 140-135.. and find their average without using another column to find the ...
0
votes
0answers
13 views

Excel SQL Sort Greyed out

I have an excel sheet with multiple Teradata connections. I am trying to sort/filter the data by description, but I am unable to as the sort/filter button is currently greyed out. I need to keep the ...
0
votes
1answer
18 views

Excel 2010 adding to an adjacent cell

I want to add B3 to C3 leaving the answer in C3, I have tried =C3+B3 in C3, a message regarding circular references, I continue and the result becomes a zero
0
votes
2answers
24 views

Copy multiple cells (not in range) from one sheet to another sheet

I've searched all over, and I'm unable to find anything regarding copying multiple cells from different rows & columns to a single row in another sheet. Eg, Copy Cells, A10, F2, F3 & F34 from ...
4
votes
1answer
32 views

How to customise labels on a secondary axis to show student progression as a flight path in Excel?

I am trying to create a line graph in Excel that plots a student's actual progression against their predicted grade. The type of graph is called a 'flight path'. This is represented as two lines on ...
1
vote
1answer
11 views

Replace the value of a column based on the a matching value of a adjacent columns

Basically I want to replace the values of the 4th column with the numbers on the second one based on the matching country names. Country Name Country Code Country Name Country Code ...
1
vote
1answer
22 views

conditional formatting based on another value

I need a way to conditional format cell B based on the values of cell A. Basically I need B to be: Green if the values are in the same day and within the same hour of A. Yellow if its one hour ...
1
vote
1answer
8 views

How do I use Excel 2011 Personal Macro Workbook?

I realized I asked about excel 2010, but that only covers Windows OS. How can I use the Personal Macro Workbook in Excel 2011 on OSX?
0
votes
1answer
22 views

Excel 2010 VBA to remove duplicates and then sumif base on the unique data

My work requires data comparison from 2 different sources (sheet 1 is source 1 and sheet 2 is source 2). Both sheets contain duplicate values (the Delivery Order) Because I need to do this kind of ...
0
votes
1answer
9 views

Share Excel “Template Formulas” between sheets

I have a spreadsheet that takes user inputted values and performs some fixed computations to generate a number of cells. I plan to use these computations in a number of sheets with different user ...
1
vote
2answers
20 views

Move each Cell after column A on new line

I would like to export some data into MySQL, however before that I would like to format the data. I am not sure how to explain it, so I made some screenshots. How could I turn this: Into this? 1 ...
0
votes
1answer
33 views

Convert custom date to standard format

I have a worksheet that has custom dates e.g. August 26th 2015 and I would like to convert this to 8/26/15 Is this possible ?
0
votes
1answer
17 views

Look up specific string in row (not column) and return value of cell x columns left of that location

My data looks like this: Sheet 1: A B C D E F 1 2 3 a b c 1 2 3 a b c 1 2 3 a b c Sheet 2: A B a b c Now on Sheet 2 in Column B I would like to return the result of: look up each value of ...
0
votes
0answers
4 views

Failing to use a split cell range as data source for a pivottable

I want to create a pivot table from this table I have, but I want to leave out some of the rows. So, suppose I want to keep the header row, leave out the next ten rows, and use the next 10 rows. This ...
-4
votes
0answers
15 views

extract data in excel [on hold]

I have to extract records to other sheet by key field from a data base in excel sheet using Excel VBA. The code has to go over all records and when the key is Change he takes the next key and extract ...
1
vote
3answers
32 views

Excel VBA: Count # of Delimiters

I have the following code: Sub CopyTest() Dim skuRow As Integer Dim curSku As String Dim numSkus As Integer Dim impType As String Dim copyRows As Integer Dim supAcc As ...
0
votes
2answers
38 views

Aligning Stacked Bar Chart w/ Scatter Plot Data

I have a scatter plot that has several data points at regular intervals, e.g. (8, 10) (8, 15) (40, 12) (40, 9), etc. I'd like to have a stacked bar chart that lines up with these intervals, but so far ...
3
votes
1answer
25 views

Varying Format Part Number Sort Issue

(Current Sort Sample:) 2-1203-4 2-1206-3 2CM- 3-1610-1 3-999 … AR3021-A-7802 AR3021-A-7802-1 B43570- B43570-3 I am working on an 8000+ record parts list. The challenge I am running into is that ...
0
votes
0answers
26 views

Excel x64 file corruption in .xlsb files for Office 2013

I have a number of Excel files, all created in Office x64, all in .xlsb format and all containing macros. Every now and again, these files become corrupted and I cannot get them to run. I can however ...
1
vote
3answers
34 views

How do I use the AND function and the MATCH function together to get something that is not “No” and has not been returned previously

I have the following data and need to return all values that aren't "No".  I.e., I want to create, in another column, a list of all the values from Column E that aren't "No".  There will never be ...
0
votes
1answer
27 views

Check which (multiple) cells in column A contain substrings specified in column B?

In column A I have M&A deal descriptions that mention company names. In column B I have company names, for each of which I want to see where it is mentioned in column A. What I'm having trouble ...
2
votes
0answers
23 views

MS Excel 2013 function TODAY() not updating unless source file is open

I use the TODAY() function in an excel worksheet which is accessed using MATLAB (i.e. I don't read the worksheet directly). Now I have to open the excel file just to update the TODAY() function, and ...
2
votes
0answers
23 views

Unlock Excel VBA “Find” window location [on hold]

When editing VBA code the FIND window (Ctrl F) appears at the bottom of the screen. It can be manually re-positioned but upon re-opening it appears at the bottom again. It used to open in the last ...
0
votes
1answer
25 views

Match each row against all other rows

I have 53 rows with 25 columns nand it's all txt values. Is there a formula that will match each row against all other rows? I basicaly need a similarity matrix and am wondering if there is a shorter ...
1
vote
1answer
24 views

Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...
-4
votes
0answers
19 views

I want to develop the splitting one row into multiple rows in Excel

You provided an excellent answer on how to convert Excel data in rows into a vertical column or series of columns. The page is: How do I split one row into multiple rows with Excel? In that ...