How to do this in Excel
Copy the following values and paste into A1:E9 cells in excel sheet.
Solution
The formula is in cell D25
=RANK.EQ($B25,$B$25:$B$32)+COUNTIFS($B$25:$B$32,$B25,$C$25:$C$32,">"&$C25)+COUNTIFS(B$24:B24,B25,C$24:C24,C25)
Since it takes one row above the table, the table cannot be started in row 1. If there is a header, then it works and return this result:
- Best option to refresh a single query using VBA
- Repeat VBA Code to run for another cell in the same sheet
- Create a folder and sub folder in Excel VBA
- How to loop in excel without VBA or macros?
- Configure default number format to 0 decimal places for new/existing workbooks in Excel 365 ProPlus?
- Delete objects and replace spaces left after that with symbols in black (color)
- EXCEL randbetween- text representation - clarification
- How do I access a historical weather API from open-meteo in Excel using VBA?
- Finding the correct remaining customer term with a given goods volume
- Speeding Up Index-Match for Large Dataset
- How to get current time in VBA as string? Ex. 7:38 PM, I want "073800"
- Data cleanup for large data set
- Adding a newline character within a cell (CSV)
- Excel SORT Function in Conjunction With UNIQUE, TOROW & VSTACK
- Hide and Unhide Rows via Single Button
- Xlwings Excel and Windows Task Scheduler issues
- Put borders below all the rows with the last date value in a date series
- Issue with IF sentence containing AND & OR functions
- Unprotect an Excel file programmatically
- Complicated xlookup across two sheets with multiple criteria
- Sumif times (datetime format) are greater than 22:30
- How to loop concatenate separately, groups of rows with VBA?
- SumProduct over sets of cells (not contiguous)
- Adding a "0" to the beginning of a 4 digit excel cell to make it a zip code.
- Can't unprotect an excel worksheet in Workbook_BeforeSave
- Change formula to a function that evaluates the starting formula
- Chart range based on the value in a cell
- Changing cell colour using VBA in Excel
- How to color excel cells with specific values in dataframe Python
- Talend import, transform a raw file and export to CSV