Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

1
vote
0answers
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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 ...