Let's assum that:
- then count the number of rows in range A:A is range A1:A8
- Cell A is = "SP" or cell A = "DP", is...
Just use the event change for Combo1 to re-populate the rest of combos depending upon selected value in combo 1. And do not forget to clear them beofre...
RET Yesterday, 10:27 PMDear All,
I am trying to calculate some totals without using VBA as the spreadsheet is xlsx and I cannot change it.
I would...
Also x-posted:
https://chandoo.org/forum/threads/ex...-in-vba.45865/
https://www.ozgrid.com/forum/index.p...75#post1245275...
Change INDEX MATCH Function to UNIQUE FILTER for sorting data
Welcome to the forum.
AliGW Today, 09:20 AMAttach a sample workbook, please. Your formula does not inherently pull a top five list, nor does it sum anything,...