Questions tagged [cell]
A cell is an atomic element within a structure composed of columns and/or rows, such as a table or grid. For questions regarding cell arrays in MATLAB, the tag [cell-array] should be used.
5,111
questions
0
votes
0
answers
11
views
How to merge a set of square cells (2D) into minimum number of larger square cells?
How to merge a set of uniform cells (2D), into minimal number of larger square cells, plus un-merged cells?
The picture depicts a signed distance field (SDF) of a torus cross-section in 1st quadrant (...
- 99
0
votes
0
answers
11
views
How to fix slicer position in excel during cell scrolling in any direction
In excel when i scroll cell in any direction that time slicer position also be scroll in cell direction but i want to fix slicer position for any scrolling it remain fix at their position
I try to fix ...
0
votes
1
answer
89
views
In Swiftui, is there a way to get the id / position of a grid's cell using onTapGesture or any other technique?
I am trying to learn SwiftUI by converting my personal Android apps. I am initially prototyping the interfaces. I have coded a LazyVGrid. I want to be able to tap on a "cell" and be able to ...
- 11
0
votes
0
answers
31
views
Need Help Comparing Text in One Cell To Another
I am trying to develop a program where the end state will be this program finding all instances of similar text within cells from multiple sheets and grouping it together. This question is going to ...
- 1
0
votes
2
answers
41
views
How do I set a variable to ActiveCell.Row
I would like to be able to return the row number of the active cell then assign that value a variable. It is saying "Object not Defined" for ActiveCell.Row when I attempt to run the Macro. I ...
0
votes
1
answer
85
views
How to return all/multiple the Cell Addresses/Reference in Datagridview?
This is my new post but in continuation of Thread 78734244 of this forum.
I was wondering How Could i get all the Cell Addresses/Reference in Datagridview. The above thread was for
any single input of ...
- 11
0
votes
1
answer
37
views
Setting Interior Color in a cell in excel
I am trying to colour the interior of cells in an excel spreadsheet. I want to set a colour which I am deriving from a routine based on a "NoteNum". This is just a number from a sequence ...
- 9
1
vote
1
answer
51
views
Write a loop that will check all tabs, a count of sheets, tab color changes based on 3 cell's values
I have a spreadsheet with multiple tabs. This is for pricing. The first tab can be changed in 4 rows to change the profit of each part number which lives on its OWN tab. I would like a code to loop ...
0
votes
1
answer
48
views
How to return Cell Reference of DataGridView if Value in that Cell Matches with Textbox?
I would like to get the reference to a Cell - i.e. the row and column numbers, or the cell address of the particular cell if that DataGridView cell contains the value of a Textbox.
I've explored many ...
- 11
0
votes
2
answers
62
views
How to get a string array in an Excel cell and use as a reference
I have the following formula:
=SUM(COUNTIF(Country;{"CHN";"SGP";"AUS";"MYS"}))
where Country is a Column.
I would like to have a cell containing the array of ...
- 89
1
vote
0
answers
45
views
Adding Rows in DataGridView on form without writing the syntax DataGridView1.Rows.Add(3)
The thread question is clear and specific ie. to add rows in DGV1 on Form without writing its syntax (programmatically
The reason i want is to work around with cells in DGV1 is for Numbering cells its ...
- 11
0
votes
0
answers
17
views
If field updates to give me a result SQL or POWER BI
I have a column of names if there is an update to that name i want it to tell me it has changed. there is no footprint to tell me it has changed so I'm having to work from the specific column / cell.
...
- 33
0
votes
0
answers
45
views
creating a cell reference with a fixed column name and the line # from a value in a different cell
I have a workbook with data from multiple years in separate worksheets. On my summary worksheet I am using the following formula, plus multiple similar formulas, to analyze data: =AVERAGE('2024:2014'!...
0
votes
0
answers
21
views
search the values in a range of rows in a column thru a table array
I'd like to find a formula/function in excel to help me out to search for a set of values in a range of rows in a column thru a table array. The output I'm expecting is to have the column with the ...
0
votes
1
answer
23
views
How do I dynamically insert a column of data into the middle of a html table which uses both rowspans colspans?
I've got an existing large table that has multiple rowspans and colspans.
Ideally it would be rewritten from scratch to not use one large table, but that isn't an option right now.
By adding classes ...
- 11