No announcements
Found 2934031 threads
-
0 VotesExcel 2016 VBA - function to rank a group of values based on a common key
Dear community, I am trying to create a procedure in Excel VBA to rank a group of values ...Unanswered | 1 Replies | 358 Views | Created by Nicola82 - Tuesday, May 29, 2018 9:54 AM | Last reply by Andreas Killer - Thursday, May 31, 2018 10:30 AM
-
0 Votes
Ranking values based on arrays (Excel VBA 2016)
rank a group of values based on different arrays (Product Id).Unanswered | 3 Replies | 274 Views | Created by Nicola82 - Sunday, June 17, 2018 8:59 PM | Last reply by Terry Xu - MSFT - Tuesday, June 19, 2018 3:01 AM -
0 Votes
Filter based on Rank
. I am trying to create a Calculated Memeber in dataset which will have Rank , but I am not successul yet in doing so. My calculations are always ... -
0 Votes
compare multiple values in Excel to Rank
;F4/100000000+G4/10000000000-ROW()/1000000000000 and rank based on the values in I. A similar technique can be used ...Unanswered | 1 Replies | 621 Views | Created by lzsd4f - Monday, June 16, 2014 6:55 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Wednesday, June 18, 2014 1:46 PM -
0 Votes
Group Dictionary values of a particular key
I'm not sure what you mean. There is no dictionary involved now. Anyway, if you want to group by a certain property of the type of the list item, you can ...Answered | 5 Replies | 960 Views | Created by Siddy Boy - Wednesday, May 13, 2015 2:41 PM | Last reply by Acamar - Thursday, May 14, 2015 1:51 AM -
0 Votes
RANK Function for Group item level
. Year, 3. Salary. Here based on each year we need to show all the salary in each department. i need to use RANK () function to ...Answered | 3 Replies | 3112 Views | Created by Fazlu - Friday, April 27, 2012 7:03 AM | Last reply by Satheesh Variath - Friday, April 27, 2012 7:37 AM -
0 Votes
XY Chart on a VBA Userform Excel 2016
Hi, A few years ago I made a Excel VBA program with OWC11 charts (frequency analyzer). This function perfect on my private 64 ...Unanswered | 1 Replies | 738 Views | Created by PerLandeback - Thursday, May 18, 2017 8:28 AM | Last reply by Chenchen Li - Thursday, May 25, 2017 9:40 AM -
0 Votes
How to assign incremental/Rank values based on certain condition
MATCH_STATUS = 'Y' Then -1 Else rn End) As Rank From cte Order By Rank; If you have some other rule for choosing the order you want ties in the ID value to ...Answered | 1 Replies | 2780 Views | Created by Y.Chowdhury - Sunday, April 21, 2013 5:31 PM | Last reply by Tom Cooper - Sunday, April 21, 2013 6:13 PM -
0 Votes
Rank function
Hello all, is there function or a way to rank the below dataet ? i am not sure if first_value, lead or any other function that can ...Answered | 3 Replies | 559 Views | Created by Dkuud - Thursday, August 18, 2016 5:15 PM | Last reply by Dkuud - Thursday, August 18, 2016 6:57 PM -
0 Votes
VBA Excel 2016 Crashes ?generates a lot of emf files
I use VBA in excel 2016 (64bit) in Win10(64bit) It is an update of Excel 2003 with WinXP. After 2-6 hours ... -
0 Votes
Rank function
I have an MDX Query that is using the rank function, but it is not resetting the rank value when the top level of the hierarchy changes. I want to ...Answered | 1 Replies | 749 Views | Created by JeffreyShumaker - Monday, November 18, 2013 2:29 PM | Last reply by BillAnton - Tuesday, November 19, 2013 9:39 PM -
0 Votes
Rank function not working for null values
Hi All, I'm using rank function to avoid duplicates, Now my issue is rank() is not working with nulls if there is a tie between the ...Answered | 2 Replies | 3877 Views | Created by sql9 - Tuesday, May 18, 2010 5:29 PM | Last reply by Abdshall - Tuesday, May 18, 2010 5:44 PM -
0 Votes
rank function
Hi PeaceOut, According to your description, you want to get the rank within each group. Right? In this scenario, if you direct ...Answered | 3 Replies | 753 Views | Created by PeaceOut - Saturday, June 25, 2016 7:46 PM | Last reply by Simon_Hou - Monday, June 27, 2016 12:27 PM -
0 Votes
Rank Function
I guess as we're talking RANK functions, it needs to be SQL2005 + anyhow, although the derived table works nicely too. Abdallah - i think you need a ...Answered | 11 Replies | 3734 Views | Created by Ryan McBee - Thursday, December 10, 2009 3:49 PM | Last reply by Adam Haines - Thursday, December 10, 2009 4:22 PM -
0 Votes
Sum of row values based on a Group
Hi! I am trying to build an analysis wherein I have to show the Sales value for a Region. In a region we have multiple executives who work ...Answered | 2 Replies | 639 Views | Created by Abhi1318 - Wednesday, February 28, 2018 1:20 PM | Last reply by Abhi1318 - Thursday, March 1, 2018 8:44 AM -
1 Votes
rank values
Hi, I have used the RANK function in sql. I want to use this in the actual ssrs report. The left column is a calculated ...Answered | 5 Replies | 704 Views | Created by RonTech1 - Tuesday, October 7, 2014 4:01 PM | Last reply by RonTech1 - Wednesday, October 8, 2014 3:54 AM -
3 Votes
Rank single column of values
Hi, I'm tearing my hair out at the moment trying to rank a single column of ...Answered | 3 Replies | 808 Views | Created by Maracles - Monday, March 30, 2015 6:39 PM | Last reply by Saeid Hasani - Wednesday, April 1, 2015 12:36 AM -
0 Votes
Rank Function
column. Another alternative is to create an indexed view. If you don't want to deal with indexes based on computed fields additional alternatives would ...Answered | 6 Replies | 7406 Views | Created by Declan_ - Monday, July 30, 2007 5:03 PM | Last reply by Kent Waldrop _ - Tuesday, July 31, 2007 1:07 PM -
0 Votes
MDX help - Replace Rank function
Hi All In one of our mdx query we have Displaylevel member which will display 1 or 2 based on the latest and old Datetime values. In Myset we ... -
0 Votes
MDX Rank function
Groups].[Site Group Name].&[12]) are being listed with NULLS for the two non-Rank measures. And the Rank values for Net Rentals are still ranking all ...Unanswered | 2 Replies | 672 Views | Created by rocko - Wednesday, February 18, 2015 11:40 PM | Last reply by rocko - Thursday, February 19, 2015 12:29 PM - Items 1 to 20 of 2934031 Next ›
No announcements
