The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
4 views

Excel - If Cell A contains part of value of Cell B, Cell D Generates associated data from Cell C

I have a list of tasks (column A) , with one master ID number (Column B) This master project number is a combination of text and numbers in format ABC.001 And i have another list of sub tasks, each ...
1
vote
0answers
7 views

Excel Index Match with IFs?? + options for next in list

OK I have been working on this for some time and can't quite get things right in the various combinations I have tried, so I am asking for advice. I have a management data table where column C is a ...
0
votes
1answer
15 views

How do I get URLs from hyperlinks in Excel 2010?

I have a column of cells with hyperlinks (to web addresses) and I need their URLs to be regular text. Is there a way to extract the URLs from hyperlinks? Example: Cell says: "CLICKME" Links to: ...
0
votes
1answer
13 views

Inserting 'n' blank rows using a macro

I am currently trying to develop an excel spread sheet to make it easier to format. What I would like to do is create a macro to insert blank rows in multiple places without affecting subsequent rows. ...
0
votes
2answers
14 views

How do I copy value in different column from previous row if the cell is not empty?

I have the following situation: A B 19260218 234 77 ok 3 ok 19310328 174 46 2 When the value in column B is numerical, I have a ...
1
vote
0answers
13 views

Select elements in an array that satisfy a criteria

The goal: Kappa-Sigma clipping in Excel I want to implement a selective linear regression formula in Excel (avoiding VBA). I have a data sample on which I need to apply a linear regression. But my ...
2
votes
1answer
6 views

Restrict paste into dropdown cells in excel

I have one excel sheet which contains many dropdown columns. Lets say one column has Test1, Test2, and Test3 as dropdown option values. Cells under this column should not accept the values other than ...
0
votes
1answer
19 views

Placement of Secondary Horizontal Axis

On the primary horizontal axis I can go to Format Axis > Line Color and Style. There I can choose the color and style of the line that represents 0 on the primary vertical axis. However, with the ...
-3
votes
1answer
22 views

Removing a column of hundreds of bad addresses from the main address column [on hold]

How do I remove a column of hundreds of bad addresses from the main address column? Do I have to find/delete each address individually?
1
vote
1answer
15 views

How do I use the corresponding number to make the selection in a dropdown instead of using the mouse?

I looked at the information and it is just showing how to create the dropdown which I can do but I want to be able to type 1 and have it come up Very Poor, or 2 and have it come up with Poor, 3 ...
0
votes
0answers
39 views

Daily Calculation Average [on hold]

I have a calculator that I created for my teammates. The calculator asks for 3 pieces of data that outputs 1 piece of data. The output is then copy and pasted into a daily tracker by the user. The ...
0
votes
1answer
38 views

Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only? [on hold]

Countless times a day, I go into Windows Explorer, shift-right click on an Excel file, Copy as path, then go into Run, type Excel /r (paste), which opens my Excel file as read only. Is there a way to ...
0
votes
2answers
19 views

Array formula, slowly work on Excel [on hold]

Does the array formula make excel to run slowly? i'm talking about a range that contain 1000 raws and 10 columns.
-1
votes
1answer
22 views

Merge Two Dynamic Tables in One Table [on hold]

I have try to merge/combine two tables but I have always fail. How can I merge/combine two dynamic tables in one table
0
votes
1answer
32 views

Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets Sheet 1 contains 2 columns. Column A has a range of unique alphanumeric identifiers. Column B has a range of non-unique numbers. A B ...
0
votes
0answers
19 views

What do I need to see if there is matching formula between two cells in Excel?

I'm awful at excel and I'm trying to figure out what I need to do to see if there is matching formula between two cells. As an example D6 has a number 55, P6 has something like mon200055. Is there a ...
0
votes
0answers
37 views

Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names. In Column B, I have n number of Order numbers for each name. In one cell I will be inputting the number of orders I want to pick randomly. Once I input the ...
0
votes
0answers
11 views

Date FileDateTime in sharepoint

Sub Test() myURL = "http://sps.ap.emersonprocess.com/sg/pssops/svcops/APServicePortal/ChartTemplates/ Filename = "IBS-CCR-AP_Prod.xlsx" myURL = Replace(myURL, "http:", "") myURL = Replace(myURL, "/", ...
-1
votes
2answers
22 views

How can I assign Cell Part as Variable?

I want to set a number in a cell to be a variable yet still keep text in it. That way it can be added up later using that variable. I want it to say something like Justicar Aatrox: 975 And ...
0
votes
1answer
15 views

How do I change the DATA TYPE of a cell or group of cells?

I have a large spreadsheet of data which stubbornly will not change data type. when I run the type() formula on a cell, it returns the value 1, and it will not change no matter what I have tried. ...
0
votes
1answer
21 views

apply conditional formatting to a cell when it matches the text in another column on another worksheet

I have a list of accounts in column a of sheet one. I have a sublist of the same accounts in column a of sheet two. If the account name in column a of sheet 1 matches an account name in column a of ...
-1
votes
0answers
24 views

HyperLink to Another WorkBook based on a cell value [closed]

I have two Workbooks. WorkBookA.Sheet1 and WorkBookB.Sheet1 In WorkBookA.Sheet1 in cell S1 I have the value of US1000. I would like to hyperlink to the cell containing the Value of US1000 found ...
0
votes
0answers
28 views

Slicers: Can a slicer filter using more than one column?

I'm looking to create a slicer (or some other filtering mechanism as part of a dashboard) to filter data that may exist in more than one row. As a very simplified example, suppose I had a table ...
0
votes
0answers
10 views

Use named range within index match

I have a named range (DATA_DUMP_GROCERY) that I am trying to pull values from using index match. Here is my formula: =INDEX(DATA_DUMP_GROCERY,MATCH(Confectionery!$B$15,DATA_DUMP_GROCERY,0),4) As ...
0
votes
0answers
13 views

Update links to another excel workbooks

I have a excel work books that I use VBA programmed macros to open serval another workbooks (WB's). In the main WB I have a lot fomulas that is linked to the another WB's. After open all files, I ...
1
vote
3answers
18 views

Excel 2010 is lower rounding a number entered as a custom format for a credit card number

I have used the custom format for a cell as follows ####-####-####-#### When I enter the credit card number it will round down only the last number to a zero "0", no matter what number is entered. ...
1
vote
1answer
20 views

Get the cell number from double clicking on it and put it into another formula

As part of my ICT work we need to create a battleship game and one way I was thinking of doing it was using =IF(ISNUMBER(SEARCH("*x*",C3)),"HIT","MISS") to check if that cell contains x but ...
0
votes
2answers
26 views

Excel - auto calcuate pallets based on qty

So, I been thinking how to program this... There is product A, has two different pallet quantities (Qty 8 & qty 10). When customer orders (ex: 72 qty of product A), I have to manually divide it ...
0
votes
2answers
17 views

Dont show 0% data labels in excel but show -0.1% and +0.1%

I've managed to hide data labels with 0% by using the number format 0.0%;; but need to show -0.2% and that's been removed - how do i hide 0% but show +0/1% and -0.1%?
0
votes
1answer
54 views

How to control excel cells together with vba script?

In the userform there are product names (combobox) , prices , amount (textbox). For product name control I use with combobox . I write amount of product to my textbox as a manuel when I choose the ...
1
vote
1answer
80 views

How to add photos to specific cells in my Excel worksheet from my computer?

This is the code which I used : Private Sub Image1_Click() Range("C1").Select Application.Dialogs(xlDialogInsertPicture).Show End Sub Private Sub Image2_Click() Range("D1").Select ...
1
vote
0answers
28 views

Show webpage in excel

I have an excel file with a lot of urls, which I have to look through and mark. My idea is now, to preview the urls in a tiny box when I hover over the url. However, I cannot find such functionality ...
1
vote
1answer
25 views

How to count number of unique buyers in excel? [closed]

I am creating a workbook for sold items of my company. and I have a list of items in column O of one of my sheets. now I want excel to count the number of total buyers and number of unique buyers. I ...
0
votes
1answer
15 views

Microsoft Excel - Functions sum values after mulitplying multiple criterias after looking up tables

have provided a link to the excel worksheet that I need to resolve. I have worked up for two values in cell B9, which I need to do for other criteria which goes beyond 18 or so. Formula that I used is ...
1
vote
1answer
33 views

Excel 2010 - Need to sum dynamic range based on trailing 3 months

I am trying to sum a dynamic range for a list of entries 3 months before and 3 months after a specific month. I think I need to use an array to get this, but I'm not able to find what I need to do. ...
1
vote
1answer
27 views

Excel VLOOKUP with named range not working

I have the following VLOOKUP on a worksheet: =VLOOKUP(D5,FilePurposes,2)&" in respect of "&C5 Where the named range FilePurposes refers to a block of two columns and three rows that look ...
-6
votes
2answers
47 views

Excel automatic answer [closed]

Good day! Can you pls help me do this code? I have Column A for my item, Column B for qty, Column C for designation and Column D for price. Now, what I wanted to do is that, when I put "water" to ...
-1
votes
0answers
13 views

Page Layout Tab Freeze [closed]

I highlight the work sheet than click on page layout on the excel ribbon on top of the sheet. The page layout "tab" does not want to respond. This happens intermittent. What is the problem and how ...
0
votes
1answer
13 views

Need to change the cell colours exactly as matched in other excel sheet

I have two excel files with similar set of data in columns. One sheet has specific colours in the data and the other sheet has some values. I need to copy exact colours to the exact matching cells. ...
1
vote
2answers
20 views

When I copy table data into excel, it ONLY pastes it into column A! How to fix this?

If I use the following link: http://web.utk.edu/~dhouston/excel/exam1.pdf to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has ...
0
votes
1answer
47 views

How do I get Excel to identify a country from city list?

I have a list of data with many columns. In one column - let's say C, there is a list of cities/places. There are multiple entries, i.e. one city pops up loads of times in a column in different ...
0
votes
1answer
25 views

Excel changing UNC paths in shared workbook

Excel documents stored on network drive, for example, \\networkdata\Excel\Shared Data workbook.xls contains tables with data entered into. Report.xls contains UNC paths pointing to ...
1
vote
1answer
45 views

excel vba userform/button coding

I have created a workbook in Excel. To navigate I have inserted a userform. I have code which takes me to a spreadsheet once a button is clicked on the userform. Now I would like a button on the ...
0
votes
1answer
27 views

How to display US format date time in csv file in UK format in Excel 2010?

I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...
1
vote
2answers
33 views

How do I create spreadsheet that will alert me when a quantity drops below a certain threshold in Excel 2010?

I am trying to make a sort of "inventory helper" spreadsheet that can track quantities. On the summary sheet, I want to be able to enter a quantity into a column called "On Hand" and then if that ...
0
votes
1answer
17 views

Using the text values from one column to lead to output in another

I have a list of cities in one column, Column C. I have a list of countries which relate to each of those cities. How do I get Excel to look at the Column C, compare to my list of countries (I can ...
0
votes
0answers
31 views

How can I save realtime data from external source to excel?

Excel can stream live data from an external source on the internet. One example is stock quotes from google finance. many trading platforms also allow linking to excel. So one can see in excel, a row ...
0
votes
0answers
10 views

Excel 2010 - Pivot Table Inquiry

Is there a way for the report filters from the pivot table to go to the row labels whenever I choose an option in the slicers?
0
votes
0answers
27 views

Expanding abbreviated text with Substitute formula in Excel

I have a spreadsheet contains a list of 24k items found in a grocery store. Most items have abbreviated words such as: w/ for with; choc for chocolate; sauv for sauvignon. Yet the list contains both ...
0
votes
1answer
38 views

Determine days in Excel formula

Is there a way to get a number of days based on ONLY 1 column of dates? E.g., column A has dates: A1 - 12/31/14 A2 - 1/1/10 A3 - 4/5/14 A4 - 12/31/12 A5 - 12/31/14 A6 - 1/8/15 I am trying to ...