| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
and function
I'm trying to compare 2 worksheets into a third using this basic formula...
=IF('Latest Fosia'!G3='DVE open'!F4:F151, "On Both", "On Fosias" ). I need to check in the reverse so =IF('DVE open'!F117='Latest Fosia'!G3:G500, "On Both", "On DVE"). how can I combine these 2 into one formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and function
Please explain 'Latest Fosia'!G3='DVE open'!F4:F151
Do you mean you want to check if all the cells F4:F151 have the same value as the single cell G3? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Paul" wrote in message ... I'm trying to compare 2 worksheets into a third using this basic formula... =IF('Latest Fosia'!G3='DVE open'!F4:F151, "On Both", "On Fosias" ). I need to check in the reverse so =IF('DVE open'!F117='Latest Fosia'!G3:G500, "On Both", "On DVE"). how can I combine these 2 into one formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
