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
0answers
5 views

Using two Private Sub Worksheet_Change(ByVal Target As Range)

Private Sub Worksheet_Change(ByVal Target As Range) If Range("B10").Value = "0" Then Rows("9:12").EntireRow.Hidden = True ElseIf Range("B10").Value > 0 Then ...
0
votes
0answers
11 views

In Excel, How can I count duplicate names in one cell once, if they are attributed to another name

How can I count duplicate names in one cell once, if they are attributed to another name in another cell. One column A contains teachers names and column B contains student names. I need to know how ...
0
votes
0answers
12 views

Excel 2011 conditional formatting, problems w/ adding deleting rows

I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...
0
votes
0answers
12 views

Getting current value and passing it to another function

A B 1 Date Data 2 1/1/2014 1 3 1/2/2014 2 4 3/5/2014 3 I wanted to sum up rows for certain months. With month I can get the month and sumif ...
2
votes
1answer
11 views

How to export data from Excel to SQL Azure?

I know how to import data from SQL Azure into Excel From Excel go to: - Data - From Other Sources - From SQL Server I want to manually edit data and post it back to SQL Azure. What is the ...
0
votes
2answers
24 views

Searching and Inserting Data Based on Date Range

In another post, a formula was given that was meant to help search and insert an entry if the date associated with the entry was less than the date on another sheet. The formula was as follows: =IF( ...
0
votes
0answers
17 views

Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...
0
votes
5answers
23 views

Pivot table - Summarising multiple independent data columns

I have a large table containing daily inputs into a system, which has the columns as shown: Day Itemname1 Itemquant1 Itemname2 Itemquant2 ..... The item names and quantities are independent of each ...
0
votes
0answers
14 views

How to exclude my titles and name an entire row so it can be updated

I have an assessment where I have exported data from Access to Excel and need to do a mail merge but am having trouble understanding. I need the first name column to be able to update if and when ...
2
votes
0answers
30 views

notepad and notepad++ don't show same thing?

I have exported text from Excel in Unicode, like this: then I edit with Notepad++ and change it to my desired form and save it as UTF-8 like this: but when open it it in Notepad it is in ...
0
votes
0answers
15 views

Reference last cell not only in a row or column, but in a range

all users, especially Jerry Beaucaire. I was reading this link when I stumbled upon his answer Here is the link How to refer to the last cell in a row in Excel? And Jerry Beaucaire answered it like ...
0
votes
1answer
28 views

Can I separate a list by keywords?

Say I have a list: Something something apple Something something orange Something something banana Something apple something Something banana something Something orange something Something something ...
2
votes
1answer
28 views

Excel Help: How to scan a row and return the value of the first cell in that column

I have a matrix of numbers and the matrix has column header -- say like this: a b c d e f 0 0 0 1 0 0 0 0 1 0 0 0 What I want to do is to search for each row for the element 1 and return its ...
0
votes
2answers
27 views

Excel - Is there a function to return a number based on which string is in a cell, like CHOOSE but not?

I need a function =Func(A1, "Alex, "Betty", "Charlie") that returns the index of the matched entry. If this function is put into B1:B13, it would show "Charlie" 3 "Alex" 1 "Alex" 1 "Alex" ...
2
votes
3answers
19 views

Custom Sort using Excel without Custom List

I want to be able to sort excel rows where data looks like Column - 1 Other Columns 701-GBL-1843-MLMK blah 566-JJB-2785-MYJW 254-WYD-3220-NAND 884-GLE-2843-FRYA And I want ...
0
votes
0answers
16 views

Excel or Google Sheets - How to update smoe columns

I'm working with some back-end software that generates a work queue for our purchasing department. The work queue is a spreadsheet that looks like: ...
0
votes
1answer
28 views

Web scraping / crawling a particular website

I'm trying to scrape 1265 html files at once to get name and descriptions of items I have on a website. I have permission from the wholesaler to copy there data but I don't want to spend days just ...
0
votes
2answers
22 views

Weird File Attributes in Excel Save Dialog

I vertically re-sized my excel Save As dialog today and found a bunch of strange file attributes that I've never seen in the dialog before. They only appear when the dialog is resized small enough ...
0
votes
2answers
19 views

Expand Excel ComboBox on click

How can I set up my combo boxes on the form i am building to open automatically when clicked on the field portion not just the arrow? I have been searching for a while and I can't seem to find any ...
0
votes
1answer
29 views

How to create a relational data table in Excel

If I have the following Table1 in Excel Name Age Sex Pablo 28 Male Victor 32 Male Juan 33 Male Pedro 40 Male Jacinta 24 Female Laura 39 Female And Table2 Sex Color Male ...
1
vote
1answer
19 views

How do compare similar contents AND return a cell's contents?

In Excel, how do I tell it to compare two tables with SIMILAR primary keys, find a relatively close match, and then return the info from one of the cells (more than just a yes/no, 1/0, true/false. ...
0
votes
2answers
28 views

Using IF to Place A Value in A Different Cell

Is it possible to do something like the following? =IF(A1=0, Place "Yes" in B2, Do nothing) I was considering using =OFFSET somehow, but I'm really not sure how I would implement it here.
0
votes
0answers
19 views

Changing what browser Excel hyperlinks open in

Right now all of my hyperlinks in excel open with IE. I'm hyper-linking Google sites though, and I would prefer that they open in Chrome. How do I change what browser hyperlinks open in? There's no ...
2
votes
1answer
18 views

Navigating an excel document using excel links

I'd like to be able to click on some text in a cell that automatically moves the insertion point to a specified cell or row. So ideally I could have a cell (or some text in a cell) say: ["see row ...
1
vote
1answer
49 views

Avoiding Long Nested IFs in Excel Function

I have a formula that relies on two different inputs: the first is an integer value between 0 and 5, and the second is the rounded sum of values in an array. I would like to have users input values ...
0
votes
0answers
19 views

Excel function with the same name as cell reference

I'm using an add-in to Microsoft Excel called Isoplot, it's used for analysing and processing radiometric data for dating geological materials etc. One of the user defined functions is intended to ...
-4
votes
1answer
19 views

Formula for moving data up in excel

Can anyone help me with a funciton in excel. I have a customer that has their data all in one column. I need a funciton so that its over multiple columns on one line. Example Below: Column A 77.12 ...
0
votes
2answers
24 views

How to write the cells in rows one under the other in columns?

I have a list of name, company, phone number, address and e-mail. But each name who works at the same company is in the same cell. Of course, the other informations of those names like phone number, ...
-1
votes
1answer
14 views

Excel linking two to three column

i have a table of productid, product name and price. In Excel Productid i want to give as drop down & on selection of particular id the respective name and price should appear in next column ...
1
vote
1answer
16 views

Excel Conditional Formatting Colour Scales highlight group of cells when another cell is a certain value

So I have a document that has 2 drop downs with the first acting as a currency selection and the other acting as a discount selection (0% - 50%). Basically whenever I select from the dropdowns the ...
1
vote
1answer
15 views

Trying to sum a column of values between settable dates

So I have a list of costs over a period of time. Each row is a date, descriptor, quantity and value. So looking at the image, all the values in B, C and D are entered manually or through some other ...
0
votes
1answer
11 views

COUNTIFS Statement Between Dates

I have a report I am creating that sifts through a lot of Data, I have created a COUNTIFS statement that does what I want, but I am having trouble with the dates. I am trying to find the number of ...
-1
votes
1answer
40 views

How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach. Basically as i stated in the title i need to write a macro that will copy the selected row or ...
0
votes
2answers
16 views

In Excel 2010, how do you format text to string without having to open and enter on every single cell?

I was given an Excel document. In the data there is a column of dates formatted 5/20/2014. Half the data in that column is formatted as a date. The other half is formatted as text. When I try and ...
-2
votes
0answers
16 views

How do I remove icons from ribbon and menus office 2013?

In (Windows 8.1 Office 2013) Excel 2013 the menu caps don't bug me, but how can I have text only and remove the icons? I want text and remove/hide the icons. Is there a Text Only option?
0
votes
0answers
22 views

Rounding Percentages

Okay so I have been having a problem and would really appreciate any help. I have posted a table below with the aim of making this as simple/precise as possible. Value % ...
0
votes
1answer
15 views

What's wrong with this COUNTIFS() formula?

Will someone please help me with the following formula =COUNTIFS('CURRENT LEAD LISTING'!$C$2:$C$378,"ACT",'CURRENT LEAD LISTING'!$E$2:$E$378,"X",'CURRENT LEAD ...
0
votes
1answer
17 views

Excel help to lock formulas from adjust on cell insert

I have a excel workbook where there is a hidden sheet that basically pulls data from other sheets in the same workbook just using the = formula. The problem I am having is if I add a column or cells ...
0
votes
0answers
17 views

Why doesn't trace precedent/dependent when using table references?

I almost exclusively use tables when using excel, so my formulas are all using table references. This seems to make the "Trace Precedents" and "Trace Dependents" functions not work though. Has ...
0
votes
1answer
14 views

Autofill in Excel skipping rows

I am trying to accomplish something with excel but I cannot seem to make it work. In a worksheet I have a simple table with rows and columns. Every row is a new entry. I then have a template in ...
0
votes
1answer
20 views

Assigning a number amount

I know that if I am assigning a number amount to a word that I can enter it in as: =COUNTIF(D3:H3,"Yes")*20 But what if I also want the same cell to assign 10 if the answer is no? How would I write ...
0
votes
1answer
25 views

Creating GANTT Chart (Timeline) From Start Time and Duration

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this... The desired ...
0
votes
1answer
19 views

Automating building a table from web sources in MS Excel 2013

I want to build a table indicating a number of things available in a given market. To do this I access the sites with relevant information and copy numbers to a table each day. I would love to ...
-3
votes
0answers
21 views

I need to send an email multiple times to a different recipient each day [on hold]

I want to send an email reminder to around 200 recipients that I would like to schedule at the start of the academic year. The problem is, I need to send it to a different person (group of people) ...
0
votes
1answer
32 views

How do I lookup and return to multiple value?

Please could you advise how could I get a list of expiry dates which matched with Cell A1 =the material number?
0
votes
0answers
14 views

Is there an equivalent for Aero Snap for windows in Excel?

I'm running Windows 7 and find Aero Snap really useful. However, I can't find a way to perform the same action within Excel 2010. Is that something that's possible to do? If I have two spreadsheets ...
0
votes
2answers
24 views

Counting Number of unique combinations for multiple columns

I have an excel file with 272,000 lines of data across 5 columns. The data looks like this: A B C D E 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1 1 0 0 0 0 1 0 1 0 1 ...
0
votes
1answer
15 views

Apply a formula to an entire column since the number of rows is changing from a source file?

I have a connection to a text file source so the excel worksheet updates automatically. Therefore the number of rows is always growing every time it updates. How can I apply a formula to an entire ...
2
votes
1answer
22 views

With PowerPivots, find items that appear *only* in one category

With PowerPivot, how do I find items only in one category? Here's an example: item category number obera f6 7 artois f7 2 obera f7 3 ella f6 9 If ...
2
votes
1answer
13 views

Use IRR function with discontinuous cells in EXCEL

Is there a way to use a range of cells that are not next to each other with the IRR function? I'd like to use IRR this way: =IRR(A1:A3 AND B2) meaning read A1, A2, A3, B2 the same way you would ...