You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I have a list of names on one spreadsheet (A).
On another spreadsheet (B)I have a pivot table with names down the left, months across the top, and the value is a payroll deduction.
Apr 16 May 16 Jun 16
Joe Blogs 150.00 150.00
How can I automatically return the month the deduction started in to spreadsheet A?
Thanks
Ah bugger formatting doesnt work on here...
Apr 16 = 0
May 16 = 150
Jun 16 = 150
So I would want the formula to return May 16
Any reason you can't put the sheet with the names in the other one?
If you list the months as numbers and return MIN of something
It may be easier to get from the data than the pivot table
I have 100 + names to return, the value for, and the date range is April 2014 to Feb 2017, so a lot of columns !
Once the deductions start it is always the same value, it is just returning the first month 🙁
Could you do a VLOOKUP from the pivot in to spreadsheet A?
A work colleague has just done something that works on the pivot table, and then a simple lookup to spreadsheet A
=INDEX(B$4:AV$4,MATCH(TRUE,INDEX(B5:AV5<>0,),0))
Google is your friend