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 »
Slackalaxy 