Google Sheet hides empty cells

I therefore have a simple formula that I use for my table game.
I have the player names in A2-A26 and their turn number in B2-B26
In E2 I have the formula


Now this makes a list of the highest tower number up and down.
However, it also displays all the players in the list.
Some rounds, only 5 players participate. So I would like only these 5 players to appear in cell E2 and down.
Players who do not have a turn number will have an empty cell in B2-B26
I've tried using filtering. But I can not make it work.

google sheets – Concatenate text from a column with text in non-empty cells in the range

I need a formula to concatenate the text of column A with each non-empty cell of B1: Z. The number of lines in the input data will change, so it must be accounted for in a dynamic way. In addition, the lines have varying lengths and can change, so it must be considered dynamically.

Here are sample data (editable by everyone with the help of the link):

Data given in a sheet such as InputData I need one type of formula (ArrayFormula, I think) in another sheet that will produce something that looks like what I've hard-coded DesiredResult. The idea is that the data in InputData changes (added, deleted, modified), DesiredResult it will automatically adjust without it being necessary to modify it.

I've shown my best attempt in the sheet Result - Formula Not Correct who uses:

=ArrayFormula(FILTER(InputData!A1:A, InputData!A1:A <> "") & " -> " & ArrayFormula(FILTER(FILTER(InputData!B1:Z, InputData!A1:A <> ""), InputData!B1:Z1 <> "")))

bokeh heatmap scale parcel size with cells

I'm trying to generate a rectangular plot using Bokeh. I wish the chart to define the dimensions so that when I increase the number of elements on the x or y axis, the cells cover the entire chart.

Here is what I try to do:

from bokeh.plotting import figure, show, output_file 

from bokeh.palettes import Reds

data_dict={'state':('New York','New Mexico','New York','New Mexico'),'feature':('poverty','poverty','unemployment','unemployment'),'color':=(Reds(9)(0),Reds(9)(1),Reds(9)(2),Reds(9)(3)}

p = figure(title="testing",tools="hover", toolbar_location=None,x_range=data_dict('feature'), y_range=data_dict('state'))


p.grid.grid_line_color = None
p.axis.axis_line_color = None
p.axis.major_tick_line_color = None
p.axis.major_label_text_font_size = "10pt"
p.axis.major_label_standoff = 0
p.xaxis.major_label_orientation = np.pi/3


Eliminate all the whitespace in the plot.

Google Sheets Automated Appropriate Case When Changing Cells

I play the World of Warcraft game and my guild has a registration form for the raids we do every week together.
Everyone visits the sheet and taps into their class | name | talents so that others know who will participate in the raid and who will not.

I want cells D9: F12, D16: F23, D27: F54, D58: F67, D71: F90 to automatically adapt to the appropriate case when someone types a text into those cells.

then instead of:

warrior | huzzah | fury

I want it to look like this:

Warrior | Huzzah | Fury

I'm not good at scripts or at Google Sheets in general … Please explain easily what I should do so that I can understand the steps! Also, I am not interested in using addons. I think that can be done using a script.

It is important that the rest of the letters after the first letter of the word be in lower case. Because there are graphics that count the number of classes present in each range. So if someone writing warrior instead of Warrior, which counts for 2 different entries and allows the chart to show them both instead of just one.

I do not want to press an extra step (such as a macro or keyboard shortcut) to edit the text. I want everything to be automated as soon as users have entered the text into one of the cells in those ranges.

TLDR: I want the cells to automatically adjust the w at W. And the rest of the letters of each word in lower case.

Bad input format:

REAR | HUZZAH | fury

Correct input format:

Warrior | Huzzah | Fury


Is it possible? Thanks in advance !!!

Google Sheets conditional formats only applying formatting to certain cells

I am currently working on creating a spreadsheet that will determine the class in which I should be according to the times. All of this works and generates results if I had to be in the class in a TRUE / FALSE cell. My conditional formatting uses this output cell to highlight the cells in my class list indicating the class in which I am. However, formatting only applies to some of the cells when needed, and applies formatting to certain cells when it should not. , although there is only one cell to control the formatting of all cells.

I can not share the document because of the way the school has set up our accounts, but I can show this screenshot.
the spreadsheet
edit: I created this dummy spread, the left box of C1: D8 has the custom formula of =A1and the right box (F1: G8) has =EQ(A1,TRUE)and A1 is the bool TRUE

vba – Intersect method slows code in a large selection of cells

I have an image in some cells. When I run the following code in a smaller number of selected cells, it executes correctly, but as the number of selections increases – say, above 1000, the code slows down a bit. Can it be optimized?

Sub shapesincells()
Dim sh As Shape, isect, rng As Range, n As Integer, arr() As Variant, sample As String
ReDim arr(ActiveSheet.Shapes.Count)
n = 1
For Each sh In ActiveSheet.Shapes
        Set arr(n) = sh.TopLeftCell
        n = n + 1
For Each rng In Selection
    sample = rng.Offset(0, 30).Address
    For n = 1 To ActiveSheet.Shapes.Count
    Set isect = Application.Intersect(arr(n), rng)
            If Not isect Is Nothing Then
               sample = "Yes"
            End If
    If IsEmpty(sample) Then sample = "No"
End Sub

Why does this Google sheet formula count empty cells?

I'm new on Google Sheets, but I only use it for simple tasks. Still, I encountered a problem that I can not solve. I will start with an image of my google test sheet below:

my google test sheet

If you look at the picture above, there is a screenshot of a test sheet showing the problem that I do not know how to solve. Column A uses the formula = IF (E3 <> "", COUNTA ($ E $ 3: E3), "") to count and number the values ​​in column E.

I then copied and pasted the values ​​from column A into column C and attempted to do the same calculation in column B of column C, changing the values ​​a few times. The same formula (now placed in column B) COUNTS values, but no longer skips empty cells. Does anyone know why this is? I guess it has something to do with "Editing> Paste Special> Paste Values ​​Only", which does not work as I think, but something is now in the empty columns in column C that I can not no see. Or maybe I do not understand the formula?

Summary: Why does the formula: = IF (E3 <> "", COUNTA ($ E $ 3: E3), "") work between column A and column E, but does not work in the same way between column B and column C? I would like it to count the values ​​AND ignore the empty cells. This image is a small-scale version of a much larger Google sheet, but the problem is the same. I need to be able to edit a column, then recount / renumber the values.

Thank you!

PS I've tried sharing this sheet with Google, but Google does not allow me to share it with anyone because I have to allow access to specific people. If someone wants to inspect it, I can export it and download it to a Google reader.


EDIT: I thought that it would be useful to add clearly what I am looking for –

I would like the formula in column B to ignore empty cells in column C, generating 13 to the last cell (cell B24) instead of 22.

google forms – How to check if the values ​​of two cells exist in two columns of another sheet

I try to make a classroom attendance system where the student saves by submitting her name in Google forms. The final result will be displayed in Google sheets by ticking a box after the name of each student.

So, in Google Sheets, in cell B3 of sheet 2, I would like to write a formula that checks if the text of B2 of sheet 2 (2019-10-20) matches column A of sheet1 where the text contains additional characters (2019-10- 20 04:15:25) AND if the text in A3 of sheet 2 (Robin) exists in column B among the results that have just been matched. If it does – returns TRUE, otherwise returns FALSE.


plugins – Add empty cells to an array with posts

I'm trying to create a plugin and I want to appear a table in which WP messages would be displayed. I can do it with the following code:

echo '';

$custom_type_args = array(
   'post_type' => 'custom_type',
   'posts_per_page' => '-1',

$query = new WP_query ( $custom_type_args );

if ( $query->have_posts() ) {

$i = 0;
while ( $query->have_posts() ) : $query->the_post();
   // Functions
'; }?>

   "; $i = 0;}?>


echo '
// Some content here

The case is, I want add an empty cell in the row with three cells if at least one of them is empty. Something like that:

// Some content // Some content // Some content
// Some content // EMPTY CELL // EMPTY CELL

I tried to change the first code in different ways, but nothing worked. Could you give me a simple example of how to do that? I would really appreciate any help.

UITableViewCell responds to the tap anywhere in the view and does not recognize other cells

These are two typical UITableViewDelegate functions in which all the action takes place, but I can not understand the problem. A few hours ago, I had a problem with IndexPath and optional values.

func tableView(_ tableView: UITableView, didSelectRowAt indexPath: IndexPath) {
    self.selectedIndexPath = indexPath.row
    self.performSegue(withIdentifier: "ShowDetails", sender: self)

override func prepare(for segue: UIStoryboardSegue, sender: Any?) {

    if (segue.identifier == "ShowDetails") {
        let viewController = segue.destination as! TaskDetailsViewController
        print(items(selectedIndexPath).name!) = items(selectedIndexPath).name!
        viewController.dateTime = items(selectedIndexPath).dateTime!
        if let noteDescription = items(selectedIndexPath).noteDescription {
            viewController.noteDescription = noteDescription

I'm attaching a screenshot of what I'm talking about, to make it easier to understand.

enter the description of the link here