# Tagged Questions

**1**

vote

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**5**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

902 views

### csv file to phpmyadmin import error

here is the pattern of my csv file
--------------------------------------------------------------
| col1 | col2 | | col4 | |
...

**0**

votes

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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 ...