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)

-1
votes
0answers
6 views

Is it possible to import an amendment file into Microsoft Access?

I'm having a tough time trying to figure out if it's possible to import some sort of amendment file into a known Microsoft Access database and have it update the original data that was imported. ...
1
vote
1answer
17 views

Spreadsheet data harvesting

I have an Excel spreadsheet (.xlsx) with multiple rows and columns of cells containing space-separated text. For example: A1 the good of the many B2 all dogs go to heaven C3 eat my shorts I ...
0
votes
1answer
12 views

Hiding Date in Formula if nothing is entered

I want to have a Date forumla that adds 7 days to a date entered in another cell, but if nothing is entered I would like said cell to be blank A1 if blank then have B1 blank A1 is 2/1/2015 then have ...
0
votes
0answers
12 views

Finding an exact match for a dataset in Microsoft Excel

I have a lot of numeric data in one column that I have pieced together from various other worksheets. I found some data in another worksheet that may be a copy of data I already inserted into the ...
0
votes
1answer
18 views

Is it possible to sort Word (or Excel) table by entry modification date?

I have a MS Word document where I accumulate and frequently modify certain data in a very long table. So I would like to sort the data by latest modification time in the rows. Of course if I add a ...
1
vote
0answers
10 views

finding data with multiple conditions and replacing it with new data

I am working with 2 worksheets, 1 contains all my raw data and the other works as a dashboard with my pivot table and charts. I hope you can help me create a cell input range in my dashboard ...
1
vote
0answers
26 views

Microsoft Word, Powerpoint, Excel adding unnecessary letters while opening a file

Downloaded and opening a word file from web add the this kind of formatting at the end of each paragraph. What is the reason? Here is the image to let you know the problem ...
0
votes
1answer
19 views

MS Excel formulas displaying #REF when data is entered in a cell in a certain way?

I have various complected formulas pulling data from two pages (used as data entry pages), formatting it in specific ways, and displaying it on another third page (all in the same work book). This ...
-1
votes
0answers
12 views

Vba Excel to click a browser link not working

I made a Macro that successfully logs in to my company's website, however I cannot navigate through the rest of links. After loggin in, the addres becomes ...
0
votes
1answer
19 views

Description from one sheet into comment of another sheet in Excel

what i have an excel with incoming on one sheet and code descriptions on another i would like to auto create a Comment displaying the description of the incomming codes or is this possible. ex. ...
-1
votes
1answer
8 views

Setting a specific xlsx file to always open a unique EXCEL.EXE process

I have an excel file that contains some visual basic forms used for data validation and entry. However, I'd like to be able to copy and paste from other open spreadsheets occasionally. The problem is ...
-2
votes
1answer
26 views

Excel VBA copy value to new

I'm brand new to VBA and macros. I've been stumbling along rather decently, but I've come across this problem and I'm not sure how to tweak the code. I need the user to be able to enter a value ...
0
votes
0answers
12 views

Comparing data from two identical pivot tables

Is it possible to compare two separate pivot tables that have exactly identical row and column names (obviously differet values), either in a another pivot table or some other way?
0
votes
0answers
13 views

Is there a way to recover a document if the document has never been saved for Excel 2007?

I unchecked the auto recover box by accident and in the middle of my calculations my computer crashed. Is there a way to recover the workbook I was working on when it crashed? I never got the chance ...
0
votes
0answers
15 views

Excel or Access? Analysing large data set [on hold]

I have been reading suggestions whether to use excel or access- but can't seem to find a solution. I am aware that Excel is best with number and analysis, and Access is best for storing large data. ...
0
votes
1answer
13 views

Copying data from an entire column in excel worksheet into another worksheet minus blank cells

Instead of using a copy and paste function is there a way to lookup data in an entire Column rather than an individual cell in one spreadsheet and list it in another ( minus the blank cells )so it ...
1
vote
1answer
15 views

Searching for Re-occurances in EXCEL and using those Re-occurances

I am trying to create a function that looks to see if the value of a field, lets say "A1", occurs elsewhere in the "A" column, and then searches the rows of those re-occurances and if any of those ...
-3
votes
1answer
20 views

I need some help in excel validation [on hold]

I'm not good in excel. I need to include an excel sheet in my page, and I need an expert who can write these custom formulas for cells validation. 1) A column that accepts only letters, no numbers or ...
-2
votes
0answers
9 views

formulate and copy the data in another sheet [on hold]

i would like to enter students name in Sheet 1. sheet 2 contains age category like 6-7//sheet 3==> 7-8 and son on..... Data to be entered will be... Sheet 1==>Column A==>Students Name//column C==> ...
1
vote
1answer
25 views

How do I count multiple words available in sentences and multiple rows (countif, search)?

here is screenshot for the sheet. https://flic.kr/p/qZb8ot in column A there are some senteces list below: A2. T-shirts, Varsity A3. T-shirts, Sticker, Mug A4. T-shirts A5. T-shirts, Pin, ...
2
votes
1answer
43 views

What would be the the mathematical equivalent of this excel formula? =PMT()

I need to create a javascript form that does the same calculation as this =PMT() function. mortgage = 220000 rate= 4.75% term = 30 The example formula I have is =PMT(4.75%/12,30*12,220000*-1) What ...
1
vote
0answers
11 views

Lookup value based on part of a cell

In Excel, 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 I have another list of sub tasks, ...
0
votes
0answers
5 views

SUM spread across a series of cells unevenly starting with 0

I have a SUM, let's say it's 5000 users over a 12 months of growth. How do i show this is a series of cells where we start the monthly users at 0 per month and each the new subscribers and end at a ...
0
votes
1answer
17 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
17 views

Intersect ERROR:Method 'Range' of object '_Global' failed

Why A get this error: Method 'Range' of object '_Global' failed When I Put: Private Sub Workbook_SheetChange(ByVal WS As Object, ByVal Target As Range) Dim NTT As Range Set WS = ActiveSheet Set NTT = ...
2
votes
2answers
21 views

excel: export csv file with japanese character

In my excel file, the Japanese character is shown correctly, while when I export it as csv, the character become question marks How should I output so that the character can be shown correctly?
3
votes
1answer
29 views

Excel formula to get first and last non-empty value in a row and return column header

Let's say I have an Excel spreadsheet aggregating votes in some poll over a period of time as per the example below. How do I find the min and max value people have voted on on a given day (the ...
0
votes
1answer
13 views

Excel 2013 global automatic macros

I am trying to log the opening and closing of excel workbooks to replace the Journaling capability in office. I have created and tested VBA auto_open and auto_close macros in excel, which log these ...
0
votes
1answer
42 views

How do I display name in column2 dependent on value in column1?

I am doing an inventory for all the businesses of a street. I have a two sheets, where on one I have different categories for commercial uses. Each category displayed in sheet 1 has a number (1 to ...
1
vote
0answers
13 views

Build comprehensive formula for all precedent cells

Is it possible to build a comprehensive formula for all precedent cells? I'm aware and employ the "Trace Precedents" and "Trace Dependents" feature in Excel often, but this only goes back one "layer" ...
0
votes
2answers
12 views

Reformat vertical data to horizontal (side-by-side)

I have a spreadsheet containing groups of data in a vertical format, e.g. here are three "groups", each with five rows:- I would like to reformat the spreadsheet so the values are all side-by-side, ...
1
vote
0answers
14 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 ...
-3
votes
0answers
15 views

Annual Salary increment for selective staff in EXCEL 2007 [on hold]

Annual Salary increment for selective staff in EXCEL 2007 emp no 100 200 300 400 500 Amount 95 x (want the amount to here when I put "x" next to any empl) 1984 x 2659 ...
3
votes
1answer
10 views

Why can't I use a number wildcard to in Cells.Find in VBA?

I'm trying to search my Excel worksheet for any cell that has a value that begins with a number followed by a period, but this isn't working. Does anyone know why not? Cells.Find(What:="[0-9].", ...
0
votes
1answer
28 views

Excel formula related to if statement [on hold]

I need a formula which satisfy the following condition: If A1="Yes", then the corresponding cells B1, C1, D1......etc should contain the word "yes" IfB1="no", then the C1 should be "no" such that the ...
2
votes
1answer
8 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
11 views

VBA Code for changing background text for any text within a cell

I'm trying to make a row change colour to yellow based on if any text is within the D column. I have already set up 5 different colours for another cell, however need this to over-ride those ones. I ...
1
vote
0answers
25 views

Count non-blank values after a cartesian product in excel

I hope my description is accurate; improvements welcome. I have 2 tables in Excel. In Table1 there are 2 columns, A and B. It can be a many to many relationship. In Table2 there are 2 columns, A and ...
0
votes
1answer
21 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 ...
0
votes
1answer
18 views

Excel VBA: Intersect methode with several names range [on hold]

The Intersect don't work. Dim NTit As Range Dim NInf As Range Dim NDat As Range Dim WS As Worksheet Set WS = ActiveSheet Set NTit = WS.Range("$A$1:$J$1") Set NInf = ...
0
votes
1answer
13 views

Publishing an Excel Spreadsheet Online

I'm working with a client that uses very sophisticated excel spreadsheets for generating purchase orders. They would like to place these online so a dealer could use it to submit a purchase order on ...
-3
votes
0answers
25 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?
0
votes
0answers
40 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 ...
1
vote
1answer
24 views

Select Cells in Column Up to End of Data in Adjacent Column on OSX

I know there is a command to do this but I just can't find it. The answer here should have used this command but did not. Q: Given an empty column (B) adjacent to a column populated with data (A). ...
0
votes
1answer
40 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
0answers
17 views

Spreadsheet finding and sorting most frequent appearance of names

I have a spreadsheet that looks like the following: https://docs.google.com/spreadsheets/d/1BN3GNRFCsBeHu9gQaKzIo7bfFRkcDqMJ6VMtidEwPD4/edit?usp=sharing There is a set list of names in Column A. ...
-1
votes
0answers
25 views

Excel: sumif, index/match: reached the end of my ability

Im sorry to come begging for help and i have been all over the palce trying to find a way around this. I have tried all sorts and also done a lot of searching on the interweb... what I have vound is ...
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
0answers
16 views

Excel- How to use lookup formulas to look up on part of the content of a cell [on hold]

I created a table with a searchable drop down list that gives you all the prerequisites for the class you choose from the drop down list. I chained it so that it gives you up to five prerequisites ...
0
votes
1answer
11 views

cumulative profit of each client in table no 2 from data of table 1

I want cumulative profit of each client in table no 2 from data of table 1 formula i use is ...