Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
eto po sample ng name
format: Lname,Fname Mname
napapasingit na lng po kpag may suffix po sia tulad nung mabutas may III, ung rebano nmn may space ung middle po
Mercado, Denise Natalie Fajardo
Mabutas, Vincent Peter Ramon III Santos
Rebano, Justin George Del Rosario
Mahirap yan gusto mo, kasi una ung raw data mo mali, isang column lang.
Sa lastname no problem, dahil lage my comma "," after nito.
Pero sa First at middlename wala kang makikita na fixed indicator kung pang first ba ito or for middle bukod sa space " ".
Na hindi ka naman pwede mag based dahil ang first name minsan hindi lang isang word. sample "Juan Miguel"
Kaya ang payo ko sayo, ausin mo raw data, pwede ka maglagay din ng comman or kahit anong special character para mahiwalay
ang firstname sa middlename.
or mas maganda Kung separate column/field sana ung First,Middle at Lastname, wala ka ng problem.
- - - Updated - - -
PS:
Ang suffix sa name like "Jr" "I" "II" etc. ay nilalagay after ng lastname nde sa firstname.
mga master! patulong meron akong workbook na may worksheet per year 2008 - 2015. per worksheet merong data from column A to F
A = Customer
B = Date
C = Receipt No.
D = Date Paid
E = Amount
meron akong 100k rows per worksheet.
hirap ako open per workbook kasi malaki yung file. gusto ko sana iextract yun specific customer at datas from B to E sa lahat ng worksheet sa ibang workbook. possible ba?
Mga paps paano ba to? Need ko kasi malaman kung ilan dapat ung need na manpower.
Given:
Reports: 15
Days: 6
Manpower: ?
Ano ba kailangan kong i consider to get the Manpower? Need pa ba ung Words per Minute & Kung gaano kadami ung words sa report? thanks
@ ohohOrmhel
Math Problem: - Suggestion
You must identify how many hours or days you need to finish 1 report per manpower.
pagnakuha mo na yun... you may now setup a formula that may satisfy 15 reports in 6 days.
Hope it helps ^_^
pa help naman po,gusto ko kasi macopy yung value from column L copy to F,G or H given na yung color sa column B ay kapareho nya.pero yung nasa column b ay may nailagay na ko na conditional formatting sa date nya View attachment 1069056