**2**

votes

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

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

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

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

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

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

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

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

**2**

votes

**1**answer

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

**1**answer

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

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

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

**2**answers

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

**1**answer

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

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

**1**

vote

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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