Organizing tasks and schedules with forulas

MrMeeseeks

New Member
Joined
Oct 3, 2019
Messages
1
Hello everyone,

I am trying to make a spreadsheet that includes a calendar for task scheduling and the project details in another tab.

Columns B and C in the calendar look something like this:
B
C
proj.1
task 1
(blank)
task 2
(blank)
task 3
proj 2
task 1
(blank)
task 2
(blank)
task 3
and so on
and so on

<tbody>
</tbody>

Now i need to generate the list for the project details in another tab using formulas so that who'll be using this sheet won't have to update both tabs every time (minimizing the human error).

In short: the list should take the data from column B and display it in the same order in a chosen column, like this:

proj 1
proj2
proj3
etc

but i cannot find a way to skip the blank cells and only display the ones that have content.

So far i tried using IFs, ISBLANKs, VLOOKUPs and combinations of those + others, with no luck so far.

I am starting to think that this might be very complicated if not impossible. Do you think that writing a (not too complicated) macro would be better? Or maybe with "define name" or making a data set of the column i need the info from might work?

Iknow, i know, there are softwares and apps that do exactly what i need which i already tried and proposed, but you know how it is... If the boss needs a wheel but wants it to be a square but equally functional you have to do your best to comply.:confused:
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hi,

So how many days do you need to show tasks on the calendar tab? a chosen week or fortnight?
 
Upvote 0

Forum statistics

Threads
1,213,529
Messages
6,114,155
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top