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)

2
votes
2answers
135 views

Vector Compare to Scalar

Is it possible to compare a vector of values to a single scalar value in Excel? Example: =IF(A1:Z1 > 0, 1, 0) Typically, I've seen the following: =IF( AND( A1>0, B1>0, C1>0, . . . ...
0
votes
1answer
20 views

Finding days between dates when string is contained in another sheet

I've 2 Excel sheets, one called "Inventory" and the other called "BookDetails". "Inventory" contains all sold books and the date they were sold. "BookDetails" contains all the books and the date it ...
0
votes
0answers
7 views

view formulas in Excel in read-only (license expired) mode

On license expiry, Excel claims you can still look "use office to view your files for free". When I try this, though, I am unable to view formulas. They don't appear in the formula bar. Ctrl-` ...
1
vote
0answers
15 views

Calculating partial values for use in a weighted average

I have a spreadsheet with the following information: Column A contains a list of courses (eg Course 1, Course 2, etc) Column B contains the number of credits available to each course Column C ...
2
votes
1answer
12 views

Index-Match returning value in cell above desired value

I have a couple index matches going on in a workbook I'm playing with. I basically have a huge lists of addresses in a table and I'm trying to pull specific ones to get mailing codes. I index match ...
1
vote
3answers
19 views

How to remove all spaces in Excel table

I have identified that in data that I have imported, there is a space at the beginning each cell in one column. I cannot just backspace these as there are 1000s of time stamps. The screenshot below ...
1
vote
1answer
13 views

Database Query and Excel

I have a report on Excel that built using database query. I need to write comments on each row. When I refresh the file the comments don't stay on the same row and don't match the record. What should ...
0
votes
1answer
18 views

Selecting a value based on a lookup value that fits between two values

I have a Worksheet in which I have two "tables" looking like this: What I'm trying to achieve is to do the following: Take the first two digit in Column D (for the first row 77) See which row in ...
0
votes
1answer
23 views

'On Error Resume Next' not working

I have one procedure in excel vba code. In this I use 'ON ERROR ....' syntax. Procedure starts with ON ERROR RESUME NEXT to skips all error. But at some point I want to change that status from ON ...
0
votes
1answer
24 views

Excel - how to check if certain value appears twice in one column and compare it with another condition

I have a problem filtering some data in excel 2007 I would like to check if 2 values appear in one column and compare it with another condition example Column A, Column B 5555, Yes 5555, Yes 1111, ...
2
votes
2answers
17 views

if indexmatch = #N/A keep original cell value

I have 2 worksheets in excel. Sheet 1 is a price list given to us by a supplier Sheet 2 is a list of all the products we supply (can be from multiple suppliers). In the first column of each Sheet is ...
0
votes
1answer
25 views

XML data from one Excel cell to new XML file

In A1, A2, A3... A16000 I have the entire context of a XML in one cell. Example: The entire XML for one invoice is in A1, the next invoice in A2 and so on. How could I save the context of each ...
0
votes
0answers
9 views

can fuzzy lookup compare single character strings in two tables that only differ by one character

did this... Table1 Column1 ab123 cb456 ef789 Table2 Column1 ab1230 cb4569 zx2224 ef789 Fuzzy lookup returns the following: Column1 Column1 Similarity ab123 ...
1
vote
1answer
11 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 ...
2
votes
2answers
17 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
2answers
39 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
1answer
17 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
40 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
36 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
1answer
38 views

comparing and updating columns in excel [on hold]

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
22 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
25 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
28 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
15 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
37 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
21 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
18 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
35 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
30 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
30 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
38 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
38 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
23 views

Printing multiple sheets with Mail Merge (Excel/Word)

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 find a way to ...
0
votes
1answer
30 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
21 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
25 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
40 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
23 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
25 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
53 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
20 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
31 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 ...