MS Excel experts - Jemsite
Off-topic / Miscellaneous Talk about miscellaneous stuff off-topic and not related to music, guitars or bands. No music, gear or anything guitar related here please.

 
LinkBack Thread Tools Display Modes
post #1 of 5 (permalink) Old 05-31-2005, 09:35 PM Thread Starter
 
Join Date: Jan 2002
Location: Michigan
Posts: 640
MS Excel experts

Hey,,been racking my brain on this. I need a formula that will take give me a break down. Here's what I'm dealing with.

I'm keeping track of absentee's for 2 Mfg facilities. Line 1 and line 2. What I'm trying to do is to get the Excel program to count and seperate how many call offs for each plant and it's 3 shifts. Currently the spreadsheet is set up in columns. F2:F2500 is where line number 1 or 2 is entered to represent which facility. G2:G2500 is where the shift is then entered.

DATE TIME ASSOC# CONF# DEPT.# LINE Shift

I would like it to be able to give me a break down of how many call offs we get by line and shift.

Any help would be appreciated.

~A
Allen Garrow is offline  
Sponsored Links
Advertisement
 
post #2 of 5 (permalink) Old 06-01-2005, 02:32 AM
 
Join Date: Jan 2002
Location: Bowling Green, Ohio
Posts: 388
Re: MS Excel experts

can you email the file? or at least part of it? i'll toy around with it tomorrow!

leon at wildealien dot com
wildealien is offline  
post #3 of 5 (permalink) Old 06-06-2005, 01:58 AM
 
Join Date: Jan 2002
Location: Bowling Green, Ohio
Posts: 388
Re: MS Excel experts

hey, i haven't come up with anything yet, sorry...
i'll keep toying around with it though.

i guess that makes me just an excel enthusiast and not an excel expert
wildealien is offline  
post #4 of 5 (permalink) Old 06-06-2005, 11:16 AM
rgr
 
Join Date: Dec 2000
Location: Longmont, Colorado
Posts: 1,882
Re: MS Excel experts

Hey Allen,

How's Nashville? If I could convince my wife, that's where I would be moving, but...

I might be able to help you out some, but I'm not sure if I completely understand the question/problem. Shoot me an e-mail, include the file if you can, and include you phone number (I'll send mine back). Use [email protected], don't go through jemsite, it still send to my hotmail account.

I'm not an expert, but I use it quite a bit at work being a nerdy engineer.
Later,
Roger
rgr is offline  
post #5 of 5 (permalink) Old 06-06-2005, 01:11 PM
 
Join Date: Feb 2005
Location: Rugby, UK
Posts: 2,361
Re: MS Excel experts

I think you might be able to do it with "IF" and "COUNTIF" formulae
markg5150 is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Jemsite forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address

IMPORTANT: You will be required to activate your account so please ensure that your email address is correct.

If you do not receive your activation check your spam folder before using the CONTACT US form (at the bottom right of each page).



Email Address:
OR

Log-in











Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Similar Threads
Thread Thread Starter Forum Replies Last Post
any pc experts here ?? the crafty mackem Off-topic / Miscellaneous 55 06-27-2012 01:40 PM
NGD ! S experts wanted ! Agent540 All Other Guitars (including Prestige) 4 04-13-2009 04:30 PM
Gibson ES experts? sihackett29 All Other Guitars (including Prestige) 7 02-27-2008 05:17 PM
PAINT EXPERTS! i need help please! shreddervai Tech: Setup, Repairs and Mods 1 08-15-2004 06:15 PM
Need the advice of experts! you! :-) OlafLenk All Other Guitars (including Prestige) 12 05-22-2004 10:29 PM

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome