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)

-1
votes
0answers
20 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
23 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
42 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
35 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
44 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
38 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
30 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
17 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
22 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
30 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
55 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
28 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
35 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
23 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
20 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
26 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
20 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
30 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
79 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
28 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
31 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
36 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
24 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
39 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 ...
1
vote
1answer
86 views

Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010

I have two data sets each containing 10 coloumns of data. X values in data set 1 go from 380 - 750 in steps of 5 X values in data set 2 go from 250 - 2500 in steps of 1 Data set 1 is permanent and ...
-1
votes
0answers
36 views

In need of a formula in excel to pick a day based on it's availability. [on hold]

So what I have is a spreadsheet that ranks a group of technicians from 1 to 23. And I have a list of available days off and a list of techs and there preferences for those days off. What I want is a ...
0
votes
1answer
43 views

Compare two excel files

I need to compare two Excel Spreadsheets to see if values of each user in a specific column were changed. The new Spreadsheet may have additional users that were added making the row old users ...
0
votes
1answer
19 views

Excel conditional formatting only applies to first cell

In excel 2010 I have a row of content for which I want to define a conditional formatting. So I select the row, say from B3 to K3, and setup a new rule as follows: Use a formula to determine wihc ...
0
votes
0answers
17 views

excel protected sheet keeps crashing in windows 8

An excel file was created in 2007 version ( .xlsx) in Windows XP. A new PC with Windows 8 was installed and all old files and folders were transferred. The folder is shared in the network so that ...
2
votes
2answers
66 views

A blank cell not registering as zero in excel

I am running a complex IF equation in Excel 2003 (yes, the computers at work are that old too) and it is important to the equation that blank cells are valued at zero, which is, I understand, how ...
-3
votes
0answers
61 views

I want to compare two different columns and get a value from another workbook using VLOOKUP

I want a value from the workbook(2) by comparing two different columns from workbook(1) using VLOOKUP. I want a VLOOKUP coding like, if WorkBook(1)columns A matches with workbook(2) columns A then it ...
-2
votes
1answer
53 views

Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...
0
votes
1answer
27 views

Massive number of obsolete defined names in Excel = huge file

At my current job I discovered that many Excel files were unnecessarily large, a file with a single worksheet and simple table can be more than 2 MB and Excel seems to be very sluggish at times. After ...
-1
votes
1answer
25 views

How to specify a month in cell A1 and have all the dates that fall in that month appear automatically in row B?

I have a question about Excel. I am using Excel 2010 and I want to be able to create a table that will auto populate the dates within the month that is specified in cell eg A1 into a row in B for ...
1
vote
1answer
29 views

Excel 2007 formula to find out date from year and week number?

I'm trying to make my work hour notekeeping a bit easier. I note my hours by project so that Monday - Friday are in their own columns. I report my hours based on this weekly, so each worksheet has one ...
1
vote
1answer
11 views

Graph Excel data based on 2 groupings

How would I use excel to graph based on 2 different segmentations? For example, consider the data: Time Group Col1 Col2 1pm A 15 20 1pm B 20 30 2pm A 10 ...
0
votes
2answers
56 views

Sync Google Form Spreadsheet with MS Excel

Is there some way to pull the responses from a Google form that is on a Google Spreadsheets into MS Excel?
-1
votes
1answer
33 views

Excel Average by excluding top and bottom 5 values

Trying to get the average by looking up a text and excluding the top and bottom 5 dates based on worst and best values. I am currently using this formula which gets me the all but excluding the top ...
0
votes
0answers
23 views

How can I check that a filter applied to a listobject column with vba is legal?

Filtering a listobject(excel table) with a value that doesn't exit results all rows instead of none can I get no rows? can I get list of optional legal parameters? example listobject with col A ...
0
votes
1answer
32 views

Why Excel autofills only from T1 to T4?

I have the text T1 in a cell. If I select it and drag the fill handle over multiple rows, then it fills in T2, T3, T4, and then resets back to T1, T2 and so on. With other text like A1, W1, or Q1, it ...
0
votes
1answer
53 views

How to reformulate Excel formula with too many levels of nesting

I need to be able to use the following formula in Excel to choose a formula used on a different sheet based on the values in drop-down menus in cells D2 and D3. The only problem is that the formula ...
-1
votes
1answer
15 views

How can I extract total time used by an employee from a record mainted in a different tab

How can I add the time used by an employee for different taks and keep track for the total time used in a particular week? Staff will flight out a few times per week with each flight date and time ...
-1
votes
1answer
15 views

How can I merge contents of 2 cells into 1 and shift the remaining columns in Excel?

I'm trying to merge cells in excel that are in the same row into 1 cell and then shift the remaining cells to the left. Example: Content | Sample | More | More2 So I want to merge "Content" ...