**1**

vote

**0**answers

37 views

### Enter the Date (and Other) Values [closed]

Excel interprets following inputs as a date values: July 15, Jul 15, Jul. 15, 7-15, 7/15. Similarly, Excel accepts time values in several formats: 14:00, 2 pm, 2 p, 2:00 pm.
What are all valid input ...

**0**

votes

**1**answer

20 views

### Deleting all cells in row after blank space

I was just wondering if there is a simple way to, for each row, move right and check if there's a blank cell and if so delete everything to the right of it. Can this be done with a formula?

**1**

vote

**0**answers

25 views

### Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row.
See the picture
or xls example https://dropmefiles.com/BDlHe
1st table lookup ...

**0**

votes

**2**answers

12 views

### Order print requests, group print requests

I have a following system in place
One of 12 emails arrives between 5 and 7 am, in a random order
Outlook rule picks up the email, and runs a VBA script that modifies, and prints parts of the some ...

**0**

votes

**1**answer

15 views

### Excel- averaging subsequent cells using first unused cell in column

Good morning,
I need this output to be on a separate sheet, but essentially the problem I am trying to solve can be explained as follows.
I am trying to figure out how to average cells in a column ...

**1**

vote

**1**answer

22 views

### Excel Predictive Text

I'd like to have Excel do predictive text based on a column on another sheet. I don't want to use the 'Drop Down' via data validation, since it is a long list of items and I can look up the value ...

**0**

votes

**1**answer

18 views

### Function requires date in quotation marks, how to pull from another cell?

I have an Excel function of the form =RTWArcValue("7/14/15 14:00:00"). The argument of the function must be a date and time within quotation marks. I'm trying to automate this to automatically input a ...

**0**

votes

**1**answer

75 views

### How can I display a URL as an image in an excel cell?

Can someone please explain to me how to turn a web link (URL) into an image.
Example image (URL is http://cache.lego.com/media/bricks/5/1/4667591.jpg)
What I am trying to do is make a parts list ...

**0**

votes

**1**answer

23 views

### EXCEL: Dynamic list and count of instances

I have a live datasource from a web page and in one of the columns it has an account code.
In my excel spreadsheet I'm looking at building a list of the account codes in one column and then in the ...

**0**

votes

**1**answer

39 views

### how to combine multiple charts with same x-axis (stacking two charts) in Excel

I have 3 time series data with wildly different data ranges. I can show two of them using a primary and secondary y-axis but that does not work well with the third data series.
In Excel is it ...

**1**

vote

**3**answers

52 views

### Excel Formula to Calculate Percentage on Different Sheet

I am trying to calculate the percentage of completed items from a a list.
Let's say:
#of Visit Place Comment
-------- ----- -----
355 A abc
345 B ...

**0**

votes

**1**answer

47 views

### Excel: Check if column A has a specific value, if so, display another cell within the row where the value is located

How would I be able to write a formula that checks if column A has a specific value, and if so, displays another cell within the row where the value is located. From the example below, I want to find ...

**0**

votes

**1**answer

21 views

### Retrieve data from Tuleap OpenALM to excel using VBA

I am trying to access Tuleap Open ALM via REST API.
I used the /api/explorer/ to get necessary URL: "https://openalm.mycompany.com/api/v1/users?query=asmith&limit=10"
and I get correct output:
...

**1**

vote

**1**answer

107 views

### OFFSET Function in Excel just for non-duplicated data

I want to use OFFSET function to triple the data in a column. But I have some duplicated data (sometimes more than 2 repetition) that I want to just triple one of them not both and keep the other one. ...

**0**

votes

**1**answer

36 views

### How to compare and sumproduct two cells value and use multiple criteria in IF in Excel 2013

I want to compare the month value (=TEXT(A1,"MMMMMM")) from sheet A with a cell value (JULY) in sheet B using an IF statement.
If the months are same then I need a sumproduct of the cells in sheet A.
...

**1**

vote

**1**answer

17 views

### Excel 2010 - Vertical alignment of text simply not working

I have a long, multiple line-break-separated (Alt+Enter) text in a cell, and I would like to set its height to a specific number, but still see the most recent note I made (going from top to bottom), ...

**0**

votes

**2**answers

27 views

### Diff bet time separated by colon (like 23:10:00 minus next day 01:15:00) in excel

Really appreciate if any one help with below formula in excel,
Diff bet time separated by colon (like 23:10:00 minus next day 01:15:00) in excel
ThanK You.

**1**

vote

**1**answer

40 views

### vba macro - find first blank column from specific row range

Most of the solutions I have googled were either about finding the first blank column or first blank row, but I specifically need to find the first blank column in a range of rows.
What I need is to ...

**0**

votes

**0**answers

12 views

### split two long column of xy data series into many new column

I have a set of data like this:
Data-x Data-y
A 1
B 2
C 3
(THE DATA SEPARATE BY EMPTY CELL)
D 4
E 5
F 6
(THE DATA SEPARATE BY EMPTY CELL)
...

**-1**

votes

**0**answers

40 views

### How can i add numbers using sum function in vba between ranges

I am trying add sum function between two ranges E and H. So i used This code below but kept on getting wrong numbers, its not working or not adding right....
Function expenz () As Double
Dim a ...

**1**

vote

**2**answers

33 views

### Bypass Excel file selection confirmation for data connection with non-.txt text file

I have an Excel workbook that processes model output from another program. That program produces space-delimited plain-text output files with a ".plt" extension. I have a data connection in Excel to ...

**1**

vote

**1**answer

14 views

### Possible to create and switch between views/configurations of a pivot table

Is it possible to save different configurations of a pivot table and easily switch between them? For example, one configuration that has certain values along the X and Y axes, another configuration ...

**-1**

votes

**0**answers

16 views

### Excel: search, extract, paste function

I have columns containing strings with the names of colors. I would like to search a column for a specific set of colors and if these strings are found, paste them in another cell.
So basically, ...

**-2**

votes

**1**answer

22 views

### Combine list of items into a single bucket with a certain value, then create pie chart

I need to create a pie chart with four levels of risk from high to low risk. I have a list of items that I will manually assign a risk level. I then need to group those representing a single level ...

**1**

vote

**1**answer

22 views

### SUMIF function with rules inside the interval

Is it possible to set the condition of excel's SUMIF function inside the interval where there are the value to sum?
In the picture above I have to sum only the value in the column BU that are > ...

**0**

votes

**1**answer

33 views

### Concatenate two columns, look for duplicates copy single row to new worksheet

I have an Excel or CSV file with 5,000 rows and 20 columns.
I want to concatenate Column 6 and Column 8, look for duplicates and then copy only one of the duplicates into WorkSheet2.
For Example:
...

**0**

votes

**1**answer

66 views

### Count based on multiple alternate conditions in Excel

I need a formula to count any trailers that are due in but do not have a cell that says "yard" or have a date next to that trailer. Please see screenshot. I tried the COUNTIFS formula and was ...

**1**

vote

**1**answer

44 views

### Formatting date from decimal in Excel [closed]

How do I format a decimal value like 1.30 as "1 year & 3 months" in Excel?
The value needs to remain the same but just needs to be displayed as 1 year & 3 months.
I need to do this just ...

**0**

votes

**0**answers

19 views

### LibreOffice Calc equivalent to Excel “Custom Views” feature

Custom Views are an Excel feature that comes very handy when, for example, you want to save a filtered version of a worksheet and then pass to another vision of the same worksheet with different set ...

**0**

votes

**0**answers

22 views

### where to get the name of excel file?

There are some documents stored in a SharePoint document list. Using a IE browser, we have the option of opening the file directly in Excel. But on doing this, excel starts and downloads the file and ...

**1**

vote

**1**answer

37 views

### Filtering data in Excel using multiples of a number

I want to filter my data to only include values that are multiples of 12. So it should include 12,24,36, etc.
Is there a way to use the filter function so this can be done?

**0**

votes

**1**answer

39 views

### Creating yearly averages from monthly data in Excel

My ultimate goal is to graph yearly averages of my data. I have monthly data, and I would only like to return the average for each 12 month period.
PERIOD MONTHLY YEARLY AVERAGE
1 10
...

**1**

vote

**1**answer

71 views

### Auto-populate values based on multiple dependencies in Excel

I have three columns with information filled in already. The value in Column C is dependent on two identifiers from Columns A & B (i.e., George is always the seller of Apples in America, but Sarah ...

**0**

votes

**0**answers

54 views

### iXBRL to XBRL? XML inside HTML - Excel can't resolve

I have a bunch of files which should be a table with one row and 30/40 columns with data, in this format:
Inline XRBL (iXRBL - XML in HTML)
...

**1**

vote

**1**answer

53 views

### LibreOffice Calc equivalent to Excel “Evaluate Formula” feature

Excel has an "Evaluate Formula" feature (it's located in the Excel Formulas ribbon among the Formula Auditing group, as shown in the picture below).
Is there an equivalent to that Excel feature in ...

**0**

votes

**1**answer

41 views

### How does the user make a selection in MSExcel that contains only those cells that contain data?

Got an MSExcel question for you.
he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem.
And the version I am using is MSExcel 2003.
My question has to do ...

**0**

votes

**2**answers

35 views

### How to give duration in excel or libre calc?

I have duration data like 5:23, etc... in m:ss format. I already typed the data, but I cannot create a diagram, because none of the mentioned excels understand it. If I change the data type to user ...

**4**

votes

**0**answers

33 views

### Use functions like Countif, Countblank etc. to refer to discontiguous ranges.

Is there a way to use array formulas or some other feature to essentially have an excel function that means.
=Countblank({A1,A4:A6,A112:127,B29:B38}) etc.
Essentially, I want to refer to multiple ...

**1**

vote

**0**answers

18 views

### Is there a way to use cell references instead of structured table references?

I have a table, on the outside of which is a column of formulas referencing cells within the table. When creating the formula, clicking on the table cells or using the arrow keys to move to the ...

**0**

votes

**1**answer

21 views

### SUMPRODUCT with multiple conditions - EXCEL

In an Excel spreadsheet, I have dates in column B and email addresses in column K.
I need the number of unique emails that appear in column K for each date. Sometimes the email addresses appear ...

**1**

vote

**2**answers

138 views

### How to generate repetitions in excel?

I have the following data in Excel:
start date end date number of repetition
0 515 423
0 484 982
0 456 5,012
0 ...

**0**

votes

**1**answer

31 views

### Count continuously until cell value changes

I have a work sheet with data like so:
A
A
A
B
B
C
D
D
What I'd like to do is count each occurrence of A, B, and so on like so:
A 1
A 2
A 3
B 1
B 2
C 1
D 1
D 2
Is ...

**0**

votes

**1**answer

28 views

### how to filter “all rows where column x doesn't contain [0-9]”

I'm cleaning a dirty directory. A few (just a thousand or so) records have their postcode messed up, either blank or containing other address data. Usually that means city or county.
A Postcode, ...

**2**

votes

**2**answers

18 views

### How to sum two categories within a single column and show the totals to the side of the column?

I have a list of trailers with a column to the side that says if the trailer is full or a pup trailer. I can't figure out how to make the column total how many of each type of trailer and show the ...

**-1**

votes

**0**answers

16 views

### Multiple IF AND statements excel

So I want to know if its possible to have MULTIPLE IF statements in one cell.
What I am looking at is this. I have words down Column A, and words down in Column B. What I want when two words ...

**0**

votes

**1**answer

17 views

### Referencing excel cells inserted in a word document

Does anybody know how to reference cells from an excel document inserted into a word document, so when the cells are updated (in the word document) it automatically updated elsewhere in the word ...

**-4**

votes

**0**answers

14 views

### split column in another column [duplicate]

I have 19000 items in Column A and want to split first 9000 item equally in column A,B,C.
like cell A 19000 item
after split first 9000 item
column A 3000+ 10000(remaining items 19000-9000)
...

**2**

votes

**1**answer

27 views

### Transforming Color Codes in VBA

I have a bunch of code in excel macro which includes following pattern ;
Sheet1.Cells(i, 1).Interior.ColorIndex = 4
Sheet1.Cells(j, 1).Interior.ColorIndex = 4
As you see, I'm painting some cells ...

**0**

votes

**2**answers

34 views

### Excel: Getting #NUM on calc

Why am I getting #NUM error in Excel when trying to input:
=((171757/-201011)^(1/4))-1
It works fine on Wolfram Alpha..

**1**

vote

**1**answer

27 views

### 2010 Excel formula dilema [closed]

I am trying to set up an inventory spreadsheet using 3 worksheets. the first one has the items in inventory and their counts. the second sheet consists of the number of items used at an event which ...