# Posts by junho lee

• ## Coloring X,y,z Values

Re: Coloring X,y,z Values

regards,

• ## Matching An Approximate Number

Re: Matching An Approximate Number

=(INT((A1-5)/10)+1)*10
regards,

• ## Coloring X,y,z Values

i make cubic path with 30step(each x,y,z axes have 10steps, 30steps total)
first, use rnd() fxn
second, sort x,y,z each and use rank() fxn.
third, coloring
how to color x,y,z axes with sorted x,y,z values.

• ## Match & Sort`

Re: Match &amp; Sort`

regards,

• ## Copy From Web Page & Keep Links Live

Re: Paste Special

perhaps,
regards,

• ## Filter By Multiple Criteria

Re: Event Filtering

nice to meet you,

regards,

• ## Round Up To Nearest X`

Re: Round Up To Nearest 45 Or 95

15000*1.43=21450
but result is 21495 with both fomula.
regards,

• ## Assign Formula Values Based On Variables

Re: Assigning Values Based On Two Other Variables

=if(b7=b10,if(b7=1,...if(b7=2,...if(b7=3....))),if(.............)))))))
this shouldnt work?
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

activate sheet,wrongway,after insert sheet 1
and run

regards,

• ## Vba Sorting Algorithms

Re: Vba Sorting Algorithms

as i know,
f=1 to 99
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

here's compressing table(post#29)

regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

i dont know what the fomula makes table on the lower part.
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

2.run. create report.
3.simple data range_ input_01/31/2006~12/31/2006
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

1.in sheet2,total is not solved.
2.sheet2,a7 cells,"blank" is deleted.
4.M-Q-Y Report Template is sheet2.
5.participant master list is sheet1.
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

updating is like this?
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

i'm not sure this is correct,
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

=SUMPRODUCT(--(Sites=\$A12),--(Dept=C11),--(tCount>0))
replace
=IF(VLOOKUP(A12,A4:C8,3)=0,0,SUMPRODUCT(--(Sites=\$A12),--(Dept=C11),--(tCount>0)))
it will works?
regards,

• ## 2-dimensional Date Range With Dynamic Copy And Paste

Re: 2-dimensional Date Range With Dynamic Copy And Paste

http://www.exceluser.com/explore/arrays1.htm
make some change...
regards,

• ## Calling A Subroutine

Re: Calling A Subroutine

i pointed with pointer on added itembutton ,and moving slightly up and down in the left of text ,then [COLOR="Red"]x[/COLOR] appears.