**0**

votes

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**3**answers

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

**3**answers

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

**4**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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