When i fill dates for all stages it should give me the stage of date entered in last cell and should show how many stages passed.
Pls see the attachement .
When i fill dates for all stages it should give me the stage of date entered in last cell and should show how many stages passed.
Pls see the attachement .
="Its in "&INDEX($B$1:$G$1,MATCH(1,B2:G2,-1))&" stage and has passed "&MATCH(1,B2:G2,-1)-1&" stages"
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks