**0**

votes

**1**answer

2k views

### Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...

**1**

vote

**1**answer

567 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**0**

votes

**1**answer

400 views

### How can I have only inner cell spacing? (Remove outer cell spacing)

I have a table in Word 2013 with 0.45cm cell spacing applied to the table:
For the purposes of this question, I've turned on some extra borders:
How can I remove the "outer" spacing, and just ...

**1**

vote

**1**answer

554 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 Plan'!...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

563 views

### How can I protect and hide the data in a single excel cell using password?

My professor want me to send out an excel sheet which contains grades of all students.
And of course every student can only see his own grade. So he want me to set passwords for the grade cells. Each ...

**1**

vote

**1**answer

681 views

### Excel 2010 VBA only affecting last row in range

I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code:
Private Sub ...

**0**

votes

**1**answer

261 views

### How to have excel paste a value in a specific cell according to another data table

I'm working with excel 2010,
I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.
The numeric ...

**0**

votes

**1**answer

19k views

### Excel vba code for adding a value to existing cell of sheet

i have this code to add value of a cell to existing value of other cell which is below
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not (Intersect(Target, Range("E3")) Is Nothing) ...

**0**

votes

**1**answer

3k views

### Updating another Excel spreadsheet from current spreadsheet

I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...

**0**

votes

**1**answer

2k views

### Formula to display text from multiple cells from one sheet in another

I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...

**1**

vote

**3**answers

79k views

### VBA code to hide or unhide rows based on a cell value

Heres my code, but its not really doing anything, I dont see anything wrong with it:
Private Sub PG1(ByVal Target As Range)
If .Range("E50").Value = "Passed" Then
Rows("51").EntireRow....

**0**

votes

**3**answers

397 views

### Excel - Referring to a certain cell based off of data in another

I have a spreadsheet where there is one table with the headings:
Coordinate, Lat, Long
Another with headings
Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area
What this is for, is taking ...

**0**

votes

**1**answer

34 views

### Delete only lateral edge in MS-excel?

Is it possible to delete only the lateral edges in a excel matrix?
In the attacched image you can see tha matrix and you can notice that is almost impossible to delete left/right formatted edges ...

**2**

votes

**3**answers

128 views

### Adjacent cells replicate format of previous cell

I have a basic spreadsheet set up to monitor my outgoings. When something clears my account I color the relevant cell in so I know its accounted for. However since I upgraded my Office, whenever I ...

**1**

vote

**1**answer

4k views

### How to bulk replace links that are embed to words in Excel cells

I have a huge list of words that have links. All the URLs have text that repeats. I want to mass replace this text with another. Right now, "Replace all" only searches between words, not through the ...

**0**

votes

**1**answer

51 views

### I've deleted some cells and cleared everything out and it keeps reverting back to DATE format

I've never changed formatting to date: I always keep it in General unless I need to make it different.
Since my last Update, everything now changes to date when I either copy, paste, or when I ...

**0**

votes

**1**answer

808 views

### Excel - compare names in two cells in different order

I need to compare the following
Cell 1 John Peter henderson
Cell 2 peter John Henderson
Result Match
Cell 1 Anne jolie ...

**0**

votes

**1**answer

41 views

### Display time difference - Formatting

I have a table of times and a formula that works out the difference between the times but having some difficulties formatting the output.
For example I would like:
# Time Gap
1 23:55....

**0**

votes

**2**answers

830 views

### VLOOKUP when VLookup Value is a cell populated via another formula

I keep getting a return of NA when trying to accomplish the following:
formula:
=vlookup(left(Q2,3),A2:C20,3,false)
Definitions:
Q2 is a cell that is populated from a formula. Its calculated value ...

**0**

votes

**1**answer

1k views

### excel 2010 how to identify if a word is present in a group of cells or a row [duplicate]

I would like to use a formula to identify if a cell in a group of cell contains a specific word. Example, I'd like to search if a cell has the content X The formula's response could be 1 if found, 0 ...

**0**

votes

**2**answers

79k views

### How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...

**1**

vote

**2**answers

13k views

### Excel: if duplicate cell value found in another column then highlight green

Can someone help me, I'm not sure what formula to use.
I have highlighted the cell in the picture to show an example of what I mean.
What I want to do is highlight the cell in column A where the ...

**1**

vote

**1**answer

41 views

### MS Excel: custom money format

Need to represent decimal number as "## hrn. ## kop.".
Example:
1.2 => 1 hrn. 20 kop.
3 => 3 hrn. 00 kop.
I've created custom cell format:
0," hrn. "#0" kop."
Result is:
1.2 => 1, hrn. ...

**0**

votes

**6**answers

42k views

### How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...

**0**

votes

**1**answer

752 views

### Excel: Select all that are not in a set of values (and delete)

I have a list of zip codes, but only a handful of them are needed.
In Excel, how do you select all rows which do not meet (or inversely meet) a set of criteria?

**0**

votes

**1**answer

60 views

### Formating my Excel Cell Formulas

What formula can I format my cells to so that when I input a number it will have a u after it (I have it set to ###,###u now) and if it is blank it will have "N/A" in the cell? Thank you in advance.

**0**

votes

**2**answers

90 views

### Changing the format of cells

I have an Excel worksheet where one of the cells has the string "\xab\xcd\xef" etc. It seems as if Excel is taking this as the ASCII string "\xab\xcd\xef". How do I make Excel treat it as a binary ...

**1**

vote

**1**answer

882 views

### Call on a cell in Excel up to the first semi-colon

I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?

**0**

votes

**1**answer

151 views

### I need to know how to swap the contents of two adjacent cells in Excel based on the content of a third cell

I am trying to swap the content between two cells in Excel based on the content of a third cell. So, I have a column in Excel - say Column C. I want to swap the values of the corresponding cells in ...

**1**

vote

**1**answer

500 views

### Make Excel Row Height Stay when Sorted

I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature.
These cells are colored differently, but the height doesn't stick with the ...

**0**

votes

**1**answer

1k views

### Adding Subsequent Cell Values For Each Row in Excel

I'm new to excel so this might be a simple question. I have around 100 rows with 7 columns. Out of those, 4 column needs to have the value computed by 3rd and 2nd columns' value of the same row.
I ...

**0**

votes

**1**answer

163 views

### Can I get the properties of the color of a Microsoft Excel cell in numbers/text?

I want to count the yellow, red and white (no color) cells in a column (range) within a Microsoft Excell sheet.
The colors are equal (i.e. only one RGB value of yellow is used, not light/dark yellow ...

**1**

vote

**1**answer

875 views

### cell array of strings to matlab structure

I need to create a matlab structure as such ds=struct('name',{{'my_name_is'},{'matlab_thining_hair'}}) which stores as a 1x2 structure array with a field name. A call to ds.name generates the output:
...

**0**

votes

**2**answers

697 views

### I need to arrange my data cells in excel in a way that rows are rearranged as shown

1 2 3 4 5 6 7 8 9 10
(this is my initial data)
my output
1 2 3 4 5
6 7 8 9 10
is there anyway i can do this? i have around 400 rows of similar data
many thanks

**2**

votes

**1**answer

5k views

### How to check if cell contains a value of another cell

Here is the scenario:
On column A each cell has random text within it (names, address, account numbers, etc). Column A extends down to over 40 thousand rows.
On column B I have a list of (account) ...

**9**

votes

**1**answer

79k views

### Make some cells in an Excel sheet password protected?

I have an Excel 2010 file that I do not want to have a password for, but I do want to lock certain cells so that I do not accidentally edit them.
Can certain cells be made read-only without a ...

**0**

votes

**1**answer

86 views

### Excel Formula For Re-arranging Numbers

I have got a bit stuck with trying to make a formula in Excel, and last time I asked a question here I got great help, I have come back again. At the moment I have column A with sets of product id's. ...

**0**

votes

**1**answer

45 views

### Printing data in Excel ver 14.0 in a maxed cell

I have set the cell to the maximum size (column width of 255 and row height of 409.5). In order to view all of the data in the cell, I have to use up/down arrows. I don't need to necessarily view all ...

**0**

votes

**1**answer

1k views

### Excel - Mirror Specific Cell Range

Is it possible to mirror or replicate a cell range from one worksheet to another?
For example:
----------------------------------------------
| CELL01 | CELL02 | CELL03 | CELL04 | CELL05 |
----------...

**1**

vote

**7**answers

28k views

### Microsoft Excel 2007 - Cannot Fit All Text Into Cell

Is it possible to fit a large amount of text within a cell in Excel 2007?
I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I ...

**2**

votes

**3**answers

25k views

### Add drop down list / combo box into excel cell

How would I add a drop down list (or combo box) into a cell on Excel 2010?

**3**

votes

**2**answers

174 views

### Can I insert rows next to a locked column in Excel?

If I lock cells A1:A3000, is there a way to insert rows in columns B-Z?
I highlight them and I don't get the option to insert even though it is selected in the lock options. (Bottom line is that I ...

**1**

vote

**1**answer

283 views

### Delete cell content in Libre (Open) Office based on the cell value

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but ...

**1**

vote

**4**answers

4k views

### Create a hyperlink from URL and title in Excel

I'm trying to construct a hyperlink from a URL and a name in different cells.
a1 = http://www.example.com/
b1 = example
c1 = <a href="http://www.example.com/">example</a>
What I want ...

**1**

vote

**2**answers

190 views

### How to keep Excel from using absolute addresses when clicking a cell while in a “range selection” window?

In any version of Excel (since 2000, at least), you can enter = into a cell to indicate that a formula is about to be entered and then click cell A1 so that the formula says =A1. This is a relative ...

**0**

votes

**1**answer

6k views

### Excel - Displaying a value in a cell dependent on another cell having text

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport ...

**1**

vote

**3**answers

13k views

### Remove data from a cell in Excel

I want to remove data from multiple cells in a spreadsheet using Excel 2010, so I only have the email address left.
They are in the current format:
M: 04545 545 545 e: test@email.com h: 01187 475 ...

**0**

votes

**3**answers

6k views

### Sum only if any one of six cells have a value

I would like a cell (total) to sum 6 other cells only if one of those 6 cells have a value. If none of the six have a value i do not want anything to appear.

**22**

votes

**5**answers

16k views

### How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?

I've imported a CSV file having the first column to be date-time values in ISO 8601 format like
2012-01-01T00:00:00.000Z
for the first moment of the year 2012.
Then, willing to make ...