Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default IF

I am working w/ a Master spreadsheet, consisting of 80 rows and 20 columns.
The first column has a name. The other columns consist of text, numbers and
dates. My goal is to calculate the time difference between dates if one or
more conditions from the other column(s) are met. The calculation for the
conditions (nested ifs/ands and difference between dates) are no problem.

What I would like to do though is do the calculation on a separate worksheet
if the conditions are met. That way, the new worksheet only has a subset of
the calculations and no blank lines. I don't mind going back to get the
numbers for the calculations using vlookup, I guess I am trying to create the
subset of names that meet the criteria to make it cleaner.

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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



All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"