User Profile
PReagan
Bronze Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Create a reference list to autofill
Hello CoachSandy, Perhaps you could create a second query that contains the professors' names along with their status (FT, ADJ, UNA). Then, merge the first query with the second query and filter out the professors' names from the second query. Take for example the following blog post: https://www.myonlinetraininghub.com/excel-power-query-vlookupRe: I am trying to find active employee headcount with multiple hire dates and termination dates
Hello GayathriSK, Perhaps this is what you're after? =SUM( COUNTIFS($I$2:$I$4,">"&TODAY(),$H$2:$H$4,"<="&TODAY()), COUNTIFS($I$2:$I$4,"",$H$2:$H$4,"<="&TODAY()) ) Where WD_Termination date = $I$2:$I$4 and WD_Original_Hire_Date = $H$2:$H$4. Active Employee Case 1: COUNTIFS($I$2:$I$4,">"&TODAY(),$H$2:$H$4,"<="&TODAY()) — Counts if term date is after today and hire date is on or before today. Active Employee Case 2: COUNTIFS($I$2:$I$4,"",$H$2:$H$4,"<="&TODAY()) — Counts if term date is blank and hire date is on or before today.Re: 复杂公式的自动填充（Automatic filling of complex formulas）
Hello Yunpeng_Shen, This might not be the answer that you're looking for, however, I'll give it a try... With the "m" values placed in column A, you could use helper columns to the right of A to create each addition to the sequence. In each helper column, you could use the formula(s): =$A$1^ROW($A1); =$A$2^ROW($A1); =$A$3^ROW($A1); =$A$4^ROW($A1) and so on... Take for example the following image: Then simply add rows and helper columns as necessary.
