Tagged Questions

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
5 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 ...
-3
votes
0answers
22 views

How to do this in excel [on hold]

Code Product Cost Margin GST Customer Price Margin 2345td Bicycle Boy $ 125.50 8.50% 34534gdf Bicycle Girls $ 123.20 ...
0
votes
0answers
7 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
1answer
29 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
1answer
15 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 ...
-1
votes
3answers
19 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
1answer
23 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
1answer
12 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
3answers
33 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
1answer
17 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
0answers
27 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
1answer
33 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
2answers
43 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
2answers
28 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. ...
1
vote
1answer
11 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
0answers
19 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
0answers
20 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
1answer
13 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
2answers
19 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
1answer
22 views

CF 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
1answer
23 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
1answer
7 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
1answer
27 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
0answers
8 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
1answer
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
2answers
35 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
2answers
20 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
2answers
21 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
3answers
59 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 ...
12
votes
2answers
579 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
3answers
14 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 ...
-1
votes
1answer
22 views

How to make COUNTIF only count subtotal for visible records when filter is applied

I would like a formula to COUNTIF the Brand 3 column and if filtered the COUNTIF changes to filtered criteria. TOTAL COUNT 0 0 3 COUNTIF(H3:H5,"VoID") Area ...
0
votes
1answer
13 views

Excel 2010 PowerPivot: How do I avoid apostrophes being displayed as ’?

When I import a text file to PowerPivot containing apostrophes, they are automatically converted to ’. I've been manually correcting the few that I find in the PowerPivot window, however when I do ...
0
votes
1answer
18 views

Excel lookup by cell value in another broad cell

I have two different excel tables. one table column contains first name of employee and another table contains multiple first names in one cell and their other values. for Example. first table ...
0
votes
2answers
35 views

Find partial text in Excel 2013

In Excel 2013 I would like to find the value in column B in the row where a string matches a string in column A. What complicates it is that the strings in column A are allowed to be shorter than the ...
-1
votes
0answers
16 views

How to limit a loop until there is data in a certain range [on hold]

I'm in the following situation: In Column A I have some Ac numbers and in column B I want to have a vlookup with their values ( listed in a separated spreedsheet), the fact is that according to the ...
1
vote
2answers
27 views

Copying the background image in Excel

I use Excel 2003. I have an Excel document, and I need to extract the background image from a sheet in order to put it in other sheets of this document. How can I do that?
0
votes
1answer
23 views
+50

Transferring information from a row of data in an excel document into a web form

I spend hours on end every week transferring information from an excel file into a webform. Right now I am copying and pasting each cell individually. What I would prefer to do is select a row in my ...
0
votes
1answer
8 views

Excel 2013 Data Validation List no longer works in my workbook

I am using Microsoft Office Professional 2013 with Excel 2013 on a Window 7 Enterprise Laptop. I have run into a problem that I cannot correct. I have a worksheet that I have been tracking data in ...
-2
votes
0answers
20 views

Excel #value Error [on hold]

I am trying to get data from one worksheet to another by simply hitting +, then going to the worksheet and cell and selecting it. I have found that part of the probelm is that the cell I am trying to ...
-1
votes
4answers
53 views

Splitting up an address into different cells

I have column of addressed in this format: 120 Lemon Street Columbus OH 92738 (Basketball Courts) And I need to split it up into: street address (120 Lemon Street), city (Columbus), state (OH), zip ...
0
votes
2answers
39 views

Excel last appearance of a given string in a column

I am using the LOOKUP function to find the last appearance of a given string in a provided column, like this: LOOKUP(A3;Runs!D3:D6;Runs!A3:A6) However, the bounds in the vector are hard-coded: ...
0
votes
1answer
19 views

Separating a cell by first occurrence of a number

So, I have a bunch of cells like this: Freddie’s Restaurant 102 Super Lane San Diego California and I want to pull out the name, which is always preceding the start of the address (102 Super...). ...
1
vote
0answers
13 views

Multi Series Graph on Excel for Mac

I'm trying to fit twelve different series on a scatter plot with x and y variables. Excel doesn't seem to recognize this. How do I design this graph? All I keep getting is this:
0
votes
1answer
49 views

Auto Sequential numbering based on cell criteria - create two independent automatic numbering sequences

Is it possible for the numbering in column A to skip any rows that have the Word "TOTAL" in column C but pick right up again in the next rows? At the same time can the rows with the word "TOTAL" in ...
0
votes
1answer
31 views

How can I list data and create a summary table?

Let's assume I have a table with sports results somehow like this: player A | player B | 2 | 1 | player C | player D player C | player B | 1 | 2 | player E | player A As shown in table, there are ...
-1
votes
1answer
43 views

Time Range Checking

Table A Agent login date logout date working time(hrs) Actual working time(hrs) B 10:00 AM 12/1/14 11:00 AM 12/1/14 1:00 0:30 A 3:00 PM 12/1/14 ...
1
vote
1answer
16 views

Why does Excel only invoke the Text Import Wizard for .txt files?

Excel ignores comma delimiters in .csv files, but invokes the Text Import Wizard for .txt files that "appear delimited". Surely it should behave the same way for .csv files?
1
vote
0answers
9 views

Windows Xperia excel 2010

I have 50 work books each work book is for 1 subcontract operative. Also each operatives work book has 52 sheets one for each week. I need to extract the same cell (£ payment total) to list the weekly ...
1
vote
1answer
13 views

Searching for a Specific Text Font in Excel

Is there a text font in Excel for which all words with the same number of letters share the same space horizontally? For example, one of my column is AAACCEINPU AABBEILMTT AABCEILLMP ...