te')); return $arr; } /* 遍历用户所有主题 * @param $uid 用户ID * @param int $page 页数 * @param int $pagesize 每页记录条数 * @param bool $desc 排序方式 TRUE降序 FALSE升序 * @param string $key 返回的数组用那一列的值作为 key * @param array $col 查询哪些列 */ function thread_tid_find_by_uid($uid, $page = 1, $pagesize = 1000, $desc = TRUE, $key = 'tid', $col = array()) { if (empty($uid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('uid' => $uid), array('tid' => $orderby), $page, $pagesize, $key, $col); return $arr; } // 遍历栏目下tid 支持数组 $fid = array(1,2,3) function thread_tid_find_by_fid($fid, $page = 1, $pagesize = 1000, $desc = TRUE) { if (empty($fid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('fid' => $fid), array('tid' => $orderby), $page, $pagesize, 'tid', array('tid', 'verify_date')); return $arr; } function thread_tid_delete($tid) { if (empty($tid)) return FALSE; $r = thread_tid__delete(array('tid' => $tid)); return $r; } function thread_tid_count() { $n = thread_tid__count(); return $n; } // 统计用户主题数 大数量下严谨使用非主键统计 function thread_uid_count($uid) { $n = thread_tid__count(array('uid' => $uid)); return $n; } // 统计栏目主题数 大数量下严谨使用非主键统计 function thread_fid_count($fid) { $n = thread_tid__count(array('fid' => $fid)); return $n; } ?>google sheets - Extract randomly data according to multiple criteria - Stack Overflow

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>google sheets - Extract randomly data according to multiple criteria - Stack Overflow

    google sheets - Extract randomly data according to multiple criteria - Stack Overflow

    programmeradmin2浏览0评论

    I have the following sheet

    My goal is to return data in col P randomly from col N or from col O. If cell B3 contains "2 shifts", it should return from col N and if cell B3 contains "3 shifts", it should return from col O. The amount of random cells to be returned is in D3 and should be able to be changed as wanted. I can extract cells in order by using the below.

    =ArrayFormula(QUERY({N2:N, RANDARRAY(ROWS(N2:N))}, "SELECT Col1 LIMIT "&$D3))

    The above only returns the first 6 but only contains 1 criteria. I cannot make it work. Please help PS: I can only use formulas and not scripts.

    I have the following sheet

    My goal is to return data in col P randomly from col N or from col O. If cell B3 contains "2 shifts", it should return from col N and if cell B3 contains "3 shifts", it should return from col O. The amount of random cells to be returned is in D3 and should be able to be changed as wanted. I can extract cells in order by using the below.

    =ArrayFormula(QUERY({N2:N, RANDARRAY(ROWS(N2:N))}, "SELECT Col1 LIMIT "&$D3))

    The above only returns the first 6 but only contains 1 criteria. I cannot make it work. Please help PS: I can only use formulas and not scripts.

    • google-sheets
    • google-sheets-formula
    Share Improve this question edited 11 hours ago Patsytalk 9751 gold badge1 silver badge15 bronze badges asked Feb 17 at 12:36 JeromeJerome 738 bronze badges 2
    • Please do not upload images of code/data/errors. – TheMaster Commented Feb 17 at 15:39
    • Make sure to provide input and expected output as plain text table in the question. Check my answer or other options to create a table easily, which are easy to copy/paste. Avoid sharing links like spreadsheets, which make the question useless for others or images, which are hard to copy. Also, note that your email address can also be accessed by the public, if you share Google files. – TheMaster Commented Feb 17 at 15:39
    Add a comment  | 

    1 Answer 1

    Reset to default 1

    Try:

    =LET(
  arr, TOCOL({IF(B3 = "2 shifts", N2:N, O2:O)}, 1),
  SORTN(arr, D3, , RANDARRAY(ROWS(arr)), )
 )

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论