Hello Community, I'm looking for formula that will rank the 'Offsetting Acct Names" by 'Supplier Total Spend'. As you can see below, I captured the total spend per supplier but need to rank these and …
I have a count of incidents for each location. The "rank helper" column use to total the number of incidents beside the first occurrence of a name. For example: Bellflower has "2" incidents. I want th…
I have been trying to rank my rows that are listed as "Tier 1" in the {Level} column in order of importance based on the following criteria: 1) Highest Rank: Rows with the oldest {R/O Create Date} AND…
Hey friends, I am trying to create a column that ranks (without duplicates) the results of a PIVOT configuration. The PIVOT config produces the SUM of rental dollars spent, in column "Grand Total-SUM …
I have a sheet that captures the average rankings assigned to requests in order of priority. I need a formula to create a metric that displays the Top 10 request IDs that have the lowest average ranki…
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 dis…
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 …
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 or…
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…
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 bad…