Melakukan sejumlah pekerjaan Excel Mampu mengoperasikan Ms Excel Mampu mengoperasikan Ms Word Mampu mengoperasikan Adobe Photoshop ++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw ++mengoperasikan Ms Excel dan menguasai VBA project dan formula pada excel.
We are looking for consultants to help us with some urgent short term projects. Using your well established, expert cosmetic formulation skills, you will assist us in reformulating existing products to meet key product performance criteria. This may including sourcing raw materials in line with our strict ethical requirements.
I need (IN EXCEL) to know when two times overlap. Please see image for visual example. Below is written example. 1) You will notice that Sales Person 3 and Sales Person 4 both worked a shift. 2) There was overlap from 08:03 thru 08:21 3) There was no overlap from 8:00 to 08:03 4) There was no overlap from 8:21 to 08:22 I need to know (REQUIRED) 1)
i have csv files, in one file is categories for opencart, in another file is products. Problem is, in categories file , all categories have numeric ID. but in product file categories have also numeric ID, but subcategories is just as text. i need it to import in opencart (i have module) , but i need it convert categories and subcategories in opencart>style>to>import
I have excel file for some calculation, I need a single formula for calculate no of days. Like Opening day-closing day = no of days. This is simple task, I wanted to know about your experience formula so that I can use you in future. File is attached.
...I want to automatically convert in another format in excel and calculate the total time. The source will always be in the "Employee attendance" format and should be converted to the Proper Format workbook. We should be able to copy new time data in the Employee Attendance format and the excel workbook Proper Format should be automatically generated
I need an excel expert to create an excel file that allows the follow: - I have 3 lists of words (40 words on each) - I need excel to randomly select 30 words (10 of each block) without repeating them. All in the same space (so I can easily copy and paste).
...distinct Name's automatically from the records tab The "Example Results I Want" tab shows what should be the end results you program into the Results tab This must work in Excel 2007 and Deadline is Thursday the 19th The Date column is used to get the records only for a date period I want The Name column list here is automatically generated from finding
Summarize data from excel file into a summary report (template provided). Can either be done by script, formula or manual entry. Summary reports can be either on a single sheet or an individual sheets for each header. Summary report(s) to be filterable on dates.
I need the formula written for Microsoft excel that will do the following: I do not know the correct way to express my formaula professionally but i have tried to write it our below. I am willing to discuss with you any questions before you start. At this point there are 2 excel spreadsheets involved. (sheet1 and shee2) i have put this after each
Requirment: Understand excel well and conditional formatting Requirements: Help me create a formula that changes row colour based on value in a cell Help me create a formula that sums up values based on cell colour Help me do this via a screenshare / zoom if possible
1. Add Header and FooterMS Excel allows us to keep header and footer in our spreadsheet document.2. Find and Replace CommandMS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.3. Password ProtectionIt allows user to protect their workbooks by using password from unauthorized
...platform: 1- Ecommerce platform must accept payments and execute each transaction as seamless as possible keeping safety in mind. 2- Inventory UPDATE should be manageable via EXCEL seamlessly (With very little effort). ** THIS PART IS VERY IMPORTANT ** 3 - Should have the ability to list each product with price. Should have the ability to CONTACT SELLER
Would like to setup a formula for the following excel file. If columns E+F is between 0-9.99, column I should be [(E+F)*4 ]+ (H*175).... (Assuming H is 1. If H is greater than 1, the second half should be (1*175) + ((H-1)*150). Also want to include the following in the same formula... If columns E+F is as below, it should be multiplied as stated below
Hi Team, I need somebody to write a complex formula that will look up barcodes and return the results accordingly. I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas. Watch the video of what I want: [login to view URL]
I have a spreadsheet that has needs to be sorted into multiple sheets. I don't think it's extremely complicated, but more than I can do. There are only 3 columns. I need to pull info from the first column - but not based on the entire col A info - not day, date - just the name of the city.
I need an excel workbook for pricing steel buildings. We have set dimensions with attached prices and add-on items. Want to be able to check a box for the height, width, height, roof style certified/noncertified, etc and have the formula calculate the price based on the selected options.
I have a excel file and a test Power BI. I need help to create a DAX formula to calculate attrition. The test file has a hire date and a term date. Need to get the start headcount by removing anyone hired during the selected month or quarter or in the future. Remove any terminated employees that were terminated during the month or quarter selected or
I need a formula/query in Access that will give me the same result as the attached excel file for column B. This would be in an update query where B would be the calculated field. In excel, the formula would be Countif(B$2:B2,B2) and would drag down so that the result would show the number of times that field has been seen above. I have millions of
...complex formula. I have a good understanding of Excel, but when it comes to very complex formulas I need some help. Basically I am looking for someone that can hop on a screen share video conference occasionally and I can go down several questions I need solutions for. Happy to discuss different pricing structures (by hour or half hour, by formula, etc)
I have a spreadsheet, 1st column is dates & time, 2nd and 3rd column are numbers. I want to a) average the data in columns 2 & 3 when the date in column 1 matches a date in a column I've made somewhere else; I also want to find the min and max for the column 2 & 3 data. The data have been gathered every few minutes. I want to graph as avg, min or max per every 24 hour period. ...
I have a spreadsheet that i am trying to use a formula to assign a number to duplicate rows. I need someone to show me the correct formula. Easy money for someone.
Looking for a Freelancer to use provided Excel template and columns H:M to identify winning (Yellow highlighted) and losing (Red Highlight) patterns for every horse (broken down by rows) in the spreadsheet. There should only be 2 patterns/algorithms per horse. Please make sure that your solution is formula based so new data sources can use. Preferably
Looking for a Freelancer to use provided Excel template and automate data manipulation for rest of spreadsheet using the following instructions 1. Complete 4 columns C:F using information contained within every second row in column B. 2. Using Yellow conditional formatting for where column A has an entry starting with "1 of" 3. Use Red conditional
Have excel sheet. I need to remove the name based on slowest time. i.e in this case, it will be 0.79 for ausbred and 0.85 for sapeince. But there could be 100's of duplicates that are grouped in the distance field. 800M Ausbred Petal 0.75 Ausbred Petal 0.79 900M Sapience 0.84 Sapience 0.85 I need the formula now. I don't have time to
Hi, I need an excel sheet creating that I am sure will take minutes for someone with excel skills, I have non and not enough hours in the day to learn. I can download data in CSV format I then need to import it to excel and create a simple formula if actual number is greater than previous and greater than consensus give it a score +3 if actual
...quick and simple project for an analyst or expert in Excel to add formula to Excel template to populate it to show the revenue received from orders placed by customers. See the video blow that describes the background and the requirements. [login to view URL] An Expert in Excel should take no more than 15 - 20 minutes to populate
Need formula for google sheets I have a link attach to this. - need to get the sum from T2:T49 for cell O54 but sum need to be filtered by services from column S2:S49. - need to get the sum from T2:T49 for cell O55 but sum need to be filtered by Insurance from column S2:S49. -need to get the sum from T2:T49 for cell O56 but sum need to be filtered
Important: IF YOU KNOW YOU CANT DO IT, PLEASE, DONT BID!!! Check the video with the task. Need to use the code function of wpDataTables (the function that imports excel and csv files) so it works for users from Frond-End too, in 2 steps(select the file and import it, showing it right away in the Front-End). Also need to use the function of WooImporter
...using various formula and reporting the data on a web page for each individual logger in a graphical format including dials and graphs (similar to the pictures). There must be an administration section for maintenance which can access all loggers for configuration and viewing. The platform must email the customer every month with an excel compatible file
...the macro, MS Access will export summary report in excel format and exit open 1st excel and copy data form particular sheet and range open 2nd and past data in required raw or column or end of the previous data refresh pivot table and formula select a fixed range data and copy form 2nd excel open outlook new mail and past on the mail body
I have some work, in an Excel spreadsheet. Hi I have excel sheets. I wanted to merge coloumns in Address field. Experienced formula candidate contact me. This is a small fee project. If you are on the right path I have more projects like data mining etc. upcoming [login to view URL] me soon. Budget: 5USD Regards Scott.
Hi I have excel sheets. I wanted to merge coloumns in Address field. Experienced formula candidate contact me. This is a small fee project. If you are on the right path I have more projects like data mining etc. upcoming [login to view URL] me soon. Budget: 5USD Regards Scott.