Go to Post We're engineers. We fix problems, not complain about them. - plnyyanks [more]
Home
Go Back   Chief Delphi > Technical > Technical Discussion
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Spotlight this post!  
Unread 30-01-2007, 22:18
kramarczyk's Avatar
kramarczyk kramarczyk is offline
is getting his kicks.
AKA: Mark Kramarczyk
FRC #3096 (Highlanders)
Team Role: Mentor
 
Join Date: Mar 2006
Rookie Year: 2006
Location: Sterling Heights, MI
Posts: 602
kramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond repute
Re: Help with excel

How about

=IF(OR(Sheet3!B2=Sheet1!$T$25,B2=Sheet1!$U$25,Shee t3!B2=Sheet1!$V$25),Sheet1!$U$17,IF(OR(Sheet3!B2=S heet1!$T$26,B2=Sheet1!$U$26,Sheet3!B2=Sheet1!$V$2) ,Sheet1!$U$20,0))

Assumptions:
That this will only be used to track one match at a time. If you want to collect across sheets then a VB macro is probably in order. I think I have something similar from last year that can be recycled.
 


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Kit of parts - Excel version with weight? msbrockman Kit & Additional Hardware 2 16-01-2007 09:29
Excel Help for Scouting Database Faith Scouting 10 08-03-2006 17:02
Excel Attachments? Greg McCoy CD Forum Support 10 20-05-2004 07:35
KOP in EXCEL? jonboy Kit & Additional Hardware 1 20-01-2004 22:45
hey need some help with writing a code please help me here magical hands Programming 9 01-01-2004 21:46


All times are GMT -5. The time now is 23:36.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi