excel macro programming

• alexgutz on May 08, 2013 11:14 AM

  @okiorayt
  me option naman ang excel sa sorting na by priority.
  so pwede mo sya i sort first by date, then supplier, then....
  di nga lang sya automatic kasi kailangan mo i copy sa another sheet then manual sort, pero yung sorting is very fast...ilang click lang ito at OK na...
  
  -- edited by alexgutz on May 08 2013, 11:22 AM

• me_ako on May 08, 2013 03:47 PM

  RP
  
  Question mga ka-TPC
  
  Pano mag round up sa excel, tapos ung lalabas ung upper limit ng range
  
  For example
  
  input rounded
  0.24 0.25
  0.89 1
  0.55 0.625
  
  Yung lalabas multiples of 1/8 (0.125, .25, .375, .5, etc..)
  
  Thanks!

• alexgutz on May 08, 2013 04:03 PM

  una e i multiply mo ng 8
  then kunin mo lang yung integer value nya
  then mag add ka nang 1
  then i divide mo ng 8
  ex = [int(value * 8)+1]/8

736 active users within the last minute, 465 members, 271 guests.
Our newest member is armo
Click here to see online members.