Sorry if this question has already been answered but I am having a hard time clarifying what I am looking for to search. I have a sheet of employees with a helper column (called structure) that is displays their job title as a number using descendants (lower the number the higher their position). If needed this can be…
Hi All, Just wondering if anyone can help me with your wisdom! From the list of assets below, I need to have top 5 or top 10 of most ordered as well as less ordered (please note there is a repetition of the same asset name throughout the sheet) and there's 2 x different categories: social and TV which need to be ranked in…
Hi, So I can't seem to figure this out. Below I have the name of a manufacturer with how much we are spending with them in no particular order. I'd like to use a formula that tells me, in decending order, the top 10 manufacturers we've spent the most money on. I would need the information to be listed like below STERIS…
Hello, I have a list in my primary column with categories ([Primary Column]52:[Primary Column]93). The column to the right COUNT column has counts for the categories ([count]52:[count]93). I also have a ranking column next to that with the following formula in it from row 52-93 —> =RANKEQ([Count]@row, Count52:Count93, 0).…
Hello everyone! I'm curious how fellow community members share your accomplishments, if you do at all! The certification is an obvious one, but do you share your community rank? What about certain badges like Automagician, or being a member of a program like the Mobilizers? I currently have my certification highlighted on…
I am having trouble with a Collect formula when I add another criteria. The Collect formula is embedded in a Rankeq formula. This formula (Rank column) works: =IFERROR(RANKEQ(DateNum@row, COLLECT(DateNum:DateNum, DateNum:DateNum, @cell <> ""), 0), "") When I add to the Collect portion of the formula (RankKL column) I get a…
