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

equivalent of Crtl+Apostrophe in google docs

In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of ...
0
votes
0answers
10 views

Prevent Excel from changing formula of last row of table when adding a new row

I have a table with columns named "date", "cost" and "daily". "Date" is a date, "cost" is a number and "daily" is a formula calculating the total cost of each day. The formula looks like this: ...
-1
votes
0answers
9 views

One of my excel file sitting on my online file share corrupted due to some unknown reason

One of my excel file sitting on my online file share corrupted due to some unknown reason. (User claimed that she cannot save the file back after edit. She ended up terminate excel from task manager. ...
0
votes
1answer
15 views

Why is copy paste losing all formatting by default?

Lately whenever i copy paste something (in particular within Office) by default i lose all formatting. To copy the formatting have to retry copying the content several times before it works. So far i ...
2
votes
0answers
9 views

MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version). I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...
1
vote
2answers
21 views

Excel '10 Formula to find & sum a row based on the intersection of 2 data points. (ie. Name(row), Month(column)

I need an Excel 2010 array formula that will take 2 given data points, say a "Name" (row) and "Month" (column), and return the sum of a row based upon the intersection of these two points within a ...
-2
votes
1answer
27 views

Excel Macros 2013: Is it possible to create a Macro that, with a shortcut key, toggles a selected value between red and black font colours

I have created a spreadsheet with information regarding students grades and wish to be able to toggle the font colour of selected cells to indicate change in data. I have attempted to use "If", ...
0
votes
1answer
26 views

Excel Macros 2013: Is it possible to create a Macro that, with the shortcut key, formats an input value between Whole int and 2 decimal places

I am attempting to create an Excel spreadsheet which holds information of students data, currently I have rounded all data to the nearest whole int. What I wish to know is whether there is a way to ...
1
vote
0answers
9 views

Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold. For this, I click PivotChart filter and see that filter may ...
0
votes
1answer
24 views

Excel Opening as a blank spreadsheet, but with values

So when we open an Excel spreadsheet that is populated it will open with all of the cells appearing blank. However if you click on any of the cells you can see in the formula bar at the top that they ...
0
votes
2answers
27 views

Getting last cell in row with data and corresponding data in column A in Excel

I have a spreadsheet that in column A lists dates. Column B may or may not have data in each cell. The question I have is when I grab the last cell with data in column B, how can I also grab the ...
3
votes
2answers
18 views

Can I use COUNTIFS where only 1 IF criteria is required?

COL A COL B COL C ROW 1 Yes Yes ROW 2 Yes ROW 3 ROW 4 Yes Yes I'm trying to write a formula that will count how many rows has at least ...
-2
votes
2answers
24 views

Excel - How can I detect the X lowest consecutive values within a column

I was hoping that someone might help me with a problem I'm trying to sort out. Does anyone know a formula that could detect the 10 lowest consecutive readings within a single column. Thank you for ...
0
votes
1answer
17 views

Compare to cells containing text and printing a value from a third cell [on hold]

I want to compare two columns containing text and if there a match print a value from third column see eg: Column A Column B Column C Column D BOB Sally 1 terry ...
0
votes
2answers
11 views

Make numbers copied from Excel to Word use minus sign instead of hyphen to avoid wrapping

When you copy a negative number from Excel to Word, a hyphen/minus (Unicode -) is used instead of a proper minus sign (Unicode −). This causes text to wrap after the hyphen (you ...
-7
votes
0answers
29 views

Need some assistance with Excel VBA [on hold]

Below are two separate Excel files. I want to populate the material and thickness w.r.t part number and CPSC in the first sheet.. Can anyone please write a code for this example? Part Number CPSC ...
0
votes
0answers
9 views

Html controls not displaying when exported to Excel

I have a web app that exports an html table to excel. This html table contains controls such as checkboxes and text areas inside the cells. It works fine on my machine but not on my colleagues. For ...
0
votes
2answers
31 views

Remove space before specific text excel

I have a list of 1000s of different labels and need to remove the space between the number and mg. Sometimes the space is present and other times it's not. The position of the text "mg" is not the ...
0
votes
3answers
47 views

What combination of keys do I need to enter complex formula in a cell?

I've created a conditional SUM formula: =SUM(IF($G$14:$G$5002="Liz S Salary",IF($Q$14:$Q$5000>=Summary!$F$6,IF($Q$14:$Q$5000<=Summary!$F$7,$R$14:$R$5000,0),0),0)) The formula needs to be ...
0
votes
1answer
32 views

How to increase the excel value 1 after to leave the few cells

I enter the following data on a sheet: Roll-No:- 801 Maximum Marks 20 20 20 20 20 20 Sig. of Class ...
-2
votes
0answers
11 views

Divers Excel versions and language

I make excel sheets and programs used on differend computers with differend languages and differend excel versions. In Holland the date setup is jjjj In US is yyyy If I write VBA code, than I can ...
2
votes
2answers
23 views

How can I get the relative position of a cell in a range?

I have a range of cells in a workbook, and I want to dynamically replicate them in another workbook. I don't want to use explicit cell references in case the range is moved, I always try to use named ...
0
votes
1answer
24 views

Conditional formatting in Excel according to today's date

I have an Excel file that links to some documents, certificates and such, which are valid for a year. For example, since Feb 20, 2014 until Feb 20, 2015. To the right, I have a column in which are ...
0
votes
1answer
17 views

How to filter months in chronological order? [duplicate]

How do you filter months in mmm format in calendar month order and not alphabetical? When I do it April as "APR" will be before January as "JAN" for example that is not correct. (I know that Data ...
-1
votes
0answers
16 views

Modify Excel data connection without disconnecting the connection file

I have several workbooks which connect to the same SQL server data source. I would like to store the details of the data source in a file in a central location, so that if the database is moved to a ...
0
votes
2answers
28 views

Excel “Print to PDF” creating multiple files

I am trying to print a workbook to pdf, but for some reason, it is attempting to save to multiple files. About 10 pages want to save in 2-3 pages per file, then the rest (another 15) save to the ...
1
vote
1answer
14 views

Cell reference formula within formula to pick out a group of similar rows

I have a table with 1000+ rows. One column is the Item Name. Each Item Name is unique, but will appear in 8 to 15 rows contiguous of data (before going to the next item name), the number of rows in ...
-1
votes
0answers
21 views

How to iterate creating unique pairs from a list without repeating pairs across iterations [on hold]

I'm teaching a class where the students are matched into pairs each week for 10 weeks. None of the students can be with the same partner twice. Does anyone have ideas for me to automate the matching ...
2
votes
2answers
136 views

How to concatenate values in Excel?

I have a spreadsheet that looks something like this:    A B C D E ... 1| 1 0 0 1 0 2| 0 1 0 0 1 3| 0 0 0 1 0 4| 1 0 0 0 0 I'd like to concatenate row 1 in column F so ...
-2
votes
2answers
17 views

Excel help to remove part of a field [on hold]

I have multiple locations that have a distance marker that I need removed. They differ in distance and some just don't have it. Here's an example: (0m) KISD CTB
1
vote
1answer
16 views

How to print Excel worksheet on A2 Paper

I have a wide Excel worksheet. I need to print it on A2 paper so I don't have to split it into two papers. How do I make Excel print to my A2 plotter?
0
votes
1answer
16 views

Excel: How to give cells chosen by some criteria as a parameter in Variance (or any other) formula?

For the following Excel table: A B C 1 Score Category VariancePerCategory(Calculated) 2 0.3146 Orange 0.034214 3 0.5711 ...
0
votes
1answer
12 views

Excel: Find&Replace issue

I'm trying to find out, how to replace only those substrings (in my case it is ,_ where _ is a space), which starts at the beginning of the cell. I suppose, the solution should be like this regex: ...
1
vote
1answer
33 views

Return specific value in range [on hold]

Let's say there are two columns: A and B each with five rows. Column A has value P03675 in all five rows and Column B has TRUE, TRUE, FALSE, FALSE, TRUE in rows, just like this: A B P03675 ...
0
votes
0answers
10 views

Excel 2013 Data Validation List to show all text for selection in drop-down but when selected resize and only show first two characters

I have a sheet that I need the drop-down Data Validation list to show the full text but after selection only place the first two characters in the cell and ensure the cell is sized to only 5 ...
1
vote
1answer
34 views

How do I transpose columns in Excel?

I have a spreadsheet that looks like this: I want to automatically transform it to this: : I know I can transpose it using this Window: But the result is like this: How can I get what I ...
0
votes
1answer
16 views

Excel horizontal only sum of an array (matrix)

I have a formula which generates a 2D array result. For example: {=ROW(4:6)^TRANSPOSE(ROW(1:3))} (the curly brackets are added by excel when you hit CTRL+SHIFT+ENTER ) I need to sum only the ...
0
votes
1answer
37 views

Formula to update cell based on user changing another cell's content

I want to know if there is a formula to update a cell in Excel with today's date when a user changes any value in the row that contains that cell OR when a user changes the value of 6 / 7 / 8 ...
0
votes
0answers
21 views

Excel Index match formula [on hold]

How can I use Index match formula to lookup and match below column B value of sheet1 to column A value of sheet 2 if column C in sheet 2 is having a value? and display that in sheet 1 column C either ...
0
votes
0answers
9 views

How to aggregate a column based on another - excel 2013?

I am using excel 2013 to try to make a chart like this: with this data (tried to do some formatting on it): Date           ...
-1
votes
0answers
13 views

Microsoft Excel 2007 Formula for mileage over 4,000

I am needing a formula to calculate mileage for the next oil change on our company vehicles. I want the mileage for the vehicles to change red after exceeding 4,000. For example if we have 11,900 ...
0
votes
2answers
24 views

Higher Dimensional Trendline

My data is in multiple dimensions, as below. Rather than a trendline, I guess I need a trendplane. Is this possible in Excel or a similar tool?
1
vote
1answer
25 views

Excel - Comparing two columns and extracting data from one into another

I need help with an excel formula for a project I'm doing. I can't find the one that I need. I have 2 lists of data in different tabs in Excel (Tab 1 and Tab 2). Both Tab 1 and 2 have a column with ...
1
vote
1answer
22 views

how to find partial text in excel

I have two columns "A" & "B". Column "A" contains Complete Text (1000 line items) & Column "B" contains partial text (250 line items). How I can find & place all Partial text(Column B) ...
0
votes
1answer
33 views

Count filled cells in row, given from adjacent column not being empty in Excel 2010,

I have a two worksheets, one in which I have a list of tasks as well as several other columns listing the status of the task and one column listing if the task is imortant or not. In the other sheet, ...
0
votes
0answers
18 views

Delineate Excel Formula Without Using Wizards

Is there a combination of excel formulas that I could use to do this without using VBA or the import wizard? I know how to insert comma delimited data from a text file and to split a cell into ...
-1
votes
0answers
11 views

Excel - Formatting one cell from a series of cells

I am trying to format one cell (H) from a series of cells (C, D, E, F). For example if column C = "x" then column H = 120 if column D = "x" then column H = 160 if column E = "x" then column H = 200 ...
0
votes
1answer
27 views

sorting column data into a raw by unique data [duplicate]

How do I sort in a row by the unique value of such data? For instance, I would like to compare the data on the value column, such as 2,3 4, or more values depending on the unique ID? This is 14 unique ...
0
votes
1answer
22 views

Copy down formula using VBA starting from different cells [on hold]

I have a set of data that I add to weekly. In the data I have multiple columns that I need the formula to copy down to the bottom. I have formulas in columns (for the sample piece below) B-D and I ...
0
votes
2answers
17 views

Excel formula to generate a custom array result

I have a formula in excel which contains an array; {1,2,3} its use can be seen at I would like to generate it dynamically eg arrayfun(4) would generate {1,2,3,4}. I can generate a very long array with ...