Hi All
I have some data made up from several tabs on an excel s/s (attached)
I would like my 'All Tasks' tab to be the master, and have the status updated depending on wether the tasks exist on one of the other tabs.
For example if Task 1 exists on in the 'Done' tab I want to update the status to Done on the All tasks tab.
Finally, I'd like to create a pie chart based on the status
Any help would be greatly appreciated, thanks in advance
Formula on All Tasks sheet
=CHOOSE(IF(ISERROR(MATCH('All Tasks'!A2,Done!$A$1:$A$9,0)),IF(ISERROR(MATCH('All Tasks'!A2,'Not Done'!$A$1:$A$9,0)),IF(ISERROR(MATCH('All Tasks'!A2,Other!$A$1:$A$9,0)),4,3),2),1),"Done","Not Done","Other","Not Found")
You can then use a COUNTIF formula to build data for pie chart
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks