Formula based column B return A in list format

itzvicc

New Member
Joined
Oct 25, 2006
Messages
12
Hello I am very inexperienced with Excel. I am hoping that someone can give me some help.
How do a create a list based on frequency without blanks. "Daily duties", "Weekly Duties"?


What I have is a worksheet (Duties-Alpha) This has column A Duty, Column B Frequency, Column C Responsible Pary.

What I need help with is I would like to complete a list based on frequency for each staff member.

On my worksheet (Duties-Emp) I have a column for each person, and then A2:K10 is the section for the daily duties.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,095,319
Messages
5,443,765
Members
405,251
Latest member
shanezer

This Week's Hot Topics

Top