Results 1 to 7 of 7

Create excel table using formulas

Threaded View

CC_deallist Create excel table using... 01-09-2018, 06:22 PM
Aardigspook Re: Create excel table using... 01-10-2018, 08:16 AM
CC_deallist Re: Create excel table using... 01-10-2018, 08:41 AM
sandy666 Re: Create excel table using... 01-10-2018, 09:00 AM
Aardigspook Re: Create excel table using... 01-11-2018, 12:14 PM
CC_deallist Re: Create excel table using... 01-19-2018, 05:41 AM
Aardigspook Re: Create excel table using... 01-19-2018, 10:48 AM
  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    Oftringen, Switzerland
    MS-Off Ver
    Professional Plus 2010
    Posts
    16

    Post Create excel table using formulas

    Hi all

    I have an excel sheet that indicates the timecard date of different employees and I would like to create a table using formulas as opposed to the in-built manual excel function.
    My data is unsorted as shown in columns A:D in the attached excel file. The employees can work more than once in day (maximum 3 shifts per day) and more than one employee can work per day.
    Column A shows the day.
    Column B the employee.
    Column C the start of the shift.
    Column D the end of the shift.

    The goal is to have the date sorted (using formulas) by employee and date, as shown in columns I:N in the attached excel file
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-31-2017, 04:20 PM
  2. Using indirect (?) within table to create dynamic formulas
    By cotoews in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2013, 07:01 PM
  3. [SOLVED] Looking to Simplify Pivot Table and Formulas Used to Create Chart
    By mo4391 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-29-2013, 11:44 PM
  4. Replies: 0
    Last Post: 11-07-2012, 01:16 PM
  5. Create New row in a table and copy/update formulas VBA
    By whitenoise22 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-25-2012, 03:07 AM
  6. How do you create formulas in pivot table eg simple division?
    By Belinda_Tim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2006, 11:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1