Re: Conditional colors ...
pls check the file attach hope this works
Re: Conditional colors ...
pls check the file attach hope this works
Re: please help--calculate the cycle
ok fix it
Re: please help--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....
Re: Copy data if row matches
Perhaps something like this? and using array formula......
regards
Re: Flip/Reverse data *with merged cells*
Try this one, with formula but just copy the values not the merged format..
regards
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.
Re: CountIFS greater and less than statements
Not sure :
=COUNTIFS($D:$D,U$1,$K:$K,"<>"&{"1","2","3","4","5"})
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
Re: Create list(s) from table of data
you're welcome, glad it help.......
cheers.......
Re: Create list(s) from table of data
Hi... hope this works
regards
Re: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup
Could be like this?
Re: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup
Please see this, hope this helps, all is array formulas.........
Re: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup
Ignore this
Re: Lookup Row, Then Lookup Value In Row & 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
Re: Copy and then sort list in alphabetical order
Another try with array formula.............................
Re: Excel Formula for Calculating Multiple Dates
Sorry for late reply, pls the file attach, hope it works
Re: Return column header
Perhaps something like this? Using array formula
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
Re: Array Formula is not working
Perhaps something like this? Using array formula.......................
Re: Count for unique criteria
Change to:
=COUNTIFS(Sheet1!$A$2:$A$17,$A2,Sheet1!$B$2:$B$17,"<>"&"")
on B2 and dragged down