Forum Discussion
Solved
need help with a formula
I have a excel sheet that has an employee's Provident fun deduction amount per month from the starting date Now I need to bring “from which month and year an employee has started to deduct his Prov...
The formula that I posted will only work in Excel 365 / 2021. The following version should work in older versions too:
=INDEX($D$2:$AM$2,MATCH(TRUE,D3:AM3>0,0)) & ", " & INDEX($D$1:$AM$1,QUOTIENT(MATCH(TRUE,D3:AM3>0,0)-1,12)*12+1)
Confirm with Ctrl+Shift+Enter.
Attach a sample file then we could suggest formula for you. I assume VLOOKUP, INDEX/MATCH, XLOOKUP, FILTER all of these function can give you desired result.
- attached the excel file. please help me bring the starting date with formula for each employee
