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
17 views

Hiding the Microsoft Query table properties in Excel

I have done a data connection in Excel using the "From Microsoft Query" data connection type. In that i have also set criteria where the values are taken from a particular cell. This is so that the ...
0
votes
0answers
13 views

Dynamic Scenario output in excel

I have a model where in the input numbers going into the model depend on the cases/scenarios i select from a drop down menu ( Base, Best and Worst). These numbers are then used across all remaining ...
-2
votes
0answers
39 views

setting up notification by email from excel

I maintain a service schedule in an Excel spreadsheet. I would like Excel to notify a workgroup by email 30 days before a due date that it is coming up. Is it possible for Excel to send, or trigger ...
0
votes
1answer
18 views

Excel 2013 scatter plot

Hi I'm creating a sieve analysis graph. The graph is in logarithmic scale but I want the labels in the horizontal axis to be exactly as per the sieve sizes (horizontal data values) Can I make the ...
0
votes
0answers
17 views

Find and replace multiple values within selected cells using another workbook

I was wondering whether anyone could point out what's wrong with the VBA code below. It's based on the following: Find and replace multiple values within selected cells I want it to take the find ...
1
vote
2answers
73 views

Hiding all but the selected rows of data

I am unable to send any pictures, The data contains 98 column headings, with the first column being unique identifiers, and 1000 rows of items. I receive commentary on specific items throughout the ...
1
vote
1answer
39 views

How to set up data validation to allow only a date or a specific string

I would like to use data validation to ensure someone has entered a valid date, but I'd also like them to be able enter TBD - just those two options. Is this at all possible without VBA? Is there a ...
0
votes
3answers
37 views

Excel X Y (Scatter) Chart more than one value per cell

Is it possible to have more then one value in a cell and then use a X Y (Scatter) chart to represent the dots on the X and Y Axis ? Here is what I mean: Instead of having just one value per cell ...
1
vote
1answer
23 views

Flip x and y axes in Excel graph

This should not be very difficult, but I cannot figure out how to do it. I have a table similar to this %low %high 0 0 12 1 13 26 ... 19 90 94 20 95 100 When I graph it, excel ...
0
votes
0answers
21 views

direction does to RTL in Excel when I add sheet

When I add a new worksheet to my workbook in Excel 2010 (by clicking the button insert worksheet next to sheet names), one sheet will be added and the direction goes to RTL from LTR automatically and ...
0
votes
1answer
28 views

Copying worksheets in Excel

I have a shared Excel workbook with two worksheets in it named "PREVIOUS" and "CURRENT". At the end of the night, I would like to click a button or perform some action to have the CURRENT sheet copy ...
-3
votes
1answer
47 views

How do I get image hyperlink in text?

I have images with hyperlinks (copied from internet). I need to convert those hidden hyperlinks to URL in another row. How do I do that?
2
votes
2answers
33 views

XLS files on website

I have an XLS file, such as www.mysite.com/test1.xls. When clicking on the link it always brings up the spreadsheet inside Internet Explorer, with excel embedded in the browser and in a less ...
1
vote
1answer
40 views

Changing a String Value to Date format in VBA

I am working on a VBA scripting in Excel. The following is the code that i am working on. Option Explicit Sub MoveThingsAbout() Worksheets("Sheet3").Cells.Clear ...
1
vote
1answer
41 views

Use data from a drop down list to populate table

I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month. When an employee ...
1
vote
1answer
25 views

How to show 0 if formula is not complete in excel

I am using the formula =SUM('7-10'!F12+'8-10'!J12-'8-10'!F12) This is to work out average daily sales in 24 hours. But if no sale is recorded for 7-10!f12 but sales are recorded for 8-10!f12 it ...
-1
votes
2answers
27 views

Excel: Complete row Hash Value calculated as a Numeric value in a cell on same row

I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns. Downstream Teams often submit revised columns that I have to incorporate into a master ...
0
votes
0answers
14 views

Exporting Survey Sheets to a registrar in Excel 2003

I would like to create a Survey Template that gets filled out, and when saved, exports to a different folder, under a name based upon entry number. How do I go about doing this?
0
votes
4answers
49 views

Excel - How to add cells that have letters and numbers

For example: A1 - "AA123" How do I get B1 to read "AA124" and C1 to read "AA125"? I know that in A1 I can drag the box to the right and it will populate with this, but I need a formula for this. ...
-1
votes
0answers
19 views

Using Sumif and subtotal with tables in excel

I have the following table in excel A - B amount - type - tag 4 - Debit - nice 5 - Credit - nice 32 - Debit - bad 31 - Credit - bad for calculation of total I used the following formula: ...
0
votes
1answer
22 views

Excel formula counting specific cells

=COUNTIF(B25:M25,"S-1") My question is when a cell contains "S-15", it is being counted as a "S-1". How can I specify "S-1" only?
-1
votes
1answer
38 views

Closest thing to variable in Excel formulas( not VBA)

I have following formula =MID(G34,FIND(" ",G34),FIND(" ",G34,FIND(" ",G34)+1)-FIND(" ",G34)) G34 ="begining middle end" The goal of this formula is to return "middle" and it achieves it, but the ...
0
votes
1answer
31 views

Excel - How to auto-populate from one sheet to another

Here is the scenario. For ease, I will use a Calorie log as my example. Worksheet1 contains all food consumed for an entire day. Worksheet2 is an index of the foods consumed. For example, in ...
0
votes
3answers
42 views

group values in set of 5 and then return the first value from each group

I have a long list of values of a stock in minute format. The column C shows the open values(per minute) and column F shows the corresponding close values Now I want to covert this data into 5 min ...
-1
votes
1answer
32 views

Excel conditional formatting based on time values

Hi i need to create an Excel template like the cells will be loaded with a timestamp like 2014-09-29 16:02:59.112213 I need to provide a condition like, if the timestamp is less than 3 AM, its ...
0
votes
1answer
18 views

Sort one column by another and keep proceeding rows in the same order

So I have this excel spreadsheet that has a few verbs in Spanish as well as their conjugations: Order Infinitive conjugation1 conjugation2 conjugation3 conjugation4 conjugation5 conjugation6 ir ...
1
vote
1answer
26 views

No Startup folder in Microsoft Office for Mac 2011

I'm trying to save a new default worksheet in Excel for Mac 2011. Instructions say to save it in the Startup folder at this location: /Applications/Microsoft Office 2011/Office/Startup/Excel There ...
-1
votes
1answer
15 views

Bingo Board - Methods to interact with (By Highlighting) multiple cells in Excel

What I'm trying to do is make a bingo board that lists the numbers 1 - 75 in one section and either click them, or highlight them manually and then have it review 5 or 6 cards in the same sheet and ...
1
vote
3answers
21 views

prevent excel formatting as number

I have to copy from SQL Server Management Studio often. Many of our ID column fields are filled with numbers but have the data type varchar. When copying output from SSMS to Excel MSOffice determines ...
1
vote
2answers
28 views

numbers on x-axis graph in Microsoft Excel 2007

I have a problem with a graph in Excel. Here is how it looks like The problem is that I need the x-axis to start from 0 to 10 I am using Excel 2007. Basically, what I need is U=f(alpha)
0
votes
2answers
54 views

Is there a way to use Regex( or comparable solution) in Excel formulas?

I have a spreadshet that requires me to do some matching,namely speaking its a list of bonds, their tickers(names) and some data about them. I want to match their tickers(names), I know how would ...
0
votes
1answer
24 views

Adjust sequence position of barcode scanning result

I've been improve our warehouse record method by barcode scanning. But the problem defaut scanning result inside excel format is after scan cursor will move to below cell ( ex : A1 to A2 to A3 etc). ...
-1
votes
2answers
32 views

larget/smallest number in a range in excel without overlap

I have a sheet with 1000 rows and 5 columns. 1) What I want to do is in a cloumn find the biggest number in 5 adjacent row (e.g. row 1-5 in column A). then find the biggest number in next 5 rows (i.e. ...
-1
votes
1answer
19 views

Microsoft Excel 2010 Search for Specific Text and copy it to new cell

I have a list of single words in a column A1:A10. In row A11:G11 I have words which could include a word from the list. If it does it could be the only word or appear together with another word in ...
0
votes
2answers
35 views

Extracting a list of values that appear only once in 2 columns

I have a worksheet with 2 columns of numbers (column A and column B) and I want to populate a 3rd column (column C) with values that only appear ONCE in both columns. That means any value that appears ...
0
votes
0answers
27 views

I need a macro to separate a column of names into 4 different shifts

Our system creates a report for accuracy. Our manager wants it separated by shifts. From those lists, it will go to a report 'by shift' along with the information on the row with each. I need a macro ...
0
votes
1answer
17 views

Excel 2007. Data Tab is grayed out. Nothing on that Tab is available

I'm trying to sort a file to which I add rows daily. I usually have no trouble sorting, but from some reason all the items on the Data Tab are 'grayed out' and unavailable. Any idea what's caused ...
1
vote
1answer
20 views

Use LINEST on filtered data - Excel

I am trying to use the LINEST function and then filter the original data to reflect the subset I am interested in. Unfortunately LINEST always uses all originally defined data. Is there a way to ...
1
vote
1answer
18 views

In Excel, How do I trap a mouse click in a specific cell to activate a macro?

I have a Excel macro that does a simple sort. I want the end-user to be able to click on a specific call and initiate the macro. I need to trap the mouse-click to respond on it.
1
vote
0answers
21 views

Mail merge - Change data in source from merged document

I have an excel file with thousands of records. I want to mail merge and build a directory which I have done. The problem is when directory was built I noticed that there were some errors. I want to ...
0
votes
3answers
19 views

Check range of cells for a string from another cell?

Cell A1 has a string. Cells B1:G6 contain various strings. Cell A2 wants to return "YES" if the string in A1 can be found in the range B1:G6, and "" if it can't. I tried: IF(CELL("contents", ...
-1
votes
0answers
24 views

vba method cells of object _global failed

I have this vba code. In the conditional statement, if the met condition is in env2, the code works fine. however if the condition met is in env1, the code fail with the error run-time error 1004. Why ...
2
votes
1answer
25 views

In Microsoft Excel is there a way to control what part of a cell's data is displayed for cells which have more text that their size

I have a cell in Microsoft Excel with overflowing data. The overflown data is hidden because adjacent cells have some data as well. Is there some way to control what part of the cell's data is ...
1
vote
3answers
68 views

Get max value of (X:Y) while cell below = 1

What I'm trying to do is get the most recent date from a row while the cell below it has a value of 1. I've tried working with MAX and hLOOKUP but neither are doing what I need. Cell A3 to G3 ...
0
votes
1answer
25 views

delimiting text in Excel messes up hyperlinks

I'm trying to paste a table that should never have been done in Word into Excel. Once in excel, there's a column with three separate sets of data that I wish to delimit into three columns. The third ...
0
votes
2answers
25 views

Add 00 before a number to make it match required field

I need to look up a matching employee number that is stored in 8 digits. the cells in XLS sheet vary some employees name have 5, 6 or 7 digits stored only in XLS. how do I pad 00 in front of the ...
1
vote
0answers
30 views

How to find and replace text in embedded excel spreadsheets in word? [closed]

I need to change the values of a series of tables (about 10) embedded in my word doc.
0
votes
1answer
35 views

Editing every cell in an Excel sheet

I have a list of phone numbers in an Excel sheet as well as in Outlook. The sheet only has one column. I need to remove '92' from the beginning of each phone number. e.g. In a cell that contains ...
-1
votes
1answer
22 views

Move the contents of a cell in Excel with keyboard (not cut/paste)?

Is it possible to move the contents of a cell (eg from A1 to B4) in Excel using the keyboard (the arrows) without using cut and paste? Something similar when using the mouse and drag in the edge of a ...
0
votes
2answers
36 views

Using the SUM Function in Excel with N/A values

I am trying to create a formula for the Total cell at the bottom of a column. The problem is that some of the values in the blocks I am adding up are N/A values. (All the values in the blocks are also ...