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
3 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
16 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
5 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
7 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
13 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
16 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
12 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
5 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
7 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
157 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
22 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
8 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
23 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
20 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
14 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
21 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
29 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
30 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
20 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
30 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
13 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
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
20 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
44 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
18 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
41 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
42 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
39 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
30 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
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
20 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 ...
3
votes
1answer
31 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 ...
3
votes
1answer
31 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
39 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
3answers
26 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
35 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 ...
2
votes
1answer
25 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 ...