senior

I am trying to auto-populate cells using IF/Then Statements (I think) The following is a description of the sample table below: - Hours (Number of Hours Worked) - Role Name - Role Code (LSEA, SEA1, SEA2, SEA3, Tools, PM, GOV) Question: How do I link the hours for a specific Role name to the...

Hi, need to automize the description based 3 criteria. - Personnel number (#3 and #4 are letters short for department) - Personnel code (random) - Appointed period would like to have the description within such format: e.g:Finance_Department_01.01- 01.07.2012_PN_876789 (Indicated in red)...

Hi everyone, I have the following table <colgroup><col><col><col><col></colgroup><tbody> Office Position Start Date Termination Date New York Manger 20-Jan-16 11-Nov-17 Chicago Director 20-Jan-16 28-Dec-18 Miami Senior Manager 20-Jan-16 13-Feb-17 Boston Director 20-Jan-16...

I am using MsExcel 2016. On sheet 1 I have a list (300+ rows). Headed by last name and first name and title 1 and title 2 and date. On sheet 2 I wish to group that data by say; title 1 or by title 2 or by date. Sheet 1 example data Last name First name Title 1 Title 2 Date Smith John Senior...