![]() |
|
|
|
#1
|
|||
|
|||
|
Columns A - "In date" B - "Out Date" & C contains the the "Networkdays",
column d is a gap column, column e is the Start date column and column f is the End date column, column g a gap column and columns H, I and J the returned data. I hope this makes sense. I have got a little further in solving this by using advanced filtering but is there any other method one could use by only using formulas? |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
LookUp
|
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
| Multi-Variable Lookup help | ebolton | Excel | 8 | 05-05-2011 05:28 AM |
Lookup a value from non-sorted data
|
udea | Excel | 12 | 04-25-2011 04:34 AM |
Using the LOOKUP Command
|
Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |
| Help with Max or lookup fomula to return a name forAmaxValue | dutch4fire23 | Excel | 0 | 07-28-2006 01:12 PM |