# Posts by azumi

• ## Conditional colors ...

Re: Conditional colors ...

pls check the file attach hope this works

ok fix it

• ## calculate the cycle

Put in E2 and copied down :

=IF(A2<>0,IF(A2=0,0,IF(COUNTIFS(\$A\$2:\$A\$41,A2)=2,COUNTIFS(\$A\$2:A2,A2),COUNTIFS(\$A\$2:A2,A2)+1)),IF(B2<>0,IF(B2=0
,0,IF(COUNTIFS(\$B\$2:\$B\$41,B2)=2,COUNTIFS(\$B\$2:B2,B2),COUNTIFS(\$B\$2:B2,B2)+1)),IF(C2<>0,IF(C2=0,0,
IF(COUNTIFS(\$C\$2:\$C\$41,C2)=2,COUNTIFS(\$C\$2:C2,C2),COUNTIFS(\$C\$2:C2,C2)+1)),IF(D2<>0,IF(D2=0,0,
IF(COUNTIFS(\$D\$2:\$D\$41,D2)=2,COUNTIFS(\$D\$2:D2,D2),COUNTIFS(\$D\$2:D2,D2)+1))))))

or more clear see the file in attachment, hope the best....

• ## Copy data if row matches

Re: Copy data if row matches

Perhaps something like this? and using array formula......

regards

• ## Flip/Reverse data *with merged cells*

Re: Flip/Reverse data *with merged cells*

Try this one, with formula but just copy the values not the merged format..

regards

• ## Populate Table/Matrix

Re: Populate Table/Matrix

Perhaps like this? Im modified the formula, nothing wrong with formula but you have several extra spaces on Region on Sheet 1 and Sheet 2, try to remove them.

• ## CountIFS greater and less than statements

Re: CountIFS greater and less than statements

Not sure :

=COUNTIFS(\$D:\$D,U\$1,\$K:\$K,"<>"&{"1","2","3","4","5"})

• ## Moving data from column B:B into a new column

Re: Moving data from column B:B into a new column

Perhaps something like this? Using array formula and 2 different colors 2 different formula...

regards

• ## Create list(s) from table of data

Re: Create list(s) from table of data

cheers.......

• ## Create list(s) from table of data

Re: Create list(s) from table of data

Hi... hope this works

regards

• ## Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup

Re: Lookup Row, Then Lookup Value In Row &amp; Return Column Header: Two Way Lookup

Could be like this?

• ## Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup

Re: Lookup Row, Then Lookup Value In Row &amp; Return Column Header: Two Way Lookup

Please see this, hope this helps, all is array formulas.........

• ## Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup

Re: Lookup Row, Then Lookup Value In Row &amp; Return Column Header: Two Way Lookup

Ignore this

• ## Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup

Re: Lookup Row, Then Lookup Value In Row &amp; Return Column Header: Two Way Lookup

If I understand you correctly, put this on B6 on Sheet2:

=IFERROR(INDEX(Sheet1!\$C\$1:\$F\$1,SMALL(IF((Sheet1!\$C\$3:\$F\$8=B\$5)*(Sheet1!\$A\$3:\$A\$8=\$B\$2)*(Sheet1!\$B\$3:\$B\$8=\$B\$3),COLUMN(Sheet1!\$C\$3:\$F\$8)-COLUMN(Sheet1!\$C\$3)+1),1)),"-")

and press F2 button so you'll see the formula, after that press/hit CTRL+SHIFT+ENTER button/key all together, ENTER alone not working, if success you'll see bracket like this "{formula}".
This called array formula, final step copied cross as necessary

• ## Copy and then sort list in alphabetical order

Re: Copy and then sort list in alphabetical order

Another try with array formula.............................

• ## Excel Formula for Calculating Multiple Dates

Re: Excel Formula for Calculating Multiple Dates

Sorry for late reply, pls the file attach, hope it works

## Files

Perhaps something like this? Using array formula

• ## Excel Formula for Calculating Multiple Dates

Re: Excel Formula for Calculating Multiple Dates

Can you post small example workbook? For clear explanation and type manually for the exoected results, to attach the file click "Go Advanced" button and find paperclip image button.

regards

• ## Array Formula is not working

Re: Array Formula is not working

Perhaps something like this? Using array formula.......................

• ## Count for unique criteria

Re: Count for unique criteria

Change to:

=COUNTIFS(Sheet1!\$A\$2:\$A\$17,\$A2,Sheet1!\$B\$2:\$B\$17,"<>"&"")

on B2 and dragged down