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)

0
votes
1answer
40 views

Excel Number Scaling

So I am working on a nutrition worksheet and I want to assign numeric values to nutrition measurements. For example, If I have the following for Vitamin C: Guava 300mg Papaya 250mg Orange 180mg ...
0
votes
2answers
59 views

Formula to display project month & year number instead of calendar Month & Year in Excel

I want to display dates as project month # and/or year # (i.e., Yr. 1 Mo. 1), rather than as calendar month and year. I am using a financial modeling template that currently allows me to input the ...
0
votes
0answers
23 views

Dynamically select last data point in line chart in Excel

I have a line chart with 40 different data series in Excel that updates once a week. In this chart, I would like to always have the most recent data point selected and its value displayed. Is it ...
1
vote
1answer
29 views

Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010 (extended)

I would like to plot multiple datasets of different length on the same scatter graph. This question was already answered exactly here: Plotting multiple datasets of different lengths on the same ...
1
vote
1answer
62 views

Formula to show date of the last day of the month specified in another column in Excel

For a month number in column A, I want the LAST day of that particular month in column B. Right now, I'm working with year 2014, so: A1 number is 1 so B1 date is 01/31/14 A2 number is 2 so B2 date ...
0
votes
1answer
20 views

Recurrent excel count

Is there a more elegant way to do this in excel? =(IF(ISBLANK(O3); 0; O3-P3) + IF(ISBLANK(O4); 0; O4-P4) + IF(ISBLANK(O5); 0; O5-P5) + IF(ISBLANK(O6); 0; O6-P6) + IF(ISBLANK(O7); 0; O7-P7) + ...
1
vote
2answers
23 views

Convert text/general format time into numeric value that can be filtered

I have time data that is formatted as the following: 000:01:18 The problem is it is formatted as General, which is not recognized by excel as a numerical value at all. So no formulas will convert the ...
1
vote
1answer
37 views

Why won't a comma work to shorten numbers? (# ##0.0,,)

I am trying to shorten some numbers in cells in Excel so that they display as millions. I tried putting two commas after the number format code in the custom category of the format cells dialog box, ...
0
votes
1answer
40 views

Automatically import daily .txt file into Excel

I have an excel file that I pull data into from a .txt file that is generated every day on a network drive, and I'm currently doing this manually every morning. I would like to automate this process ...
0
votes
0answers
60 views

Edit Auto Sum Conditioning Statement

Need help editing totals when something is sold, it should subtract from totals. http://i.imgur.com/9G8oTPU.png To Calculate #1, the calculation should be B2-B1 (since it is sold and in red), #2 ...
1
vote
3answers
45 views

Excel 2010: count if using a formula

I've a table with actual stock in column C goods in arrival in column D auto-reorder in column F I need to count the number of rows when (C+D+F) > 0. Every row must be counted only one time and ...
1
vote
3answers
25 views

AVERAGEIFS with OR conditions

I've got a series of blood pressure measurements. I want to determine the average pressures during the day and during the night. The first half of the problem is trivial: ...
0
votes
4answers
74 views

Excel: Sum values on a column based on criteria* on other columns *(complex criteria)

See below for rewrite. Please refer to the data below for the question. The very top A B C are columns and the far left numbers 1 through 15 are rows. The rest are cells. A B ...
0
votes
0answers
32 views

Why is my Excel 2013 so slow to open URLs?

I have new install of Excel 2013 (32 bit process) on a fresh Windows 7 SP1 (64 bit). When I have a cell that contains a hyperlink to a website, clicking that link causes Excel to hang for 3-10 seconds ...
0
votes
1answer
52 views

Obtain a row number from 2 criteria (with 1 fuzzy search)

I am attempting to create some graphs with dynamic cell references as indices. These graphs are based upon time stamps generated from a testing machine. I have a column of Boolean values (0 or 1) that ...
0
votes
2answers
71 views

Removing Line Breaks From CSV for Proper Excel Import

So I've created a batch script that outputs some text to a CSV. When I open the CSV in Notepad, it looks like this, which is how I want it. 173030,8,2793,2821244 173032,1,2793,2820692 ...
0
votes
2answers
28 views

Excel - how to stop automatic destructive re-formatting of fields on document load [duplicate]

I am trying to edit a csv file in excel, but am running into issues with its supposedly-helpful automatic format detection, and I don't know how to turn it off. I have a field with an original value ...
-2
votes
0answers
17 views

How can I extract specific information from Excel

I have spreadsheet with Part# in Column C, Price in Column D and Date Quoted in Column E. Same part # can be in C multiple time. I want to pull only the newest price quoted. How can I do this
0
votes
1answer
16 views

EXCEL: Icon Conditional Formatting Based on Range of Values

I am creating a spreadsheet for work and I need to format cells such that I get a green check mark when the value in the cell is between 100 and 101, yellow ! if it is between 97 and 100, and red X if ...
1
vote
1answer
16 views

How to highlight boundaries of an array in Excel?

I'd like to know if there's a way to make excel show me where are the boundaries of an array, like the highlight I made in the picture below. Some explanation: I have a worksheet that is full of ...
0
votes
1answer
20 views

How to get a formula to extend to new cells depending on pivot table

I have a pivot table with some formulas using the data from the pivot table to the side of it. My problem is that if I add a filter, say city, so that the pivot table extends down, the formulas to the ...
2
votes
3answers
59 views

Boolean “OR” Inside of Function

I am not new to excel or vba; however, I am having some difficulty with the lack of a boolean "or" function in excel. As you know, the "&" function works fine, but you cannot insert the "|" or ...
0
votes
2answers
41 views

Excel: How to filter a table with a total row?

I've a very large table, and of course I need filtering. also, my users ask for a total row at the end. But if I give the total row, this very last row will be sorted and/or filtered as a normal row. ...
0
votes
2answers
33 views

How do you construct an IF statement with three conditions in Excel?

I am using Excel 2010 and I want to use an IF statement with 3 conditions, but I am having some problems. Here is my condition, I can't use the comma sign because in Excel 2010, it apparently doesn't ...
1
vote
3answers
44 views

Writing excel formulae that reference columns by number rather than letter

Is it possible, and if so what is the syntax, to write formulae in Excel using the column's integer number rather than the lettering system that is the default? I know it is possible to change the ...
2
votes
1answer
59 views

Excel 2013 Fuzzy Lookup to find near-duplicate text

I have a list of captions with a large number of near-duplicates. For example: Birthday for Her For Her Birthday Birthday - For Her For Her / Birthday I was looking into Fuzzy Lookup as a way ...
1
vote
1answer
23 views

Dynamic data sheet combined with one static

I am using a sheet in excel which pulls data out automatically SQL from a database. Fills in maybe 20 or so columns with orderinfo. In column A i have a unique order no. What i want to achieve is ...
-2
votes
3answers
66 views

Need a formula for Leap Year

I need a formula in which, if the date is equal to or greater than 03/01/2015 and less than or equal to 02/29/2016 then I get the result as "Leap Year" or "No Leap Year". Thanks! Sumeet
2
votes
1answer
50 views

Excel VBA: Skip an Entire Row from Processing If Condition Is Met

Hello everyone I am relatively new to VBA coding in Excel (current version 2010) and I am trying to improve upon a simple program that suppresses small values in the tables my organization releases. ...
1
vote
1answer
28 views

Getting a webpage title into Excel

I'm attempting to create a cell that will pull in a hyperlink based off of what is filled out in another excel cell. I have the hyperlink portion working, but I'd like to have a better label for the ...
0
votes
1answer
25 views

Excel: Move cell contents to comment in a certain cell

I need to convert text content in a cell, into a comment in other cell (the one on the left). I saw this post, and the code works fine but it puts the comment in the same cell the text content is. ...
1
vote
0answers
53 views

Dependent Drop Down lists and Data Validation; Multiple Lists

Right now, I have My goal: Add a Data Validation List into another sheet such that when I select an item from Column B, everything from Column K appears that is linked through into Column B ...
1
vote
2answers
54 views

Why is my constructed formula giving different results than the same formula as UDF in Excel?

Here's a long formula to calculate distance between two coordinates points on Earth =ACOS(COS(RADIANS(90-LAT1)) *COS(RADIANS(90-LAT2)) +SIN(RADIANS(90-LAT1)) *SIN(RADIANS(90-LAT2)) ...
1
vote
1answer
18 views

Format blank columns based on number of rows in spreadsheet

I'm attempting to color code blank columns in a worksheet based on the number of rows I have in my data set. I have an existing macro that sorts and formats my data but I want to add code to do this ...
1
vote
2answers
30 views

DATEVALUE() gives different values for similar data

In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM So, to get the date from that column, I created another column and used the formula =DATEVALUE(CONCATENATE(MID(D2,5,2)," ...
-1
votes
2answers
15 views

Not getting desired output in Excel [closed]

V A R K 12 4 9 12 I need to view these values from Max to Min Like 12,12,9,4 Then show relevant grades accordingly in separate cells
1
vote
0answers
30 views

Excel (2010) Save and Save As operations cease working

Twice in the past week a colleague has encountered an issue with Excel 2010 where the application suddenly ceases to perform its Save and Save As functions on all open workbooks, with no error ...
4
votes
3answers
90 views

How can I 'align right' the results of Excel's “Text to Columns” feature?

If I am using the Text to Columns feature on the following data, using ";" as a delimiter: foo;bar;qux;baz;toast; quux;jam;beans; I'll end up with the results "left aligned" in the resulting ...
2
votes
1answer
35 views

Not getting desired output with VLOOKUP - Need assistance

I have Table 1, which looks like this - A1 B1 C1 1 X Date11 2 Y Date12 3 Z Date13 I have another table, Table 2, that looks like this - A2 B2 C2 1 M Date21 2 N Date22 3 X ...
-2
votes
1answer
34 views

How do I detect any uppercase letter in an Excel cell?

How do I find if any letter in a cell is uppercase, for example to identify proper nouns in a word list?
1
vote
0answers
17 views

Having problems linking table at a specific webpage in Excel

I am trying to pull live data from http://www.wdol.gov/sca.aspx into an Excel spreadsheet. Specifically the SCA Wage Determined Rates. I want to be able to pull in the table that is generated from ...
1
vote
1answer
31 views

Excel - how do I retrieve corresponding values from another worksheet?

I have a "DETAIL" worksheet which tallies numbers: DETAIL WORKSHEET (Column A) (Column E) (Excel Row #) DATE TOTAL ... 700 6/8/2015 =sum(D701:D709) 701 702 703 ...
0
votes
1answer
40 views

Percentile in excel

I have many records in excel ordered by time and I need to find an automatic way to find the percentile by another value (speed) for each hour I set each interval by concatenating day and hour ...
1
vote
1answer
44 views

How to hide formula results in a cell until conditions are met - percentage discount [duplicate]

My question relates to this post, but with different formula criteria: How to hide formula results until conditions are met. Here's the setup for a spreadsheet to calculate the percentage discount ...
1
vote
1answer
22 views

Excel TRIMMEANIFS() alternative

I'm currently using AVERAGEIFS() to get a mean for a selected range of data. I'd like to trim outliers from this (get an interquartile mean), but there's no TRIMMEANIFS statement. Is there a way to ...
1
vote
2answers
59 views

Is there an excel function which displays a string but outputs a value when referenced?

Let's say if the function called "LABEL". Then in cell A1 I would enter =LABEL(4,"Four Apples") and it would render as: Four Apples But if I performed a calculation, say =A1+2 I would get 6, not ...
1
vote
2answers
23 views

How to prevent Excel to round a number at opening? [duplicate]

I have a question regarding Excel. We generate automatically a CSV file everyday, containing stuff looking like : column1;column2;...;columnx text;date;text;249316479917397279 The issue is that the ...
-2
votes
1answer
23 views

Need to sum values associated with specific words, in Excel [duplicate]

I want to sum values associated with specific words. For example, calculate Sum for Food: Column A Column B Food $8.50 Food $5.10 Maintenance $12.00 Laundry ...
2
votes
0answers
29 views

Find string in the workbook in Excel [closed]

I don't want to use the ctrl-F function to find a string; is there a function that I can use to find a (sub)string from a whole column of excel workbook and then save the row number to print entries ...
0
votes
0answers
23 views

Microsoft Excel 2011 concatenate each row in a cell

I am trying to use an if function for each row for a result in a single/destination cell. The if function checks if a row meets a criteria, if it does, it adds the row details to the destination cell ...