# Questions tagged [cells]

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.

**0**

votes

**0**answers

9 views

### Geocoding API - CellId + MCC + MNC + LAC ERROR 400 [closed]

I am working with Geolocation API, I've got a key, it seems to work getting location, getting inverse location (Address).
Now I need to work with Cellular Cells, I have the MCC, MNC, LAC and CELLID. ...

**0**

votes

**1**answer

25 views

### How do I get a cell to dynamically move and update?

I have a workbook that has multiple sheets. The content that gets entered into a sheet changes monthly. For instance, sometimes I will have 5 entries, and sometimes I will have 400 enteries in a sheet....

**-1**

votes

**0**answers

18 views

### Excel Cell Mandate on the basis of another cell

I would like to mandate a comment in column D, if user selects a value of 1 (out of a drop down list of 1,2,3) in column C. For example, if the user selects 1 in column C5, then the user must not be ...

**0**

votes

**0**answers

22 views

### Case sensitive formula in excel

I’ve been playing with this formula because I couldn’t get the original syntax to work and it’s nearly doing what I would like. Please can you help me make it case insensitive?
Here is the data and ...

**0**

votes

**1**answer

31 views

### Match 2 sets of numbers in 2 cells

I have 2 cells with similar data extracted from 2 different websites. Data in D6 is supposedly shorter version of H6. I want to put "Match" or "No Match" in E6. For "Match" either 2 sets of numbers ...

**1**

vote

**2**answers

41 views

### Sum cells based on the value of other cell

I am facing a problem that seems trivial in Excel. What I need to do is simply this:
In short, I have a large file of prices linked to a few people and I need to know how much each person paid. I've ...

**0**

votes

**0**answers

29 views

### Link two tables in MS Word doc

I have a Microsoft Word document that has two somewhat redundant tables, let's say tab1 and tab2 (these tables are disjoint, in different parts of the document and have the same number of rows).
I ...

**0**

votes

**1**answer

26 views

### Not using a cell as variable, whilst inserting a (excel-)formula in several cells

I'm facing a small, basic little problem, for which I can't find the solution:
I'd like to insert the same formula in several cells at once. Quickly googling this problem provides a solution:
Either ...

**0**

votes

**2**answers

48 views

### How to step up cell reference in function by numeric values based on known number of rows

This is in reference to the formula I need for cell F2 in the below image.
F2 shows the result I WANT:
I NEED: The Concat Formula to concatenate the data in Column B for each variant of whatever is ...

**0**

votes

**2**answers

58 views

### How to move partial text from one cell to another

I have a dilemma I am hoping someone might be able to help me with!
I have exported a PDF file into excel that has a lot of information that populates into one cell. I need to split this information ...

**0**

votes

**1**answer

19 views

### Windows 10 Excel

Creating a CRM with different info from Sheet 2 and 3 but need the name, phone, address to auto populate from sheet 1. I've tried =vlookup, =text, =index. Confused on what function to use. All vids I ...

**0**

votes

**1**answer

43 views

### How do I create a ''droplet'' script in Win7 that runs a Notepad++ task on a CSV file

I have recently asked a question on how to perform a neat little 'Find & Replace' task on my CSV media database files (a task i have to do at work on a daily basis). The question was answered here ...

**1**

vote

**2**answers

51 views

### How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?

I have to download media file databases on a daily basis and modify metadata from a csv file so that the unique numerical prefix in column B is added as a suffix to the cells in column C.
Is there a ...

**0**

votes

**1**answer

26 views

### Two related cells

In A1 I have price, for example 1000. In A2 fill percentage, for example 10%. Then in B2, calculate A1*A2 = value. I would like when i fill percentage in A2, in B2 calculate value and vice versa - If ...

**0**

votes

**1**answer

33 views

### Looking for the same value in two cells

=IF((JANUARY!D6=K3),JANUARY!B6,"")
This is the formula I'm using to try and pull information from the January tab, and place additional information on a different tab. This formula works, however, I ...

**3**

votes

**0**answers

72 views

### In LibreOffice Calc, how can I change the cell selection black ring to something lighter for dark backgrounds?

In LibreOffice Calc, how can I change the cell selection black ring to something lighter so it can be easier to see for dark backgrounds? I will attach an image to show what I mean. It would be nice ...

**1**

vote

**2**answers

71 views

### Robust linking of cells Excel

Is there a way to link cells so that not only content updates automatically, but also format (fill, border, font, etc.)?
Also, is there a way, other than doing each cell individually, to avoid blank ...

**0**

votes

**2**answers

189 views

### Increment number with letter in cell

I have a column of random numbers that all begin with 'B*****' where the stars are numbers.
I need a formula to add 1 (+1) to the cell on the right of the number and take away 1 (-1) to the left of ...

**1**

vote

**1**answer

70 views

### How to copy in Excel 2016 a cell with hyperlink from one sheet to another using formula?

I am automating an excel based report and need a formula that will take cell A2 with its hyperlink from Sheet2 and copy it to another column in Sheet 1. Hyperlink points to external web address. When ...

**0**

votes

**2**answers

2k views

### Limit Excel cell entry to a certain number of digits

How can one fix the number of digits entered in a cell. For instance, I want only 9 digits to be entered in a cell and if it's more or less it should be flagged or not accepted. I want to make sure ...

**1**

vote

**0**answers

49 views

### Cell reference in formula

I have the following formula in A2 of my worksheet:
=SUMPRODUCT((SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$2,'[Master.xlsx]Composite Assets'!L:L)*(SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$1,...

**0**

votes

**1**answer

114 views

### Libre Office Writer crashes when merging table cells

This time I know for sure: I created a new document, a table, added some data in the table cells, but I want to merge 2 cells on a column.
I can merge 2 cells on a column, but if I want to merge the ...

**0**

votes

**1**answer

65 views

### In Excel, can I create a name that refers to cells that aren't tied to one worksheet?

This isn't a question about the scope of names. It's a question about specifying the cells in a name.
Imagine I've created a name =A1+B2.
That gets hard-coded by Excel into Sheet1!A1+Sheet1!B2. But ...

**0**

votes

**1**answer

59 views

### Excel: Data across multiple columns and rows

Currently have a table like this:
How can I consolidate and count the hours per person spent on each day. Need to be on seperate lines due to working on different tasks but want to bring in all ...

**3**

votes

**0**answers

86 views

### Formulas Changed to Reference Last Row When I Close and Open Excel File

I have no idea what is causing this issue, but when I reopen an Excel file, formulas that reference cells will change the reference cells at the very end of the sheet.
Example:
Super simple spread ...

**0**

votes

**1**answer

42 views

### Excel deletes cell content of cells I try to edit in a protected work sheet

I have "inherited" an excel workbook I need to fix and the original creator has - of course - gone years before I received the task that I have to fix this file.
The sheets of the file are all ...

**0**

votes

**3**answers

793 views

### Excel inconsistently changing the format of DATE cells

Column 1 = What I entered in cell.
Column 2 = What formula bar shows when cell is selected.
Column 3 = What cell shows when cell is not selected.
1 | 2 | 3
-----------------------...

**0**

votes

**1**answer

50 views

### How can I use the same filter in Excel (for Mac) twice on the same sheet?

I am working with a basic filter in an Excel sheet that I have on page layout. Both pages will have to have the exact same filter (it's separate as one page serves as a purchase order and the ...

**0**

votes

**1**answer

779 views

### Excel - Find duplicate values in two rows with two conditions

Could someone guide me to find the correct formula for this case of conditional formatting in Excel?
1- Highlight the two adjacent cells in orange only if their values are the same on the same line
...

**0**

votes

**0**answers

51 views

### LibreOffice Calc: when copying an empty cell, it turns into a zero?

In a LibreOffice spreadsheet, when I want to duplicate a cell's content, I use =<source coords>. For example if I want cell A2 to contain a duplicate of whatever is in A1, I fill in =A1 in A2.
...

**0**

votes

**1**answer

52 views

### Excel that allows you to select a cell and go to the corresponding sheet name

I have the following code for selecting a cell with a specific name and the going to the sheet that is names after that cell.
Dim ws As Worksheet
If Target.Address = "$A$1" Then
For Each ws In ...

**-1**

votes

**1**answer

1k views

### How to link cells from access to excel?

I have a database in MS Access and I need to link some cell in MS Excel.
I need to link only few cells from a huge table that I update automatically.
Maybe it is easy but I know how to import table ...

**0**

votes

**1**answer

122 views

### Image Hyperlink to WWW using local cell referencing

The scenario:
Manual input data in local excel file. I then click an adjacent image to run a preset hyperlink, to a specific web page, with part data captured from a specific cell. this is 100% ...

**0**

votes

**2**answers

46 views

### Can I have a $ aligned to the left and 0 to the right?

I am trying to format an Excel cell as per the example below. Is this possible?
$ 0.00
$ 24.20
$ 0.00

**1**

vote

**2**answers

242 views

### Determine if first visible cell equal to last

please how to determine in vba if first visible (after using filter) cell equals to the last visible cell?
If I have:
A5 = a, B5 = 1
A6 = b, B6 = 2
A7 = c, B7 = 1
A8 = a, B8 = 1
A9 = b, B9 = 2
...

**0**

votes

**0**answers

294 views

### Excel custom concatenate with color condition

I have this custom VBA function
Public Function concatenatespecial(rng As Range) As String
Dim rng1 As Range
concatenatespecial = ""
For Each rng1 In rng
If (Not Rows(rng1.Row).Hidden) ...

**1**

vote

**1**answer

564 views

### Excel custom function with IF and cell color

I need help with maybe custom function for excel.
Everything is in the picture: (Yes, I know that COLOR=YELLOW is nonsense, but its just example of what I think it could solve it).
Basically ...

**0**

votes

**1**answer

999 views

### Excel: Let Users Click, but Not Edit, Locked Cells

Is there a way to allow users to click on, but not edit, the contents of a cell? I know I can tinker in the settings in Review->Protect Sheet with the "Select Locked Cells" option. But here's the ...

**0**

votes

**0**answers

2k views

### How to change individual cell heights in a table using Word 2016?

I would like to change the height of individual cells at various places in a table in word. I would like to do this to keep use of space minimum and better aesthetics. Since I am using cell shading (...

**0**

votes

**1**answer

78 views

### refernce a cell that is a reference to another cell excel

I need to create a "double reference" in an excel sheet. What I need to do is enter a date on the first sheet, then reference that date on another sheet and (heres the part I dont get), reference the ...

**0**

votes

**1**answer

272 views

### Dynamic range with absolute start cell in an excel table

In a column headed "Fred Count" I have the formula =COUNTIF(L$2:L10,"Fred") in row 10 where column L is headed "Person" and contains various names, so as I drag the formula down the "Fred Count" ...

**0**

votes

**0**answers

18 views

### excel 2013 cell lmking with each other

i want to put value in one cell and that results in same value in other cell and vice versa in same worksheet?Also my both cells already linked to a formula .so how could i link both cells without ...

**1**

vote

**1**answer

75 views

### Is there a way to set Excel up so it will skip over the cells containing formulas and jump right to the cells requiring direct data entries?

I have a sheet with multiple columns that I need to enter numerical data in certain cells. Some of the rows contains formulas for totals and percentage results.
Is there a way as I enter data and ...

**0**

votes

**1**answer

118 views

### Find a text cell in a range dynamically

I am trying to find a cell in excel using a formula from a range.
The range will be as such:
╔═══╦═══╦═══╦═══╦═══╦═══╦═══╦═══╗
║ ║ A ║ B ║ C ║ D ║ E ║ F ║ G ║
╠═══╬═══╬═══╬═══╬═══╬═══╬═══╬═══╣
║ ...

**0**

votes

**1**answer

56 views

### Using a cell value as address to access another cell (which maybe in the another worksheet)

i have one question, i have one cell (R1) which contains the address of the other cell (R2). now i want to access the content of the cell (R2) using the address which is stored in first cell (R1)

**0**

votes

**1**answer

45 views

### How to apply a fomula multiple times at different intervals to entire column? OO Calc

I am using Open Office Calc on windows 8.1 Pro
I have the following data already sorted nicely.
A B C
--+-----------------------
1 | Bmw Gold £80
2 | Bmw Silver £60
3 | ...

**0**

votes

**1**answer

183 views

### Unexpected Behaviour using VLOOKUP in OpenOffice Calc

I am using VLOOKUP in OpenOffice Calc on Windows and trying to use a lookup table to populate some other cells.
My Lookup table ranging A1:B6 is
Car 4 Wheels
Florida No
Bus 8 ...

**1**

vote

**1**answer

54 views

### Continous cell range in a filtered cells on another sheet or same sheet

I have a data source where I want to assign continuous cell range to the filtered cells only. For example, if I have filtered cell A1,A40,A79,A118,A157 and so on have a gap of 39 cells/rows and I want ...

**0**

votes

**1**answer

401 views

### How do I calculate the ratio for a range of cells in excel?

I'm trying to calculate the number of females per 100 males in each state and display the result using cell arrays. If the data for any state is unavailable or producing an error, then empty cell ...

**0**

votes

**1**answer

86 views

### If I know the Row and I calculate the column, how do I make this a cell reference?

Here's my scenario:
I find the row in a table using the "match" function. Can I use this value to reference a cell in the row I've found.
For example, if, in cell B7, the match function returns a ...