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
vote
1answer
107 views

Dragging a cell reference in intervals

I have data as follows (simplified) in two worksheets on a document: Sheet 1 data: A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3 ... Sheet 2 data: A1='Stage ...
1
vote
3answers
39 views

Hiding an Excel formula untill the fields before are completed

I'm going crazy here trying to sort the below out. I am trying to hide the "0" (J9) and the "Yes" (K9) until the dates have been filled in The Formula in J9 is =DATEDIF(H13,I13,"d") The Formula in ...
0
votes
1answer
5k views

hide/unhide rows based on cell value [duplicate]

Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my ...
0
votes
0answers
130 views

Excel: Finding comma delimited values in reference range

I have a two-sheet excel file in which I want to see if specific values are present in some column, based on comma separated values in some other cell. The idealized case would be: Sheet1: Cell A1 ...
0
votes
0answers
34 views

Is there a way or code that will pull data from Excel and place it in specific order on powerpoint presentation? [duplicate]

I'm going crazy trying to figure this out, there has to be an easier way. I will try to explain as best as possible: I am preparing a powerpoint presentation for a trial, it will contain aprox. ...
2
votes
1answer
175 views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...
2
votes
5answers
112 views

Sum over every second cell if neighboring cell is not empty

I have created a timesheet in Excel to keep track of my working times. It all works pretty good, but I have one small problem. My sheet has the following layout (In=started working, Out=stopped ...
0
votes
0answers
54 views

How to handle large excel sheet as csv with Chinese characters?

Excel is having issues dealing with Chinese characters saved as a CSV file. I am trying to use the file in a content analysis program, but cannot open the file and view with correct characters (the ...
1
vote
0answers
142 views

In Visio 2013, how do I apply various styles to a timeline element based on a linked data value?

I am building a timeline in Visio 2013 using linked data from Excel. It took me forever to figure out that I needed to add the names "Task Name" and "Start" to automatically populate milestones on ...
-1
votes
2answers
231 views

Spreadsheet for Daily Equipment Hours

My goal on this is to keep track of equipment hours and have a daily report to reflect total hours and run time. I want to make a file with 31 days of worksheets in the workbook for the complete ...
0
votes
1answer
2k views

Call PowerShell script from Excel macro

I'm trying to call a PowerShell script from a macro in Excel. I have seen a number of examples along the lines of: retval = Shell("powershell ""C:\MyTest.ps1""", 1) When I try to use this, ...
2
votes
3answers
1k views

How can I change the number format of a cell in a database-imported table?

I have a sheet that looks like this - A | B | C ---------------------- 2 | Okay | 0 3 | Not okay | 0 Cell C3 has the green error pointer and says "The number in ...
0
votes
2answers
119 views

Excel countifs criteria neither this nor that

Im trying to make a criteria for COUNTIFS such that the value of the cell is neither "pass" nor "fail" nor blank. How can I do this? I dont think "<>pass<>fail<>*" works Since someone wanted ...
0
votes
1answer
108 views

Excel count all rows that contain certain values for certain fields

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of ...
1
vote
1answer
88 views

Excel Scatter Diagram

I have data in Excel as follows (just example of them, not all): Name | Asset | Count ----------------------------- John | Apple | 1 Adam | Banana | 2 Pete | Apple | 1 Mark | Berry ...
0
votes
0answers
50 views

Printing 24 labels per page from Excel

I'm trying to print 24 labels per page in Word using Excel list. First page is fine, but when it moves to next page only difference is that second record from first page becomes first record on ...
1
vote
1answer
89 views

How to default into edit mode instead of insert mode when entering content into a cell?

When I directly start to type content into a cell, Excel is in Input Mode, which means I could easily reference cells in formulas. Unfortunately most of the time I do not enter formulas, but simple ...
0
votes
1answer
49 views

Summing of adjacent cells in a single column that are <>0

I have a list of numbers (8780 values in one column -- a sample is posted below) some of them are <> 0 and some of them are 0. List of numbers: 0 0 0 0 0,127227198 0 0 ...
3
votes
2answers
382 views

Setting default editor language in word 2007

I want to change my default editing language in word as English (India). It is not so possible to change the language setting in all users and all PCs manually. Manually we can change the default ...
0
votes
1answer
20 views

How do I prevent users from adding new tables in Excel?

I have a excel file where clients are allowed to write in some columns. All other columns are not visible and blocked, so they won't write any more than is expected from them. BUT, they create new ...
-1
votes
3answers
52 views

How to delete columns from Excel

Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 123 3 43 567 53 3 111 123 2 3 9 0 8 8 3 2 3 98 I have 5 columns ...
-1
votes
1answer
38 views

How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart: I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...
0
votes
1answer
53 views

Swapping two characters in a word with Excel

I'm trying to think of the function I would use to grab a character x amount of spaces from the left or right side of a string. Let's say a cell has the word superuser in it. I need a formula in ...
0
votes
0answers
126 views

Excel, Compare columns values between 2 sheets and if any match update data if one

I 've found many useful info at the past from the forum, but now i trully need a hand. So, my issue is: i have 2 sheets containing some common columns, lets say Product Name, ID#, Price etc. How to ...
0
votes
2answers
58 views

How to put conditional formatting in a cell from another excel worksheet [closed]

It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this: Worksheet= Dr. castro patient consultations A B C D E ...
0
votes
0answers
65 views

“Filter by Selected Cell's Color” is so slow

I have a row includes like 60-70 thousand lines. 30.000 of them colored. And I'm trying to filter them by "Filter by Selected Cell's Color" but it's so slow. It take forever to filter just 70.000 ...
0
votes
1answer
167 views

Excel dates - how much of a period falls in a financial year

I have a quick question that probably seems obvious - maybe I'm conceptualising the problem in the wrong way, so thought I'd get some outside help. I need a way to determine how much of a given ...
0
votes
1answer
65 views

How to CONCATENATE with variable rows

Sorry in advance if I don't explain this very well, definite newbie here when it comes to spreadsheets. I have a Text only spreadsheet with 4 columns, first 3 are Student's Last name, First name, and ...
-1
votes
1answer
58 views

How do I reference a cell in an Excel data table without using the cell coordinates?

I do a summation on the values of a set of cells in an Excel data table. The problem is when I sort the table, the values in those cells change (because the records get sorted) and this changes the ...
0
votes
1answer
49 views

How to create drop down column OR filters

I have a worksheet (in Excel 2003) that has a number of cross-reference cells, for example: 1 Red|Green|Blue|Yellow|Any|Information 2 X | | | | |.... 3 X | | | | X ...
0
votes
3answers
36 views

What can an Excel table do?

I don't really understand why I should use an Excel table. It seems all the functionality that a typical Excel worksheet provides is duplicated by an Excel table. The only difference I can see is that ...
1
vote
1answer
42 views

What's the best way to merge 2 tables keeping 1 column aligned?

What's the best way to merge 2 tables keeping 1 column aligned? Example: I have these 2 tables from which I want to make table 3: TABLE1 color name1 red apple orange orange yellow banana ...
0
votes
1answer
57 views

Method to Consolidate Cell Contents from Two Excel Files into One Excel File

I translated an Excel file in Chinese into English with OmegaT, a CAT (Computer-Aided Translation) tool, and a pure English file was generate by OmegaT. However, the customer wants me to submit an ...
0
votes
1answer
214 views

Can Excel's Find formula have multiple find_text criteria?

I have a list of names on a NAMES tab range A1:A100. On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...
0
votes
0answers
212 views

Trying to lock down cells in excel & office 365

We have only sharepoint, office 365, excel 2013 - no domain. I'm trying to lock down specific columns in an excel sheet. When I click on 'Permissions' in 'Allow users to Edit Ranges' I type in a ...
0
votes
1answer
70 views

Apply a function/formula to a range in excel

I have many operations to perform on a set of data in excel. The data is in columns, and the functions are a lot of variations on things like =(A1*C1/B1)+(A2*C2/B2)+... Right now they are spelled ...
0
votes
2answers
202 views

Using IF and ISBLANK statement to determine a range of cells if any of them have information in them

I have a formula where I am checking for a range of cells whether or not they are blank. If all of them are blank I want to return another blank. If any of the cells in the range are not blank, I ...
0
votes
2answers
64 views

vlookup with blank look up value

I have a Vlookup running and I want it to return 0 if the look up value is empty. example: =(VLOOKUP(A6,F:G,2,0)+1)*C6 +-------+--------+-------+-----------+-------+-------+ | | | ...
0
votes
0answers
38 views

How to view my Excel sheet normally without grouping but keep the grouping configuration?

In Excel we can group rows by going to Menu - Data - Group - select Group by Rows for the selected cells e.g. one demo here. After we do that, the left column changed as below snapshot where we have ...
0
votes
1answer
3k views

merge and combine in excel

I have two sheets in excel, in both of them, I have a column a as ID but ID in both sheets are not the same. both of them have some ID number that does not exist in another. there are several column ...
1
vote
2answers
75 views

How to specify a pattern for autofilling cells in excel?

I am trying to do some unusual autofill in excel. I want to autofill downward like in the following: =B5 &CHAR(10) &B6 =B7 &CHAR(10) &B8 =B9 &CHAR(10) &B10 But excel ...
0
votes
1answer
93 views

How to combine several excel workbooks into a single book

I have several, multi-sheet workbooks which I would like to combine so that I can search them all simultaneously. So, the merged workbook will contain tabs 1,2,3, of the first workbook, then tabs ...
0
votes
1answer
27 views

How to create formula in excel that can iterate in specific range?

I want to fill down 10 cells with value from B10 cell: ='Disconnect Minor Reason List'!$B$10, then I want to get another 10 cells with value from B11 cell, then another 10 from B12 and so on. Is it a ...
-2
votes
2answers
38 views

How to write a macro in exel?

I need to cut the contents of the cell, to write a quotation mark, paste the contents of the cell to write another quotation mark then move to the next cell. Or anything else with the same result.
1
vote
1answer
77 views

MS Excel - is it possible to change from writeable to read-only?

I have a question if it is possible while using MS Excel spreadsheet to change how it's open from writeable to read-only without closing it? I am working on the network file and sometimes when ...
0
votes
2answers
902 views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
0
votes
1answer
666 views

Indirect function for worksheet names in Excel?

I am wondering if there is an equivalent to the indirect function for worksheets or workbooks instead of cells. What I mean by that is I am updating a rather large and unwieldy workbook for payroll ...
0
votes
2answers
895 views

Excel - column width differences in copied worksheet

I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open ...
0
votes
1answer
76 views

Can't compare a cell to a column in excel

I'm trying to compare a column to a cell in excel several times. The columns are copy pasted from a PDF (only way to get the information). The results are bad, with trailing spaces, some completely ...
2
votes
1answer
578 views

Reversing Excel's Text Import Wizard for CSV Export

I have a CSV file that I want to import to excel, edit, and save back as CSV. The problem that I encounter is with Text Import Wizard: I open a new Excel file, then Data > From Text, and in The text ...