August 21, 2010

show information with link

Sample 1,Select the row want to be validaion.(Name is CourseColumn)
Data -> Validity -> Cell Range
key in =CourseColumn(the whole row A name)
then done ald.

Sample 2, Select the first 1 row let said is G2(Name is CodeColumn)
key in =OFFSET(DescriptionStart;MATCH(F2;CourseColumn;0)-1;1;COUNTIF(CourseColumn;F2);1)
and then copy it.
done agn.tht 1 is product code.

Sample 3,same with sample 2.this is PriceColumn(name)
key in =IF(G2="";CourseColumn;INDEX(PriceColumn;MATCH(G2;CodeColumn;0)))
ok ang.

when you choose the course name,the coursecode and te price will show it automatically.

Today's Visitors: 0 Total Visitors: 0
Personal Category: Uncategorized Articles Topic: learning / education / linguistic
[Trackback URL]

Post A Comment









Yes No



Please input the magic number:

( Prevent the annoy garbage messages )
( What if you cannot see the numbers? )
Please input the magic number

誰來收藏
Loading ...
unlog_NVPO 0