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 "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
5 views

calculated item for Other

A field I use for columns in a pivot table has a large number of items. Only a handful of these items are significant. The rest I group into Others. This I know how to do. The issue I'm trying to ...
1
vote
1answer
6 views

How to display only rows of data that meet certain criteria?

How do I display, on a separate sheet, only rows of data based on one column of that data meeting a certain criteria in Excel? There are at least 15 columns & 240 rows in the original data sheet ...
0
votes
1answer
13 views

Excel - IF statement to find out if two cells contain same keyword

I need to compare text in two columns to work out if the same keyword appears in each. For example text in column L can be Operational A, Operational B, Operational C, Community 1, Other, Standard ...
0
votes
0answers
9 views

Pivot table with 2 different sheets

I have 2 different excel sheets tab1 A B C D E 1 2 3 and table 2 T U V W X 1 2 3 Let's say in B and U columns we have the same kind of data for instance "name of owner" and in C and V we ...
1
vote
0answers
8 views

3D Map - Where do the “Fields” come from?

I am trying to test out the new 3d map feature in Excel, but can't figure where they're getting the field name categories: I have only one table, and it's called "World_Storage", which isn't ...
0
votes
2answers
26 views

Convert YYYY-DD-MM HH:MM:SS to Days

I've extracted data from a power grid website and the time stamp corresponding to each power value is in the format YYYY-DD-MM HH:MM:SS on Excel. I need to convert this to days but am struggling. The ...
0
votes
2answers
21 views

Copy multiple Excel workbooks into one workbook

I am trying to copy multiple Excel workbooks into a single workbook with each of the copied workbooks to have their own Tab. I do not know how to use VB, so I have tried many VB scripts I found using ...
0
votes
0answers
23 views

comparing and updating columns in excel

I have 2 columns: id and contact number. column A contains few id column B contains their corresponding updated contact numbers column D is full list of id column E is their corresponding full list ...
0
votes
1answer
19 views

Excel: Sort by result of comparison

I think it'll be easier to elaborate by explaining with the rules and example. In a soccer competition (UEFA Euro), there are several groups of four teams each. Top two teams from each group qualify ...
1
vote
2answers
23 views

Returning next highest value

I have in cells B2 to J2 the following values: B C D E F G H I J 2 100%, 100%, 100%, 80%, 80%, 80%, 50%, 50%, 50% I want to return the next highest value that is ...
0
votes
2answers
23 views

Excel - Sort cells by a number of matches

I have a data in cells A1 to E1. all of them numbers. e.g. 6, 13, 13, 3, 15, . I would like to sort them in a way, that the largest number of matches come first, then the highest number and be ...
0
votes
0answers
13 views

Copying data from a mixture of protected and unprotected workbooks in Excel

I've been given 16 productivity-tracking spreadsheets from a team, and tasked with pulling the numbers from all the sheets into one, for a 'team average' type deal. Two of the 16 workbooks are ...
1
vote
1answer
26 views

Cannot Use Autosum on cells that Contain Formulas

I have cells that have IF formulas in them. Excel won't let me autosum the results of those. It's as if Excel does not recognize those cells as numbers. Granted, numbers do show, but in actuality the ...
0
votes
1answer
19 views

How to display unique numerical values from different columns into a single cell (separated by commas)

I have a unique problem I have been trying to tackle with no avail. I have scoured through the internet but only found partial solutions and not a complete solution. I am looking for a function (or ...
0
votes
1answer
17 views

How can I count unique comma-separated values - Early Bound vs. Late Bound

I am trying to display unique values from a string of values in a single cell.(separated by a comma). I've come across this solution: How can I count unique comma-separated values in Excel 2010 ...
3
votes
1answer
31 views

How do I convert data for height that's in multiple formats into inches?

I have a column with several thousand heights, in different formats, that I would like to convert to inches. Examples from actual data: 5 ft 2 in 6 feet 3 inches 6ft 3 inches 6 feet 3" 5*8 5.3 ...
2
votes
1answer
25 views

How can I look up the 2 axis values by inputting a number?

I'm a graphic designer and not very familiar with Excel but I'm fairly sure it's the simplest solution to my problem. I have a table (see below) with 2 axis going from A to L. Inside that table are a ...
2
votes
1answer
28 views

how to you keep a formula to stay with a certain cell even when you insert a cell to the right

I have a date in cell D3 AND THEN IN CELL C2 I HAVE THIS FORMULA: =DATE(YEAR(D3)+1,MONTH(D3),DAY(D3)-1) Which adds the date for review a year on. but when I need to insert the cell to the right to ...
1
vote
0answers
12 views

Designate Excel Data Connection ReadOnly

I have an Excel file with a data connection to another Excel source which is referenced by several other reports. The data connection should be read only, but I cannot seem to setup the properties to ...
1
vote
2answers
35 views

Microsoft excel - formula dragging

How can I drag a formula to all the adjacent columns with similar intervals in it? For example: in column F, the formula is ('Time sheets'!G10-'Time sheets'!F10)*24 and in column G, it's ('Time ...
1
vote
0answers
36 views

Printing multiple Excel tabs as a PDF document

I am trying to get multiple tabs of an Excel document to print as a multi-page PDF document. I activate the tabs that I want to print, and the print preview is exactly as I want it. Currently, it ...
0
votes
2answers
18 views

Printing multiple sheets with Mail Merge (Excel/Word)

Good morning! I need to create letters with MS Word, on each letter we need a code which is placed on the letter using Mail Merge. Some letters need to be printed more often than others. I need to ...
0
votes
1answer
27 views

Change color of row according to column value (by regex)

I'm quite new to excel so this could be dumb question. I need to change color for those rows which has suffix .com in their second column. I use OpenOffice but I can change it using Microsoft Excel ...
0
votes
1answer
20 views

Microsoft Excel spreadsheet to JSON?

I would like to create a JSON file from an Microsoft Excel (.xlsx). The sheet has all of the cells a certain height and width. I would like to have the top of each column be titled and used as a key ...
3
votes
1answer
24 views

Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget. Cells look like this A B C D DATE WEEKLY BILLS TOTAL 2015 $50 $1,956.73 Jan ...
0
votes
3answers
39 views

highlight birthday in a referenced cell

in Excel 2003 in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday in cell A1 date of Birth in cell B1 age with the formula: =DATEDIF($A1,TODAY(),"Y") ...
0
votes
0answers
14 views

EXCEL macro opens document but does not ask to “update links”

I have an WORD doc with links to cells in an EXCEL document If I open the linked document manually, it asks to [Update automatic links] and works perfectly but, when I use the macro ...
1
vote
1answer
21 views

Cells evaluated by user-defined module do not update automatically

I read the questions existing but no answer seemed to help. I have a function I wrote in VB which evaluates sum of cells in a certain range by font color, it all works well when I type the function in ...
0
votes
0answers
22 views

Excel will not put information in cell? [on hold]

I am entering data in one cell in excel and it will not put information in the cell. Will work in all others however. Started when I was simply trying to cut and paste a confirmation number.Number do ...
1
vote
0answers
28 views

Shortcut for Direction Keys — To keep hands on QWERTY end of the keyboard

I use a lot of Excel and finally got myself used to the ThinkPad pointer whereby I no longer need to take my hands off the keyboard for scrolling. But now I need to take my right hand off the ...
1
vote
1answer
23 views

How to grep summarized value from excel cell range?

I want to get summarize information from the following sheet. I don't know how to summarize this information. My scenario is like this. If I input -6, I want to find my target value in this ...
-1
votes
1answer
46 views

how do assign numbers to text and then add or subtract them?

How can I create a formula for the following spread heet? The text all have same value (AB=1) BC=1) (CD=1) etc. I want to place the text in a cell to place order, the text should give me total number ...
0
votes
1answer
17 views

View code in Excel - Import_Journals

I'm trying to look at some VB code in an Excel macro. This code is executed on a button click: Private Sub ImportSelected_Click() Call Import_Journals("SELECTED", "IMPORT") End Sub I want to ...
-1
votes
0answers
18 views

How can I automate the process of printing 2 rows of data from one sheet after pasting it onto the form on another sheet?

Sheet 1 of my spreadsheet has the following form: A B C D They are just columns named 'A','B','C' and 'D'. Sheet 2 has the following data: A 1 2 3 4 5 6 7 8 9 10 I want to print pages of ...
0
votes
0answers
20 views

Replacement of a string in excel with another string, taken from a csv file [on hold]

Say I have a CSV file which looks like "5.2", "Blah Blah Blah" "5.3", "Bleh" "5.4a", "Unicorns" Now, how would I go about creating a script or macro of sorts(?) so that whenever I type ...
0
votes
1answer
22 views

Clamping values while averaging

I have two formulas that are calculated using the same dataset. One formula calculates the average of the values, while the other calculates an average with a maximum allowed value of 60. I'm ...
0
votes
1answer
29 views

Excel Updates Link In Other Workbook

I opened two spreadsheets from an email, spreadsheet June & November. Both June & November in cell A1 reference a [CashInput.xlsx]CashInput$A$1 that was saved on the spreadsheet creator's hard ...
0
votes
0answers
31 views

Split single row into multiple rows in excel

I have a file of data formatted in the following way contractID, typeofreview, rq#, q1,q1a, q2, q2a, q3, q3a, q4, q4a 0001 basic 15 Ht Y Smk Y Sur Y Rsk Y 0001 ...
0
votes
2answers
27 views

How can I find the Maximum of Polynomial Trendline?

I have a XY chart. I used a polynomial trendline, now I need to find the maximum of the chart in an automatic way. Is it possible? Here is a picture to show the type of chart.
0
votes
1answer
28 views

Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file. I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...
0
votes
0answers
28 views

Group different values with same name field in Excel

I'm having troubles with the following document. Is there a way to group different values with the same name field?
2
votes
1answer
29 views

VBA EXcel - I am getting an error (400) if using error trap getting no object/application defined error

My excel sheet has these data, 7 columns sl.no | bed | 2| 4| 3|4|3| some times column no 7 is empty, and then only I'm getting error And my code Sub sup_cal_area_sft() Dim lru, plru As Long Dim ...
0
votes
1answer
22 views

Color a cell in MS Excel sheet, if do not fall in range

We need to enter lots of data in a excel sheet. Later we want to color code that data. I will be the one preparing this excel sheet and sharing with team. What I want is the moment I put a number and ...
0
votes
0answers
12 views

How can I create multiple charts based on a series filter using PivotChart?

I have a pivot table/chart displaying sales(value) by week(axis). I can add the branch to the legend and get one chart that displays the sales by week by branch. The problem is that I have 100 ...
0
votes
1answer
30 views

Excel formula disappears when saving as .xls

I have a long formula in one of my cells. It is: ...
1
vote
4answers
51 views

How do I add 1 year to a specific date once that date has passed?

I have an excel spreadsheet that lists our current subscriptions. I have one column with the Date they signed up and then I have another column for the Renewal Date. Currently I have to manually ...
0
votes
2answers
45 views

If cell contains “Specific Text” return value of cell beside it. Similar to VLOOKUP

I have 2 sheets, one with a list of parts(sku) and all the vehicles that the part will fit on (fitment) separated by "^^" it looks like this: sku | fitment 1 |car1 ^^ car2 ^^ car3 2 |car2 ^^ car3 ...
0
votes
1answer
19 views

How do I insert rows in multiple excel tables simultaneously without vba?

I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible? The tables are in different sheets if that matter.
3
votes
1answer
24 views

Match based on String Length

I have data similar to: My goal to to: find the longest string in column A retrieve the value in column B on the same row so in the above example I want Juliet. If there is more than one cell ...
4
votes
2answers
330 views

Generate Combinations in Excel

I have an input row which contains the cells: 30 30 30 50 50 60 100 I want to generate all possible combinations of length 3 from this set. So I would want rows containing 3 populated cells and ...