|
|
|
 One of the reasons, we hate being from Hawaii. - waialua359 [more] |
 |
|
|||||||
|
||||||||
 |
|
|
Thread Tools | Rate Thread | Display Modes |
|
|
|
| One of the reasons, we hate being from Hawaii. - waialua359 [more] |
|
|
|||||||
|
||||||||
|
|
|
Thread Tools | Rate Thread | Display Modes |
|
|
|
#1
|
||||
|
||||
|
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. |
|
#2
30-01-2007, 22:50
|
|||||
|
|||||
|
Re: Help with excel
That is exactly what I was thinking. I was thinking you would have to macro it because the way it is formatted right now it will only work for one sheet for one match at a time making his whole set up kind of useless. Maybe if he wanted to do it similarly without a macro he could make about 50 matches or rounds worth of records but I beileve what you suggested would be the best. Thanks for helping.
Pavan. Pavan. |
|
#3
31-01-2007, 13:06
|
||||
|
||||
|
Re: Help with excel
I decided to abandon excel if statements last night and went straight to VB code. So thanks for all your help, I think I've got it now.
|
|
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
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 |
Hybrid Mode
