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
1answer
11 views

Loop down column until blank cell

The following formula works well if I define each cell (over and over), but I need a loop that will run down column A & B for hundreds of rows. I have tried and just cannot seem to be able to ...
0
votes
0answers
6 views

Equivalent to Excel 2013's 'BeforeSave' for Excel 2010?

I am trying to have a housekeeping macro run when an Excel sheet is saved, but I can only find reference to this: https://msdn.microsoft.com/en-us/library/office/ff840057.aspx for Excel 2013. Does ...
1
vote
1answer
10 views

How can I custom format in excel to place periods (as separators) in an 18 digit entry?

This is regarding 18-digit accounting codes that contain multiple periods, as separators. I would like to enter just the digits without typing in the periods. Example: 112233333444555556 would ...
0
votes
1answer
11 views

In Excel, how can I make a row of data in a table that has specific text in one cell automatically appear in a table on a seperate sheet?

I download a report with 8 columns of data into a table each week. The amount of data changes each week by row (one week might have 40 rows, the next might have 100 but no more than 150). The data ...
0
votes
0answers
22 views

Easy way to convert one row of data into multiple in Excel

I have a worksheet that looks like this: Right now each Number contains a varying amount of Companies and Company Numbers. I would like to set up the spreadsheet so each Company has their own row ...
0
votes
2answers
24 views

Excel - Sum assigned numeric value of 1 to different phrases in different cells in a row

I'm assessing a survey of multiple choice answers using Excel. I need to assign a numeric value of 1 to fixed text answers and show the sum on another worksheet in the same workbook (the text is ...
0
votes
1answer
17 views

Excel VBA - Getting “Object Required” Error When Stating Range Is Not Null

Below is my code where I'm getting the error. I've marked the line that the error occurs on in bold (i.e. ** at the beginning and end of the line **). The specific part of the code I'm receiving ...
0
votes
1answer
12 views

Merge two sheets on two columns into a new sheet in Excel?

I'm using Excel 2011 on OSX. I have Sheet1 that looks like this: pupil_id date test_score 1 2015/10/01 98 2 2015/10/01 83 And I have Sheet2 that looks ...
0
votes
0answers
22 views

Excel - Decision-Tree Budget / Shopping List

I'm planning the purchase of a bunch of A/V equipment. There are lots of different options for where we might end up. Some of the equipment is base equipment, we need it no matter what. For some of ...
1
vote
1answer
28 views

Excel - base 27 three-digit Sequence enlisting

In a three-digit number increasing sequence, where the base of each number is 27, I am trying to make a list of all combinations, but without repetition of numbers. E.g 1,26,26 would not be an option. ...
1
vote
1answer
11 views

Using address function to create array excel

I'm trying to create an array using address to find the max value from a different sheet =address(10,15,1,true,"othersheet")&":"&"address(11,20,true,"othersheet") returns this ...
0
votes
1answer
18 views

Referencing a worksheet in a formula in Excel 2010

I am using Excel 2010. Let's say I have a workbook that contains 13 worksheets. The first worksheet is named "Summary" and the remaining 12 are the months of the year (January-December). In ...
0
votes
0answers
12 views

How to reset Excel 2013 Spreadsheet Compare

In Excel 2013, I have the Inquire COM Add-in turned on, which gives me the 'Inquire' ribbon. I can click on the Compare Files button, which launches the Spreadsheet Compare tool. In the bottom ...
0
votes
1answer
25 views

Formatting an Excel spreadsheet

This is what I want excel to do= If column F says SP then turn column M - same row - a colour if the year is less than 2011.
0
votes
0answers
13 views

Combining multiple lines and selecting farthest date range

What I have is a spreadsheet with customers listed multiple times and need to condense data per customer to one line in 3 different columns. The columns I am trying to do this function is L, M & ...
0
votes
1answer
15 views

Error: The Macro May Not Be Available In This Workbook Or All Macros May Be Disabled

I'm trying to adopt the solution from this post & I've modified the macro slightly (I only need to add on button click) so that it's now Sub AdjustValue() Dim btnName As String Dim ...
0
votes
2answers
22 views

Nested countif's frying my brain

What I want is the following scenario: If all values are "Pass" then display "Passed" If all values are "Fail" then display "Failed" If all values are "Incomplete" then display "Not Started" If all ...
0
votes
0answers
12 views

Create a checkbox that will hide rows containing a specific string of text (Excel 2013)

I'm working on a sheet to help me track the progress of projects as I work on them. This is accomplished by keeping information in an ongoing table, columns A through N. I want to keep a running list ...
0
votes
1answer
8 views

Excel: How to obtain depured colum B after deleting matching values from column A

So I have in Column A a Blacklist of sites that i can not use any more In column B i have listed all of my current sites (more than 5000 rows). So i need to look if any of the values of column A is ...
0
votes
0answers
21 views

Merging two cells together with same data

I have a spreadsheet of about 23,000 user ID's in one column. Then in the very next column I have a list of about 1300 user ID's that use a particular application. I need the 2nd column to sort ID's ...
0
votes
1answer
25 views

EXCEL SUMIFS with dynamic tabs (INDIRECT)

I'm trying to get below SUMIFS formula to work with INDIRECT. I have data for each week in separate tabs .. ie WEEK05, WEEK06 etc. The result of the formula (a date) will come from column W based on ...
0
votes
0answers
14 views

Create Hyperlink for open and filter worksheet

Is there any way to open worksheet with filter data? through hyperlink I have One "main" worksheet, from there through vb coding it will create two worksheets (If exist then delete and re-create.) 1 ...
0
votes
0answers
14 views

Cleaning up data fetched from Google Spreadsheet to Excel

I've been trying to synchronize and build a local database with Excel data. I need to build the database and program to create user accounts, manage the packages, track and log the status of the ...
0
votes
0answers
10 views

Having reading software read cells in excel

I am creating a Excel list template. The people using it are using text reading software - such as ZoomText or NVDI - to read the spreadsheet. How can I have the software read something different then ...
2
votes
2answers
163 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
24 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
9 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
27 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
17 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 ...
2
votes
3answers
23 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
15 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
22 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
33 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
35 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
22 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
32 views

XML data from one Excel cell to new XML file [on hold]

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

can fuzzy lookup compare single character strings in two tables that only differ by one character [on hold]

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
14 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
22 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
46 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
21 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
9 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
44 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
45 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 ...
0
votes
1answer
41 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
23 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
26 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
32 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
16 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
38 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 ...