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

What is need to improve percentage

I work in a school and attendance is something we wish to focus upon. I would like to be able to calculate the following: If a student's attendance falls below 90%, I would like to calculate in ...
1
vote
1answer
10 views

Microsoft Excel 2013 Changing Date Automatically to current Date

I have an excel formula that I am using to automatically add the date to the cell next to the cell. I use a drop down menu to select a value. Is there a way of then stopping this date from changing? ...
2
votes
1answer
17 views

Finding Common word from two columns and returning value

I've two collumns in excel and I want to see if there is a common word(s) betweeen my cells, for instance: Cell A1: 76A08, 26A65, 22A26, 2A01, 12A05 Cell B1 I've : 26A65, 22A26 In cell C1 the ...
1
vote
2answers
23 views

Need to count the amount of times -1 appears above a certain cell

I have the following Excel Spreadsheet - Hy Newcastle 042216 -1 Not Matched 1000 Hy Newcastle 042216 6461735 Khanyile;Florence Success 1000 Hy Newcastle ...
0
votes
1answer
11 views

How to compare differences for multiple possible pairs of cells in Excel

In Excel, I have 7 columns of data (numbers) spanning 100 rows. For each row, I want to check whether at least one number exceeds all other values by a certain value (say 0.2 or greater). If so, the ...
0
votes
0answers
16 views

Copy paste to excel

I am tring to copy from browser and paste to excel it is taking 7 min, can any one say what is the problem The same if I am working with production url it is taking 1 min. Please I don't want to use ...
0
votes
1answer
21 views

How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...
0
votes
0answers
7 views

Excel Solver - Can't set integer constraint on certain cell

I have a production programming exercise that I'm supposed to solve by using the Excel solver. However, I am not able to set an integer constraint on a certain cell that I need to be integer only. I ...
0
votes
0answers
25 views

Update Table based on Range start value and end value

I have a set of data that uses a primary key of month of the year by numerical value, e.x. Month 1, Month 3. I am trying to update my table and its values from the raw data set based on a user entered ...
2
votes
1answer
15 views

Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function. I also have a scatter plot where the selected data is like this: =SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1) I want to replace $F$4 in ...
2
votes
3answers
31 views

How to convert integer column to time column?

I am trying to format an integer column to a time column, but the values all end up as 12 like this: 12 12 12
1
vote
1answer
21 views

Is there a way to configure Currency or Accounting dropdown in Number Ribbon?

Is there any way to configure the list of currencies showed in the Ribbon (see screen shot)? My most used currency, $, is not available in the default list and I can't found out how to modify this ...
1
vote
2answers
31 views

Excel Formula difference between two dates

I have two dates as the following , I want to get the duration spent between them. 6/29/2015 12:18:04 PM Regards,
0
votes
2answers
21 views

How can i match columns that are not adjacent to each other?

How can I match column A with other C and E (columns are not adjacent to each other) and fill 0 in column G if column A matches either column C or E. If column A does not match neither C or E fill the ...
0
votes
0answers
27 views

How can I make a code that checks for its validity [on hold]

Suppose I have the source code in any language and I give my code to someone and I dont want them to modify my code. So can I write something in the code that can check the validity of my code(i.e the ...
-1
votes
0answers
17 views

excel 2010 VBA insert column headers

I have a piece of VBA code (Excel 2010) that generates tables with 5 columns x 6 rows. There is an option to input the number of tables to be generated, as required e.g. 1 or 6 or 10 etc. basically ...
0
votes
0answers
17 views

MS office character replacement [on hold]

I often need to replace a character in Excel on a character that follows after it or preceeds it in alphabet. This letter is part of formula that takes data from different columns in other table. For ...
0
votes
1answer
29 views

Excel: Is it possible to copy cells only if cells match in other columns?

If it's an EXACT duplicate, not just some answer that MAY suggest an answer then please provide the link in a comment. Say, I have dates in column A of Sheet-1, and also dates in column A of Sheet-2. ...
1
vote
1answer
10 views

Paste special text leaves trailing spaces in Excel

I wrote a script that creates an HTML table like this for a coworker: <table> <tr> <td>06/21/2014</td> <td>AAA</td> </tr> ...
0
votes
1answer
12 views

How to copy tab-contained text from Excel without quotes?

I've noticed that a cell that contains a tab is copied with quotes embedded. I'm looking for copying such kind of a cell without the quotes. Illustrative Example I've 5 cells; A1, A2, A3, A4, and ...
0
votes
1answer
13 views

Excel Formula change and remove

The numbers on the form are for two different references. 2015-##### (five digits after year) is the way it will be entered. When the user enters that I would like to enter in another cell the result ...
1
vote
1answer
24 views

Excel 2010 error message when opening .xlsm files

I'm trying to open a .xlsm file in Excel 2010 when I receive the error: "There was a problem sending the command to the program" Once Excel is open, I am able to open the file, but if Excel is ...
0
votes
0answers
8 views

Crash when using Get External Data From Web in a macro

Is there a way to disconnect IE from Excel when using the "Get External Data From Web" and use another browser such as Chrome or Firefox? I've been having problems where IE stall/hangs and the ...
0
votes
1answer
17 views

Google Spreadsheet =Filter in excel

I have this formula in google spreadsheet that uses the =FILTER functionality but I can't seem to find the corresponding syntax in excel. Specifically the formula is as follows: ...
1
vote
2answers
30 views

How to identify a cell in excel?

I have a massive excel sheet with a few thousand rows and columns. I need to identify those rows that have a certain code. The code can be in any column. Here is an example table to make this more ...
0
votes
0answers
17 views

Conditional Formatting using Excel writer

In Excel, using Interop dll I have following code. objWorkSheet.Range[objExcel.Cells[intHeaderRowCnt + 2, 6], objExcel.Cells[intCellRowCnt, 6]].Formula = "=RC[-3]-RC[-1]"; ...
0
votes
0answers
27 views

Using filter in Excel

I have an Excel file which contains details of all the school students from A to Z. Out of it, in a separate sheet created FEES DUE FORM for each class that contains only ROLL NO., NAME from APR '14 ...
0
votes
0answers
21 views

Is there a way of 'detaching' a column from the rest for the purposes resizing the cells in it?

Here's an example Excel spreadsheet. Basically what it is an chart for time organisation, and I use the left most column for storing some notes (back log items etc). Now I need to to keep the ...
-1
votes
1answer
21 views

How to send email to mailing list in excel using gmail

Currently, when I type an email into excel it becomes a link. When I click on this link, the default browser opens a new gmail tab logged into whichever gmail account I am currently logged into, and ...
1
vote
2answers
25 views

How to change underlying formula for Excel Table?

I am using Excel Table which has formulas. I have added 300+ rows and realized some of the formulas are incorrect. Whenever I add a row, I have to manually make correction to formula in the new row. ...
0
votes
0answers
19 views

Automatically format cells as currency from .CSV when importing into Excel

When I import a .CSV file into Excel, how do I get all cells which contain a number to be formatted as currency? Currently, if the value for the cell contains the dollar sign ($), it becomes formatted ...
-4
votes
0answers
26 views

VBA EXCEL 2013 Save As [on hold]

I need to save this file too without replacing it . X = "A1" 'номер ячейки начала страницы отеля A = "H4" ' номер ячейки, сожержащей название отеля. For AA = 1 To 40000 'проверяем ск-ко человек в ...
0
votes
2answers
47 views

Need a formula to check the first x amount of characters if numbers

Is there a formula to check if the first 7 characters in the cell are numbers?
0
votes
1answer
38 views

Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well. The ...
5
votes
1answer
17 views

Excel Ranking function

Can't find specific answer to this problem on other posts. I have a table with a list of vehicle registrations and a list of times for those vehicles. I want to give each row a rank based on the time ...
0
votes
0answers
16 views

MS EXCEL 2013, keeping alphanumeric characters?

I am trying to carry an alphanumeric value from one cell to another but lose the alpha character when doing so. Example: AP15 = a53789. The other cell reads: 53789. How do I keep the "a"?
0
votes
0answers
23 views

Excel - Adding titles to both ends of an axis in a scatter plot

I'm looking for a way to add axis titles to both ends of an axis in a scatter plot in Excel 2016 for Mac. So far I have titles only in the left and bottom parts and want to add the titles on the ...
0
votes
1answer
23 views

Adding time values produces 0:00:00

in-time is 9:36:00 out-time is 18:53:00 hours worked = 9:17:00 required hrs = 9:30:00 (a specification) The difference between hrs req and hrs worked is = -0:13:00. Formula used: ...
2
votes
4answers
58 views

How to apply a formula to an entire Excel column using a keyboard missing its END key

I have a keyboard with a trackpad that's missing some of the normal keys available on a full-sized keyboard (among them Home and End). Also, there are 30,000 rows in the sheet and dragging the corner ...
0
votes
2answers
63 views

How can I compare two columns and if match return a value?

How Can I compare the entries on TAB: SUMMARY SLS, column B with SUMMARY P&S, column B and bring back a "X" if a match is found in the cell with the formula? SUMMARY SLS and SUMMARY P&S are ...
0
votes
1answer
17 views

Convert single text string into rows and columns

I have a single text string with words separated by spaces, e.g. "blah cah nah....". Say I would like to split this into n words by m columns, i.e., a word per cell. I know I can use text to columns ...
0
votes
1answer
21 views

Find cell address for MAX+IF function based on category

I have a large set of data, which has been divided into 9 categories using numbers 1-9. The data is not sorted by category, but the categories are defined in a column as data. Using MAX+IF, I have a ...
0
votes
2answers
19 views

Assign category to data based on range

In Excel, how would I take numbers from one column and assign them to a category in another? E.g., if I set ranges that correspond to certain words 1-10=Beginner, 11-20=Intermediate, etc. How would I ...
-1
votes
1answer
26 views

Error in SUMIFS [on hold]

I have the following data --- A B C 1 Name Form Group 2 John 7A 1 3 Sarah 7B 1 4 Lucy 7A 1 And I want to sum all the values in ...
4
votes
3answers
46 views

How do I force Excel to always type purple text?

I'm making changes to a large Excel worksheet, and every change I make needs to be in purple text. Right now, I'm typing the change and then clicking purple text. Is there a way to force Excel to ...
2
votes
0answers
32 views

Is it possible to add a custom calculation for a top level row total in a pivottable?

My Pivot Table has the following format Manufacturer MPG - Nissan 10 - Petrol 35 - Model A 30 - Model B 40 - Diesel ...
2
votes
1answer
31 views

Dragging effect from keyboard

Is there a way to create 'dragging' effect from keyboard only, not using the mouse. This could be useful for Excel, Word etc. For example, the fill handles in Excel could use this feature.
0
votes
0answers
24 views

Strange graphical glitches in Outlook, Word and Excel

My coworker is experiencing strange graphical glitches while using Outlook, Word and Excel: When she is composing an email in Outlook and she types in the body of the message, the text often appears ...
1
vote
1answer
38 views

If statement that returns original function if false (similar to iferror, or substitute)

If I use IFERROR as opposed to IF(ISERROR I can save typing the condition twice. i.e. =IFERROR(Long lookup,"not found") is much preferable to =IF(ISERROR(long_lookup),"not found",long_lookup) ...
-1
votes
0answers
16 views

Transposing Rows into columns [duplicate]

ColA Company1 Product Name Company 2 Product Name Company3 Product Name I want the answer to be Company1 Product Name Company2 Product Name