**0**

votes

**2**answers

44 views

### How to add up hours

I have a spreadsheet to track my hours at work and I was wondering how I would go about adding up my total hours. I'm not fussed what format it be in, whether it be HH:MM or as a decimal.
...

**0**

votes

**1**answer

37 views

### Understanding SumIF and Subtotal combinations

I've come across this solution to combining sumif and subtotal formula but I don't understand it..
Combining SUMIF() and SUBTOTAL() for Dynamic Subtotal
Could anyone please offer an explanation of ...

**0**

votes

**1**answer

18 views

### Copying data using VLOOKUP error

I'm having problem with the formula I'm using in Excel. Since I can't add images here, here's a link:
Here's the link to the sheet, where Sheet 1 is the source data:
...

**1**

vote

**1**answer

34 views

### Excel add maths keyboard shortcuts

How can I get excel 2013 to auto correct maths? For example change \int into ∫. I know how to do it for one symbol but is there any way to get excel to recognise all the maths auto corrects?

**-1**

votes

**0**answers

26 views

### How can i make this formula show up blank untill there is a date plz [duplicate]

=IF(G4<(TODAY()+1),"Warning - Time to Renew","OK")
having trouble with =if(isblank(g4),"",g4.
but then it doesn't let me add that to the start what am i doing wrong.
...

**1**

vote

**2**answers

29 views

### Calculate average depending on upper right cell

I'm trying to get the average depending on another cell.
Basically I want the average of all cells where the value of the upper right cell equals 95.
In this example I would like the average of A3, ...

**-1**

votes

**1**answer

65 views

### How to graph in Excel (Multiple sets)

I have some sets of data that look like this (all are in the same worksheet, in different rows)
ID (unimportant) : (xxx) (yyy) (zzz)
Number of #'s (unimportant) : (123) (123) (123)
...

**0**

votes

**1**answer

24 views

### Macro to create a text file with values from cells and text

Im trying to create a macro in excel that creates a text file which some of the parameters are on excel cells.
The output would be for example:
The kid is 'cell (1,1)' old.
His name is 'cell ...

**1**

vote

**1**answer

27 views

### can someone help me with my Formula Excel need it show blank

=IF(NOW()-B4>=15,"OK","Warning - Time to Renew")
that is the formula, but can it stay Blank until a date is put into cell B4
thanks

**2**

votes

**2**answers

53 views

### How to extract remainder of a match of 5 digits in 9

I am trying to extract the "remainder" (the non-matching portion) of a search using Excel 2003. I tried using various combinations of functions but it seems that there's no specific function that can ...

**1**

vote

**2**answers

52 views

### How to prevent Excel from display a formula's result until another cell is populated?

Sorry I'm new to Excel but learning at a slow speed.
Why does =IF(E3>=1,G3,NOW()-D3) keep showing 41944? Can i make it show nothing until a date is put into cell D3, or show 0?
The formula's ...

**0**

votes

**0**answers

39 views

### Excel relative links not updating when copying folder structure

I have searched everywhere and although I have found very similar questions about this, I have not found any satisfactory answers.
I have a folder structure like this:
Root_Folder
..|_ ...

**0**

votes

**1**answer

50 views

### Excel formula to count when value changes?

I have an Excel conundrum I can't seem to crack.
In Column A I have a long list of counties, and each of those counties is a member of a larger group of counties that pertain to a particular funding ...

**0**

votes

**3**answers

22 views

### How to record in adjacent cell what my drop down selection was, as a Hard Record formula? plz

is there a excel function coding which can record in an adjacent cell what my drop down selection was From cell A3, into Cell B3, but to keep this even if i remove the drop down selection at a later ...

**0**

votes

**0**answers

28 views

### Making DropDown list without repetition, Adding name back to List?

i use this method to help me with my own Excel data for Car Hire. its working great user can select one car and until its deleted from the first field the next user can select. is it possible that the ...

**1**

vote

**1**answer

35 views

### Make Excel formula yield `blank` as an ISBLANK() = TRUE

Make Excel formula yield blank as an ISBLANK() = TRUE
I found couple poster asking about what are the differences between "" and simply (blank), but now how do make formula return blank?
Example:
...

**1**

vote

**1**answer

14 views

### How do I pull data from 2 rows where the data is not the same?

I have 2 columns AZ and BA. I want to pull all of the data for the rows where for each row AZ and BA are not the same. Does anyone know how to do this? I am new to EXCEL. I'd imagine something ...

**0**

votes

**2**answers

16 views

### Does a range of cells contain a value in a list?

I want to answer - does a range of cells (A1:E1) contain any value from a list (G1:G50)
In other words: Does A1 OR B1 OR C1 OR D1 OR E1 contain any value that appears in G1:G50?

**1**

vote

**1**answer

25 views

### Excel - How do I calculate an average for both positive and negative numbers displayed as h:mm:ss

J49 to 89 contain the formula =IF(I57<0,TEXT(1-I57/24/60/60,"-H:mm:ss"),TEXT(I57/24/60/60,"H:mm:ss")) which gives a result ranging from -0:12:58 to 0:04:42.
I would like 2 things:
Firstly for ...

**0**

votes

**1**answer

22 views

### Is there a way to have a constant 0 in the cell even if no data entered?

In cell A1 I have number entered as 10. If I delete the number 10 from the cell A1 I want 0 to be constant in the cell A1 automatically instead of manual entry of 0?

**0**

votes

**1**answer

36 views

### Excel, how to check cell value against a column of values?

Using excel 2007, I have 2 worksheets.
The first one is 1 column of about 600 numbers/IDs.
The 2 worksheet is about 30 columns for about 5000 IDs.
Im basically trying to filter out the 600 IDs ...

**0**

votes

**0**answers

11 views

### How to Move Excel Drawing Tools Diagrams between Excel and Specialist Drawing Packages?

I have to create an object-based image in an Excel 2007 workbook. Currently, I'm using the Excel Drawing tools... but I find them slow to use and not very precise.
I've only used a few graphics ...

**1**

vote

**1**answer

45 views

### How to add a drop down list in Excel

I need to add a drop down list of Profit margin figures (namely 8.5%, 10% and 12.5%) against each inventory item as shown below but I can't find out how to do it
Code Product Cost ...

**0**

votes

**1**answer

17 views

### Complex referencing in excel

I am trying to create a sheet in excel that will have a complex referencing system and need help.
It is a rota and one sheet will contain the rota for a given week, the other sheet has the 'master ...

**0**

votes

**3**answers

23 views

### Create a custom format number in Excel

I would like to create a custom format number in Excel:
For example:
When I write: 0, I would like to display: 0+000
When I write: 55, I would like to display: 0+055
When I write: 555, I would like ...

**0**

votes

**1**answer

28 views

### Excel - How do I convert negative seconds into negative minutes

How do I convert negative seconds (eg. -10) into minutes in the next cell (eg -00:00:10) ?

**1**

vote

**2**answers

31 views

### Convert Text Value to Time Value in excel

I am trying to convert text to time. Basically I copy and pasted the total time of employees but it pastes as text value and then in order to add the time I have to convert it to time and I have to ...

**0**

votes

**3**answers

36 views

### How to extract Date and time from data entered as October 29, 2014 4:20PM PDT

I have data that I copy and paste in this format: October 29, 2014 4:20PM PDT
I need a formula to extract the date in one cell and the time in another cell. I need these two values to be able to do a ...

**0**

votes

**1**answer

18 views

### Removing a time (i.e. 5PM to 7PM) from a cell

So, here is what I have:
Saturday – 9AM to 3PM This is an annual event usually held in October.
I want to be able to pull out the times into two cell: Start Time and End Time. Is there a way I can ...

**0**

votes

**0**answers

31 views

### Formatting a date in Excel

So, I want to format a date from this format:
Sunday November 23 2014
into this format:
11/23/2014
How can I do this? I tried using Format Cells -> Date but when I choose the format #3/14/2001 ...

**0**

votes

**1**answer

41 views

### Need a way to have excel show items I have used already from drop down list

This is my first time asking. I have an excel sheet, new to excel but love to learn.
I worked out how to make drop down lists and I have a list of cars that are being used. The user in sheet 1 ...

**0**

votes

**2**answers

49 views

### Microsoft Excel convert Oct to 10

Can anyone help me please? I need to convert MMM to NN e.g. Oct to 10 I'm not a superuser but would really appreciate anyone's help.

**0**

votes

**2**answers

44 views

### Extract specific data from a text file and import it in Excel

I have a .txt file with lot of information, but I only need the numbers from Mean Absolute Error and Root Mean Squared Error. How can I automate and extract the numbers and put them in a Excel table.
...

**0**

votes

**1**answer

24 views

### In a VBA program to recognize a new row entry and populate a formula into a cell (gsheet)

I'd like this formula =IF(C1="TOTAL",COUNTIF(C$1:C1,"TOTAL"),ROW(A1)-COUNTIF(C$1:C1,"TOTAL")) to be automatically populated into a new row entry/ when a new row is added as explained in the question ...

**1**

vote

**0**answers

28 views

### How to save Ping record in every single hour for 2 weeks?

how do I save the record ping "in every single hour" for a certain period, for example for 2 weeks, with the format dd / mm / ss, dd / MM / YYYY and beside it is the result of the ping.
So we can ...

**0**

votes

**1**answer

37 views

### Index/Sumproduct calculation error

I have been working on an excel problem for the better part of 24 hours. I have a formula that almost does what I want but it is not returning what I imagine it should return:
...

**0**

votes

**1**answer

23 views

### Excel histogram with discrete “bin numbers”

I have a column of data similar to this:
1
1
1
1
1.2
1.2
1.2
2
2
2.1
2.2
3
3
3
3
4
I want excel to display how many 1 values, how many 1.2 values, how many 2 values, etc. I know I should use ...

**0**

votes

**2**answers

104 views

### Mail Merge Multiple Rows into one document

I have an excel file with different fields in each column:
Field 1__ | Field 2__ | etc.
F1 Item 1 | F2 Item 1 | etc.
F1 Item 2 | F2 Item 2 | etc
each field has a different number of items in it.
...

**0**

votes

**1**answer

49 views

### Conditional Formatting Cells with Different Values for Rows with the Same Value in Specific Column

I need to conditionally format cells with different values between the same columns, if their value for a specific column is the same.
Scenario
My spreadsheet is a contacts database, where each row ...

**1**

vote

**1**answer

35 views

### How to count blank cells at end of row in n-column table

Suppose I have a table with 50 rows and 50 columns. Each row has a certain number of blank cells, often occurring in the last few columns, with the first few columns being relatively dense. I would ...

**0**

votes

**1**answer

26 views

### Excel does not import Guids (Unique Identifiers) when importing data using the “External Data” feature

When I try to use Excel 2013 to import External Data from a SQL Server Data Source, it does not import the Guids.
The Query I'm using is:
SELECT * FROM TABLENAME
The table Structure is:
ThingId ...

**0**

votes

**1**answer

35 views

### Powerpivot; Get a datadump from SQL vs creating a data model in excel

I have a SQL table that includes sales and lead data along with detailed account information, and I have another table that just includes detailed account information.
My question is whether it is ...

**0**

votes

**0**answers

13 views

### Excel quadratic trendline formula wrong?

I made a scatter plot graph on Excel, however the trend line formula does not replicate the values shown. Currently I have have this file here. Why is the formula not replicating properly and how do I ...

**0**

votes

**1**answer

25 views

### Is there a function to get the cell your equation is pointing at as the output rather than the value inside the cell?

For example if I had an function such as vlookup that put me into a cell could I then have another function that gives what cell it found rather then the value inside the cell?

**-1**

votes

**2**answers

37 views

### How to compare multiple columns and set values based off of it

I Reference to the picture in the link below, I need to find the best way to compare which Start Month and End Month row the current month is between and then set a cell somewhere else in the spread ...

**0**

votes

**2**answers

30 views

### Excel Formats Numbers as Dates

I have several very large .csv files that I need to work with, and Excel makes this very easy (obviously). One of the fields is in the format 10/3/2013 19:00, and Excel automatically converts this to ...

**0**

votes

**2**answers

22 views

### Multiple data tables in excel

I'm having problems building a data table off values that come from another data table. For example, with a black-scholes option pricing model, I first get the value of options at different strikes ...

**0**

votes

**3**answers

84 views

### Excel multi-criteria VLOOKUP

I have a really simple question for someone that uses excel regularly...
I have a data (Data) sheet and a report generation sheet (Report).
I'd like to grab a cell value from the data sheet and ...

**13**

votes

**2**answers

656 views

### Excel does not honor the delimiter setting for reading or writing CSV files

When saving/opening CSV files in Excel, the default separator is a semicolon (;), as I need it to be a comma (,) I tried to change it by changing the Language and Regional settings following several ...

**0**

votes

**2**answers

21 views

### Applying Conditional Formatting in Excel

I have a column called Result in my excel sheet. For this column 'K', i have applied Data Validation and now the entire column can take only 2 values i.e Pass, Fail.
Now using conditional formatting ...