Spreadsheet: if cell contents is greater
Posted: 2023-08-31 Filed under: office | Tags: excel, if, spreadsheet Leave a commentI have a spreadsheet, where I want to check if the contents of each cell is greater than a certain value. If TRUE, I’d like to return “YES”, so I filter on these cells. I googled a bit and found the following instructions.
Read the rest of this entry »
Column to cell in a spreadsheet
Posted: 2023-04-30 Filed under: office | Tags: Cell values, excel, gene, row, sc-type, spreadsheet, transpose Leave a commentI have a list of gene names in a spreadsheet column hat I need to transform to a row. Using the transpose function does not do the job, because gene names should be in a single cell, comma separated. So, I searched a bit and found the TEXTJOIN function.
Read the rest of this entry »
Spreadsheet cells’ contents length
Posted: 2021-11-07 Filed under: office | Tags: gnumeric, spreadsheet Leave a commentI need to compare a list of UniProt identifiers to a database of protein-protein interactions. All IDs in my list are 6 characters in length, while the database I am comparing to has many entries that are longer. I want to clean these up, since nothing from my list will match to them and I also want to speed searches by making the database smaller.
Read the rest of this entry »
Average every n number of rows in a spreadsheet
Posted: 2021-02-27 Filed under: academic, office | Tags: gnumeric, spreadsheet Leave a commentI have a long column of data that I want to make into a chart. The problem is that the column has over 50000 rows and processing it gets problematic. I looked for a way to average every Nth number of rows, in order to speed up things.
Read the rest of this entry »
Shorten contents of spreadsheet cells
Posted: 2020-08-05 Filed under: academic, office | Tags: Cell values, function, gnumeric, left, shorten, spreadsheet Leave a commentI have a spreadsheet file with a list of species’ Latin names. I want to automatically create abbreviations for each species, by shortening both the genus and specific epithet to a certain number of characters. Here’s how to do it.
Read the rest of this entry »
Slackalaxy 