Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering based on Value
I would like to combine these 2 into one formula
=IF(AND(ISNUMBER(FIND(LEFT(B20368,1),"JCR")),IF(SU M(COUNTIF(C20368, {"DST","LVN","DNM"}))0,TRUE(),FALSE())),I20368-0.01,J20368) =IF(OR(AND(B20368<"", ISNUMBER(FIND(LEFT(B20368,1), "AWFUY"))),OR(ISNUMBER(FIND("SHORT", G20368)),ISNUMBER(FIND("SHT", G20368))),SUM(COUNTIF(C20368,{"BOG","BLM","CMO"})) ),I20368-0.01, J20368) Each statement stands alone as far as filtering, so ISNUMBER(FIND (LEFT (B20368,1), "JCRAWFUY"))) won't work. The 1st 'True' test looks at Column B and looks for values starting with the Letter J, C, or R while at the same time checking for values in Column C that are either "DST","LVN","DNM" The Second Test looks at Column B and looks for values starting with the Letter A, W, F, U, Y. The test would also be True if Column G contains "SHORT" or "SHT". Finally check for values in Column C that are either "BOG","BLM","CMO" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a worksheet based on filtering of another? | Excel Discussion (Misc queries) | |||
Filtering data based on formula | Excel Discussion (Misc queries) | |||
Filtering Based on External Criteria | Excel Discussion (Misc queries) | |||
filtering based on a value in a cell | Excel Worksheet Functions | |||
advanced filtering based on entries ABOVE those I wish to keep | Excel Discussion (Misc queries) |