**0**

votes

**0**answers

5 views

### Parsing non-standard date/time data in an Excel spreadsheet cell

I'm looking for some advice on this one more than anything. I have a spreadsheet that contains store hours for each location at work. The formats range from this:
"Mon-Sat 9:30am-9:00pm
Sunday ...

**0**

votes

**0**answers

5 views

### Exporting HTML Tables to Excel Sheet not working in IE Browser but works in Firefox and Chrome

I have an HTML page which has multiple tabs and each tab has one table which contain data and I want to download all that data as an Excel spreadsheet with multiple sheets
// call cyntax of this ...

**2**

votes

**1**answer

11 views

### Excel: Increase a cell's value based on other cell's value

What I am looking for is an "IF" formula that can solve my problem:
I have a single sheet with 2 columns and an unlimited number of rows.
On the first column (Column#1), I have a drop-down with ...

**2**

votes

**1**answer

17 views

### In Excel, how would I calculate the number of Mondays between dates that excludes a list of holidays?

I'm currently using this formula: =INT((WEEKDAY(E2-2)-E2+E3)/7).
I know how to use the NETWORKDAYS function, which allows you to a specify a list of holiday dates, but I can't figure out how to ...

**1**

vote

**1**answer

10 views

### Inserting spaces into custom number format has no effect

I've got several phone numbers that Excel displays as (for instance) :
0147200001
I want to display them as :
01 47 20 00 01
Using the Custom Format Number, I've entered ## ## ## ## ##, but the ...

**1**

vote

**1**answer

14 views

### Retrive row number of MIN IF formula

I would like to know the row being used in a MIN(IF()) formula so I can use it to grab a another value in the same row..
I have this formula:
Between the two sheets
A is an Id
B is a Date
C is ...

**0**

votes

**0**answers

9 views

### Need VBA Code to Combine Rows if rows A-F are the same

I need a VBA code that will combine rows if, for instance, Rows 4 & 5 have the same values in columns A:F. However, then I need for Column G to be split. G4 stays as G4 but then G5 becomes H5. ...

**0**

votes

**1**answer

5 views

### transposing and collating text from different sheets into separate sheet

i am using the following formula to collate text from 3 sheets into a 4th.
=$'sheet 1'.A1&CHAR(10)&$'sheet 2'.A1&CHAR(10)&$'sheet 3'.A1&CHAR(10)
this collates the text with a ...

**3**

votes

**1**answer

22 views

### How to remove a macro button added by customized ribbon in home tab?

I have added a macro button in an excel sheet by customize ribbon and have assigned some VBA code to it to do some particular task. The problem is that when I open any new workbook, Excel shows that ...

**0**

votes

**1**answer

27 views

### Applying text formula only if text is in the cell in Excel

I am using 4 Excel sheets for collating text.
The formula I currently have in sheet 4 is:
=$Sheet1!A1&CHAR(10)&$Sheet2!A1&CHAR(10)&$Sheet3!A1&CHAR(10)
This allows me to write ...

**0**

votes

**1**answer

8 views

### Power Query Connect to Essbase Server

Is there a way to connect to an Oracle Essbase Server using Power Query for Excel to extract data?

**-1**

votes

**1**answer

16 views

### Auto-populate calendar with an “X” in Excel

I have have a set of due dates for preventative maintenance on equipment and I want a calendar to auto-populate with an "X" under the correct month it is due.
For example I have machine 1 due 1/1. ...

**2**

votes

**0**answers

15 views

### remove embedded xlsx files from docx

I have a very big docx document(300mb). It is full of pictures, tables, spreadsheets, etc.
Then I look at the document structure I see that under document.docx/word/embeddings/* are all excel sheets ...

**0**

votes

**1**answer

13 views

### How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted.
I am using conditional formatting's "use a formula ...

**0**

votes

**2**answers

19 views

### If multiple cells are with the same text, return this text(value) to another cell

I need your help with this:
If A1:E1 is "Red", return "Red" to C3;
If A1:E1 is "Blue", return "Blue" to C3;
BUT
If A1:E1 are not the same, return False or "X" to C3
What function to use ...

**0**

votes

**1**answer

17 views

### Prefix/Suffix Data Validation List

I'm finding it really difficult to understand how to prefix or suffix a set of words based on a what I have chosen in a 'Data Validation List'.
CLICK HERE TO SEE/DOWNLOAD AN EXAMPLE SPREADSHEET
I ...

**3**

votes

**0**answers

13 views

### How to get Daylight Saving into a Date Arithmetic Formula?

I am using Excel to calculate the times of a series of events that occur a certain number of hours offset from a starting time. I want the results to show in my local time.
My time zone will go off ...

**3**

votes

**1**answer

79 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

20 views

### Highlight rows that don't match other sheet

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

**3**

votes

**1**answer

22 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

20 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

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

**2**

votes

**1**answer

22 views

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

I need to 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

38 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

18 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

31 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

**3**answers

40 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

35 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

27 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

28 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

17 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

12 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

16 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

24 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

30 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

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

**-2**

votes

**2**answers

29 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

**1**answer

11 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

30 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

24 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

41 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

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