**3**

votes

**1**answer

40 views

### excel ISTEXT returns True where a formula contains the answer “”

I have a formula that returns the value "" blank.(correctly) However when testing for ISTEXT, I get the result "True" I understand "" is seen as text, however Im looking to test for actual words that ...

**2**

votes

**1**answer

15 views

### comparing certain columns in excel

I'm not sure if this is possible but I have two spreadsheets that I need to compare a few different things.
Here is the scenario:
**Sheet 1**
Column O=Claim Number;
Column P=Reserve Indemnity;
...

**3**

votes

**1**answer

17 views

### Excel Large Function with Duplicates

I'm trying to apply a LARGE function to get the 5 largest values from a column ignoring duplicates. I did some searching around and found some proposed solutions but they don't seem to work for me. In ...

**1**

vote

**3**answers

19 views

### Microsoft Excel- Sum IF

How can I sum totals in Excel if the identifying mark is an asterisk *. In column D I have numerous accounts only identified with an asterisk * in column E I have totals. I need to write a formula ...

**0**

votes

**2**answers

19 views

### How to select all values in an Excel data table column?

I have an Excel data table (not just a plain worksheet) and I want select all data (not the header and not the rows below the data table) in a column. What's the easiest way to do this? I use mouse at ...

**0**

votes

**0**answers

13 views

### How to set grouping by less than X, equal to X and more than X in a pivot table?

I need two use a pivot table to separate some data in 3 categories, less than X, equal to X and more than X, something like this:
╔══════╦═══════╦═══════╦══════════╗
║ Var1 ║ Var2 ║ Var3 ║ Totals ...

**0**

votes

**3**answers

36 views

### IF function with multiple criteria

I am trying to use an IF function to return a "1" if TRUE and a "0" if FALSE.
I need cell A1 or B1 AND C1 > 0 in order for the statement to be TRUE,or 1, else FALSE "0".
I cannot write the function ...

**-2**

votes

**0**answers

14 views

### DSum with multiple criteria

Please help me to correct the Dsum formula try to using as a Afterupdate event.
Text41 = DSum("Hours", "EOD", "Names='" & "Text39" & And "Date=" & (Today()))
Text41 & 39 -Textbox
...

**0**

votes

**1**answer

29 views

### Formatting data in excel [on hold]

I am being provided information to organize and don't have options of how it is delivered. The data is editable within the "text boxes" and excel doesn't recognize any values in the cells. Almost like ...

**1**

vote

**2**answers

35 views

### converting German date string into English (Excel)

I need to convert this string:
Donnerstag, Juni 05 2014
into a usable excel date. I'm trying to use something like:
DATEVALUE(MID(A1,FIND(",",A1)+2,LEN(A1))))+RIGHT(A1,11)
but cannot work it ...

**0**

votes

**1**answer

29 views

### Change the cell value depends upon the values in the 8 neighborhood cells in Excel [on hold]

My excel sheet contains 400 data points,its like a image pixel values,but some of my data points are missing so the value of that cell is zero,the data consist only four values 1,2,3 and 4. I need to ...

**1**

vote

**1**answer

25 views

### How do I split this query in Excel without using any macro functions

I have this query->
A B
1 |p1 | a:10;b:20;c:30 |
2 |p2 | a:25;b:15:c:40 |
How to get p1 and p2 in column A until its next value are splitting without using macros?
...

**1**

vote

**1**answer

24 views

### Make an array formula in excel calculate only on active rows

When excel calculates formulas over a column (e.g. a lookup), it's smart enough to only calculate until the last active row, rather than also running on all the blank rows.
With array formulas, it ...

**0**

votes

**1**answer

16 views

### VB6 application failed to run in another computer

I have created an application on my computer (Windows 7) using Visual basic 6 and it works well.
Now when I copied the application to another computer running Windows 8.1, the application was unable ...

**0**

votes

**0**answers

25 views

### I have to split this query in Excel without using any macro functions. The values below in this format can be dynamic:

I want to split these values:
A B
+----+----------------+
1 |p1 | a:10;b:20;c:30 |
2 |p2 | a:25;b:15:c:40 |
+----+----------------+
into this with formulas only
A B C
...

**0**

votes

**1**answer

17 views

### sum values based on match criteria to another table

I would like to sum prices in one table based on a match criteria from another table
example table 1
Grocery Items Price
Apples $2
Oranges $3
Bread ...

**0**

votes

**0**answers

11 views

### Excel 2010 merge rows where data in duplicated except 7 columns

I have a xls file.
I has some duplicate rows of customer names and other data that is identical.
I want to be able to find the identical rows by customerid and copy data from one row to another ...

**1**

vote

**1**answer

15 views

### Combine list of items, but keep amount value into separate columns

I have a list of Product Sales from 2013 and want to compare this to Product Sales in 2014.
There are new products in 2014 and some older products removed from 2013.
Thus, the list of alphabetized ...

**0**

votes

**0**answers

12 views

### Filtering Pivot Table

I have this Pivot Table, and what I need to do is: Filter this data and show only those records whose date (3rd column) is equal to its parent date (2nd column) or just 1 day difference is there.
And ...

**0**

votes

**1**answer

21 views

### Change column references by dragging down rows

I have this equation in excel =COUNTIF(A2:A10001,"<0.5")
Is it possible to make it so that when this formula is copied down the formula becomes =COUNTIF(B2:B10001,"<0.5") and so on?

**0**

votes

**1**answer

15 views

### How to add 2 hyperlinks in a single cell in Excel 2010?

I have an excel file that contains a list of steps that I follow at work.
I want to add hyperlinks to the emails I have received & saved on the hard drive.
Every time I try to add a hyperlink to ...

**0**

votes

**1**answer

29 views

### Combine two cells in Excel based on contents of cell

Can't seem to find any equivalent question on Superuser, so here goes.
In excel, I have used "Text to Columns" for Delimited data, separating by Tab or Space. The problem is one column is a name that ...

**3**

votes

**1**answer

17 views

### Autofit row height in Excel 2007

Using Excel 2007. Attempting to insert photo in each row and a specific column, but when the picture is inserted the row doesn't adjust to the height of the photo. I've tried selecting the row and ...

**-1**

votes

**2**answers

28 views

### Excel - Finding and Allocating

I need to find the same values in column A (e.g. column A can contain buy a dog, white dog, cute cats, cuddly cats - I would need find all "cats" and then assign them to certain categories, e.g. "CAT ...

**1**

vote

**1**answer

25 views

### Transform time spans to discrete steps

I have an excel sheet of some jobs (or whatever items/action) and their start and end date.
Now for each minute of the day, I need to know how many jobs were active.
So the input looks like this:
...

**0**

votes

**0**answers

8 views

### Edit some Google Files on the desktop without installing Google Drive

I would like to edit a Google Tabel on my Desktop with out installing the Drive Client (I really only need this file) and with out using the browser. What can I do? Is there a plug-in for excle or ...

**-1**

votes

**2**answers

28 views

### how to calculate positive number and negative number in excel

I have a sample table in Excel below. How do I sum up the total Win row and Loss row from week1 through week3 as below: I use the auto sum option, but the result did not work as I wanted. Would ...

**2**

votes

**2**answers

33 views

### Excel macro parameter is passed with either a reference or a constant

In Excel, I have written a vba function Separate like this:
Function Separate(sp As String, ParamArray ArgList() As Variant)
Dim paramLoop As Long
Dim curRng As Range
Separate = ...

**1**

vote

**0**answers

23 views

### Cell with 2 options and I want to add a third

So I have this excel file where when i select a particular cell a little box with an upside down triangle appears to the right of the cell. When I click on this there is a small list of options to ...

**1**

vote

**0**answers

13 views

### Excel file opens but when ready to save the file is readonly

Here is the situation.
Windows Server Essentials 2012 R2 and windows 7 pro via domain.
Laptop user opens 6 excel files. next he goes home with the files open to work on them. when he comes back to ...

**1**

vote

**2**answers

35 views

### I need to find a number pattern in a string and copy it to another cell In Excel

I need to look at cells in column A to find the number pattern of NN-NNN and then copy that to cells in column c. e.g.- Column A has "SPREAD_11_PLAT_SHTS_22-315_IFR" and I need to copy the 22-315 to ...

**6**

votes

**3**answers

40 views

### Alternate If() function in Excel/OOCalc

Countless times over years, I've wanted to use an If statement in Excel/OpenOffice Calc in the form of:
If(A (comparison operator) B, A, C)
or, equivalently useful:
If(A (comparison operator) B, ...

**-1**

votes

**1**answer

32 views

### How do I populate cell based on value from two separate cells?

Can anyone help me write the below formula the correct way?
=IF(C13="North Dakota","$2,500",IF(C13="Montana","$2,500",IF(C15="Yes","$5,000","")))
What I wish to achieve is: If value selected in ...

**1**

vote

**0**answers

7 views

### Color/Opacity Loss when converting XLSX to PDF using Acrobat IX

It's all in the title. I've got an excel file I need converted to PDF for printing, and exporting it using either the Save As... function or the 'Create PDF' option in the Acrobat Ribbon both result ...

**0**

votes

**1**answer

15 views

### Calculating number of complete boxes and loose items for Scout Popcorn Sale

I'm working on a table to calculate popcorn orders for my Boy Scout Troop annual sale. I want to calculate how many cases and loose item count of a specific item I should be receiving.
For example, ...

**2**

votes

**1**answer

14 views

### Hint menu does not appear for Range variable in VBA editor

I have this code:
Dim interface As Worksheet
Dim slope, measure As Range
Set interface = Application.ActiveWorkbook.Worksheets("Main")
Set slope = interface.Range("G1")
Set measure = ...

**0**

votes

**1**answer

30 views

### How to assign a tooltip at a macro button added by customize ribbon in ms excel?

I want to assign a tooltip to a macro button added by me by customizing ribbon in options at file tab in MS Excel.
You can see this snapshot for understanding that where and how I want the tooltip.
...

**0**

votes

**2**answers

34 views

### Excel: check if two cells have specific content and show true/false in another

I have a large datasheet with multiple columns. Long story short, my columns A and B (of text type) are lists of codes. For simplicity's sake let's say column A is days of the week, while column B is ...

**0**

votes

**0**answers

10 views

### How to color code bubble graph by numeric value?

Column E contains my Z values, and I want to use those values to correspond to a color for each of the points on the graph.
How can I do that?
The link to the file is here: ...

**0**

votes

**1**answer

31 views

### VLOOKUP cells that contain a certain text in Excel

The challenge is as follows: I have a column with names extracted from a source. The names come in different ways each time it is extracted. For me to be able to use it, I need the names in a specific ...

**0**

votes

**1**answer

24 views

### COUNTIF and SUM in Excel with different ranges

Is there a more efficient way of making the following function?:
>=COUNTIF(A1,">0")+COUNTIF(C1,">0")+COUNTIF(E1,">0")+COUNTIF(G1,">0")
I want to count if the cell is bigger than 0 ...

**0**

votes

**1**answer

28 views

### Need unique count of text from multiple columns by category

My data looks something like (assume begins in A1):
Category,Label1,Label2
Dogs,blank,doe
Dogs,zoo,blank
Cats,zoo,yup
Cats,doe,hgg
Cats,blank,doe
What the result should look like:
...

**1**

vote

**1**answer

28 views

### How do I stack multiple columns into one?

I am not experienced enough with VBA to accomplish this. How do I modify the below VBA to be able to do the following:
Put stacked columns in a new sheet.
Handle blanks (code below currently does ...

**0**

votes

**1**answer

18 views

### Error on connecting excel to a oracle database

I'm trying to connect to a Oracle Database from a Excel 2010 in a Windows 2010 machine.
I installed 64-bit Oracle Data Access Components but when I try to connect to the database on
Data > From ...

**0**

votes

**0**answers

21 views

### How can I split a spreadsheet into multiple files based on column values while keeping other worksheets and macros in the resulting files?

I've been using the macro below created by mtone for these kind of tasks (splitting spreadsheets) and it works well, but I need to adapt it so that the resulting split files "carry" other sheets of ...

**0**

votes

**0**answers

18 views

### Excel drop down list to change data table

I want to make a drop down list to select sets of data from another sheet, but I'm a bit lost on how to do it
Basically, I have matrices with data that change according to different scenarios, and ...

**0**

votes

**1**answer

20 views

### How to make Excel use relative paths in external workbook links

Within our company we use a number of Excel workbooks that link to other Excel workbooks.
With our service this is fine as everyone accesses a shared network drive and the file paths for all the ...

**-1**

votes

**1**answer

26 views

### Filter an Array into another page of an excel spreadheet

I have an excel table that includes one column that lists Y, N, N/A, or Blank. I need my filter to pull the rows that include the N, or Blank and paste them into another page of the spreadsheet.
I ...

**0**

votes

**1**answer

25 views

### Histogram over Time?

I am trying to track the progress of a similar variable on a number of (several thousand) objects over time. I have several snapshots of data in the following form, but I want to show the progress ...

**2**

votes

**2**answers

76 views

### Excel - return multiple values for each of a list of values

I've been trying to solve this for a good few hours now, but with no result...
My setup:
I've got excel sheets of cosmetics product recipes.
Each recipe contains dozens of ingredients, each given ...