Getting result if any one condition match

1. Getting result if any one condition match

Hi All,

we have attached a sheet in that we want to if in column C,F,I,L have any blank cell then it will show column "A" value, we are getting the value with "if" formula and also getting the value with "Arrayformula" but if we use IF function then we need to drag and if use Arrayformula then we cant use that column because Arrayformula will show the error

We want only the value if condition meet and next sheet, basically we are creating a dashboard, no drag and no arrayformula
because we need to add and use other details also here

We have given a sample data only and we have large data, i mean we have column till "ND" and row 500

also posted in

2. Re: Getting result if any one condition match

You say the results are in sheet2, but sheet2 is empty?

3. Re: Getting result if any one condition match

If I understand you correctly, try this, copied down...
=IF(COUNTA(B3:M3)<>COUNTA(\$B\$2:\$M\$2),A3,"")

4. Originally Posted by FDibbins
You say the results are in sheet2, but sheet2 is empty?
Sorry, i have show the result in sheet 1, but i want in sheet 2

5. Re: Getting result if any one condition match

just check this formula, its good for me, short & easy formula and thanks for that

but we need to drag this for getting the complete result, we have used this formula in attached sheet in A18 but after that we need to drag it for getting the other result, i mean A19,A20,A21

can we get it without drag and drop

note:Arrayformula not required

6. Re: Getting result if any one condition match

You can try this macro:
``Please Login or Register  to view this content.``

7. Re: Getting result if any one condition match

Originally Posted by Ajay45822
just check this formula, its good for me, short & easy formula and thanks for that

but we need to drag this for getting the complete result, we have used this formula in attached sheet in A18 but after that we need to drag it for getting the other result, i mean A19,A20,A21
Looks to me like my suggestion is giving you exactly what you have in A10:A13. What is it not doing that you want it to do?

8. Re: Getting result if any one condition match

I take it this did work for you then?

Thanks for the rep

9. Re: Getting result if any one condition match

Thanks FDibbins, its working

10. Re: Getting result if any one condition match

A2 (in sheet2)
=IFERROR(INDEX(Sheet1!\$A\$1:\$A\$7,AGGREGATE(15,6,ROW(Sheet1!\$A\$1:\$A\$7)*(1/IF(ISBLANK(Sheet1!\$C\$1:\$C\$7)+ISBLANK(Sheet1!\$F\$1:\$F\$7)+ISBLANK(Sheet1!\$I\$1:\$I\$7)+ISBLANK(Sheet1!\$L\$1 :\$L\$7),1,0)),ROW())),"")

Press Ctrl-Shift-Enter for an array formula.

Regards.

11. Re: Getting result if any one condition match

@ Menem

Do NOT remove possible solutions - they are all helpful and useful. Thanks.

There are currently 1 users browsing this thread. (0 members and 1 guests)