| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I compare 4 cells at one time ?
Dear Sir,
If I want column E to return with "OK" when cells at each row has identical entry from column A to D, otherwise return with "Error". A B C D E 1 K21 K21 K21 K21 OK 2 RQ1 RQ1 RX3 RQ1 Error 3 H6U K8Y K8Y H6U Error What formula must I input at cell E1 and copy down to get the answer? Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : How to eliminate the time value after the date ? | Excel Discussion (Misc queries) | |||
| Is arithmetic on time data possible in Excel 2002? | Excel Discussion (Misc queries) | |||
| time v cost calculation in Excel 2002 (XP) | Excel Discussion (Misc queries) | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| How can I add up time, say 18:00 + 18:00 hrs in excel 2002 | Excel Discussion (Misc queries) | |||
Threaded Mode
