A cell is generally a reference to one point of data in a spreadsheet program. Every data point is within a cell and cells are then grouped into rows, columns or even ranges.

learn more… | top users | synonyms (1)

1
vote
1answer
29 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 ...
-2
votes
0answers
30 views

Search entire row for specific number and if found copy data from adjacent cell to the right

I can use Microsoft Excel or OpenOffice. I have one row of cells with 20 columns. I want to write down formula that searches entire row for number 38 (match case). If found, copy the data from ...
-2
votes
0answers
53 views

Trying to change a range of numbers to discrete numbers

I have a sequence such as 1002-1015 in Excel 2007, and I want to change it to 1002;1003;1004;etc.;1015. It is the generation of numbers between that has me stumped. What if I have 100 or 1000 ...
0
votes
1answer
28 views

Excel reformatted numbers to times

I have a spreadsheet stored on a company sharepoint site. Only one person in my team will use it at any time, when they're finished it saves and is available to another user. Periodically when someone ...
0
votes
1answer
44 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
1answer
54 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 ...
0
votes
1answer
39 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
1answer
75 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
1answer
182 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
1answer
44 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
1answer
2k 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
2answers
273 views

How to format excel cells that show duration in years and months?

I can't figure out how to do custom formating that would format input "1/5" as "1 year, 5 months", or "5,0" as "5 years". I do want the cell to retain original input of "1/5" but visually display "1 ...
0
votes
1answer
47 views

Excel: How can I copy cell contents from multiple sheets at once?

I would like to select cells in each sheet in my workbook and then copy them all at once, is that possible? Or even better, if I could mark those cells (group perhaps) so that I could get the SUM of ...
0
votes
1answer
246 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
1answer
53 views

How do i change value in filtered cells?

Please could someone help me? I have a spreadsheet full of different vacancies and they go in order of the date advertised but have different departments within that and I need them numbered. I only ...
0
votes
1answer
171 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, ...
0
votes
2answers
105 views

Excel function for calculating total spent time

I have an excel sheet, where in some columns I have cells of the type "integer,integerM" or "integer,integerH", for instance "1,30m" or "5,2H". For all the column I would like to get an expression ...
0
votes
1answer
8k 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 ...
0
votes
3answers
72 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
1answer
20 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 ...
0
votes
0answers
57 views

Hold cell spacing when copy/paste

I need to copy only certain cells, example. A1, D1, G1, J1, M1 To: A6, D6, G6, J6, M6 or H6, K6, N6, etc (Notice the equal spacing between the cells to copy and where to paste.) But when i paste ...
0
votes
0answers
27 views

How to use the Integer i.e. currentregion's row from the macro in a cell's formula

How do I use the row from the current cell, in another Cell's Formula on another sheet? I created this Macro, but don't know how to use the Integer from the macro in a cell's formula. In a macro I ...
2
votes
3answers
50 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 ...
0
votes
1answer
437 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 ...
3
votes
2answers
68 views

Excel 2010: Find duplicate entries in one cell

I have data imported from a literature database (.txt format) into Excel. Unfortunately, in most cases, the authors are listed double in one cell, e.g.: "Smith, Miller, Patty, Smith, Patty, Miller" ...
0
votes
1answer
41 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
0answers
60 views

How do I change default decimal places when opening dbf files in excel?

When I open dbf files in excel the numeric fields are automatically displayed with 4 decimal places. This is not the default number of decimal places for an excel numeric field, so changing my Normal ...
0
votes
1answer
356 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
0answers
44 views

Format issue with dates over the 13 in excel

I have the following problem. I'm not able to modify all dates older than the day 13. For example: With the date 07/01/2013 11:20:00 I am able to change the format. To 07/01/2013 11:20 a.m. But with ...
0
votes
1answer
28 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 ...
0
votes
2answers
373 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
1answer
341 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
2answers
16k 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
2answers
3k 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
1answer
28 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
3answers
4k 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
1answer
157 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
1answer
54 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
2answers
81 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
1answer
180 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
1answer
109 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
1answer
158 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 ...
4
votes
1answer
2k views

How do I copy the results of a calculation without copying the formula behind it? Open Office Calc

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
0
votes
1answer
369 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
1answer
91 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 ...
0
votes
1answer
284 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
2answers
229 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
1answer
2k 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) ...
4
votes
1answer
23k views

Make some cells in an Excel sheet read-only?

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
1answer
71 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. ...