**0**

votes

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

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

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

**2**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

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

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

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

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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