**0**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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 ...