-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
spans
-
Z
Span of Control Count
Hi, I have a report that have all management levels (management layers) and what I need is to count how many layers under each manager from Management Chain 02. I have the below sample table and want a formula that can help with accomplishing my target. The report I have has more 8000 rows and...- zinah
- Thread
- count & count ifs spans
- Replies: 9
- Forum: Excel Questions
-
D
Formula nesting help
Hello Everyone, i have the following formula that compares 2 sheets and returns Yes Or NO. The formula is auto filled entire column. So if my data spans from AD3 to AD 80, i will have 8 rows of "No". iS there a way to blank this out? =IF(ISNA(VLOOKUP(A11, 'SP'!$AD$3:$AD$88,1,FALSE)), "No"...- Dan88
- Thread
- ad3 blank formula rows spans
- Replies: 4
- Forum: Excel Questions
-
M
Matching a sheet to reference depending on current date
If I have a workbook that has 365 sheets that each reference a date and are labeled in a MM/DD format; is it possible to reference those sheets depending on the current date which is subsequently their name? For example, this formula takes a running total from a previous sheet titled "Sept 16"...- MrBurn5
- Thread
- running sheet sheets spans total
- Replies: 2
- Forum: Excel Questions
